Solved

FM - Find Operators?

Posted on 2012-04-13
8
546 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 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 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 25

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
 
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 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
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…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

809 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