Solved

FM - Find Operators?

Posted on 2012-04-13
8
524 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
  • 4
  • 4
8 Comments
 
LVL 24

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 24

Assisted Solution

by:Will Loving
Will Loving earned 500 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
 
LVL 24

Accepted Solution

by:
Will Loving earned 500 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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
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 24

Assisted Solution

by:Will Loving
Will Loving earned 500 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

746 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now