rvfowler2
asked on
FM - Find Operators?
Searched FM Help, as well as EE and cannot find a list of simple Find Operators. Do they exist? My boss wants to be able to search in a two-digits PropCode field, for let's say GR and AB and have the result show both. I can script this with a constrain or extend found set, but seems much easier if there is an OR operator or an AND operator in Find mode. Any suggestions?
All you have to do it create a second "Find Request". For example, go to Find mode and enter "GR" and then hit Control-N or "Add New Request" from the "Requests" menu (which appears as the Records menu when you are in Browse mode). In the new request, enter "AB" and then click "Continue". Entering multiple requests functions as an "OR" request. You can do as many additional requests as you like.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Maybe that works for scripting, but to me that is not nearly as user friendly as entering an operator. Most other sw that exists uses operators, such as OR | , ; and I've tried all of these and none work. Even tried inserting the calcs paragraph mark. Makes no sense why they use some operators, such as * or = but not ones for "or" or "and". A real shortcoming in FM. Let me wait for one other response to see if anyone knows an operator that works.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, I tried it. Agree that it is easier and less problematic for a novice user, but not for power users. Not sure why they have some operators and not others. Even can use ... between beginning and ending dates. Still seems like a limitation in FM to me, but will work with wha they've got. Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, thanks, I was aware of the save finds.
ASKER
Thanks for answering the question and for the additional info on Filemaker Finds.