• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 591
  • Last Modified:

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?
0
rvfowler2
Asked:
rvfowler2
  • 4
  • 4
3 Solutions
 
Will LovingPresidentCommented:
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.
0
 
Will LovingPresidentCommented:
You also effectively do a Constrain in a single Find operation by first creating one or more Requests for what you want to find, for example "GR" and "AB" and then entering additional requests marked as "Omit" instead of "Include" under "Matching Records" in the status area. Using Omit Matching records removes any records matching that request from the Find results. Always put your "Include" Requests first and your "Omit" requests after. In your example if you wanted to find all GR and AB and then Omit any with zero balances due, you would create the first two requests as "Include" and then create a third request set to "Omit" and enter zero or "=" in the balance due field. This Finds the first two requests and then Omits the third.

An "AND" request is accomplished by simply entered values in more than one field in a single Find Request.
0
 
rvfowler2Author Commented:
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.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
Will LovingPresidentCommented:
Randy, it's not just for scripting, it's very fast and also easy to train people to do (something I do all the time) and in some ways I think it's easier than using an operator. If someone wants an "OR" Find they just enter the first criteria, hit Control-N (or Control-D to duplicate), enter the second criteria and then hit Enter. FileMaker shows you the number of Requests in the status area just like there are records and lets you flip through, edit and delete them. Try the example you gave and you'll see how easy it is.

And to my knowledge, there is no "OR" operator that lets you enter two values in the same field a single Find Request. FM just doesn't work that way. But the way it does work is simple and logical if you understand it and don't try to make it work like something else.
0
 
rvfowler2Author Commented:
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.
0
 
Will LovingPresidentCommented:
I'm not sure if you are aware of it, but FM also has the ability to "Save Finds". If you have it enabled, FM can name and save a specific Find, including multiple Include and Omit requests, and it does so for each user account. So no matter where you log in from, you save requests appear in the list. This allows a user to save the Finds/Searches that they need regularly without having to do scripting.
0
 
rvfowler2Author Commented:
Yes, thanks, I was aware of the save finds.
0
 
rvfowler2Author Commented:
Thanks for answering the question and for the additional info on Filemaker Finds.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now