?
Solved

FM - Find Operators?

Posted on 2012-04-13
8
Medium Priority
?
561 Views
Last Modified: 2012-04-13
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
Comment
Question by:rvfowler2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 25

Expert Comment

by:Will Loving
ID: 37843258
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
 
LVL 25

Assisted Solution

by:Will Loving
Will Loving earned 2000 total points
ID: 37843284
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
 
LVL 2

Author Comment

by:rvfowler2
ID: 37843304
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 25

Accepted Solution

by:
Will Loving earned 2000 total points
ID: 37843379
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
 
LVL 2

Author Comment

by:rvfowler2
ID: 37843421
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
 
LVL 25

Assisted Solution

by:Will Loving
Will Loving earned 2000 total points
ID: 37843495
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
 
LVL 2

Author Comment

by:rvfowler2
ID: 37843540
Yes, thanks, I was aware of the save finds.
0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 37843561
Thanks for answering the question and for the additional info on Filemaker Finds.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question