Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

FM - Find Operators?

Posted on 2012-04-13
8
Medium Priority
?
569 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

598 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