Find multiple values in one data field

[Dutchy]

Hi, can't seem to get my script right. Have set 6 values in a Status field (E/PI/O/M/C/F). For each record or project one can only fill in one of the above mentioned values. Now I would like to filter all records with a value E, PI and/or O in a separate layout (list view).

Made a constrain found set: Project::status [E] AND [PI] AND [O].

But than non are selected or found because there is no record which contains all three values. I know I am doing something wrong here but somehow I am not getting it. The AND should be OR???

Thanks in advanced, Dutchy

[mr_vodka]

Dutchy See here

[Dutchy]

Hello John, This doesn't seem to be working for me. I am not trying to search for one value in three different fields but searching for three different values in one field. In the field one can fill in 6 different values and I would like to filter out 3 of those in a table or list view.

It seems, I have to do something different then you proposed before? Can you help: I have tried everything I can think off and nothing is working properly. Thanks

Dutchy

[LaRetta]

You add a new Find Request and enter the second value in the SAME field, viz:

Enter Find Mode [ ]

Set Field [ yourField ; "O" ]

New Record Request

Set Field [ yourField ; "P" ]

...etc

[Dutchy]

I have know idea what I have been doing wrong all this time, but it is working now. Thanks a million, LaRetta and John.

Dutchy

[Dutchy]

Hi John,

New question concerning this post. I am trying to pre-fix a search or find button to search for records that have a status PI/O/E (status field) and are handled by a certain person, for example D (ID field). I would like this info to be pre-fixed because this search will be done often. However the name of the client can differ, so I need to keep the search open so that the client name can be filled in manually. The only script I can think of closes the find mode before I can fill in the client name. Can you help out? Hope I am clear? Here is what I have and is not working for me:

Enter Find Mode [project::ID;"D"]

Set field [project::status;"E"]

New Record/request

Set field [project::status;"P"]

New Record/request

Set field [project::status;"O"]

Preform find

Dutchy

[mr_vodka]

Create a global field so that the user can enter a name or in this case ID (gNameID).

Enter Find Mode []

Set field [project::ID; gNameID]

Set field [project::status;"E"]

New Record/request

Set field [project::ID; gNameID]

Set field [project::status;"P"]

New Record/request

Set field [project::ID; gNameID]

Set field [project::status;"O"]

Preform find []

This will find all records in which if "D" was the value of ID, would yield all of D's records where teh status field is "E", "P", or "O"

[Dutchy]

Problem solved, thanks

Edited March 28, 2007 by Guest