I can think of a couple approaches, depending on a few factors.
One method would use the ValueListItems( fileName ; valueList ) function to ascertain the values of the list used by the field and store them in a variable (or, of it is a short list, just set the variable to a return-delimited list of those values, such as "Active/Inactive/Pending"
Step 2 would be to perform a script that generates successive requests by looping through the values in the variable containing the value list items. Yes, you'll have to take into consideration whatever else your scripted search needs to accomplish, but this is the basic concept. Oh, and you might want to prefix each request criteria with the "==" symbol, to restrict the search to exact matches.
Another approach is to use a calculation field to store a boolean flag that indicates if the entry in the "Status" field is in the value list. Again, this is simple if your value list is short, like as mentioned above. As with the above approach, you could use an auto-enter number calculation using the ValueListItems function. Your search then, would only need to look for the boolean value (1 = entry is in the list; 0 = not in the list). This does require an additional stored calculation field only for this purpose. Also, if your value list isn't static, this method won't work.
I hope I'm clear enough in describing this as a quick sketch.
Hi Erik thanks for that ... Thanks for your good answer ..Im trying to get my head around it..so thanks