servebot Posted November 1, 2004 Share Posted November 1, 2004 I'm having trouble scripting a combination AND OR search using FileMaker7. For example: A search for all records where Parameter_1 is A or B or C, AND where Parameter_2 is 1 or 2 or 3. Done correctly, this should find those records matching all nine permuations of the search criteria (A1, A2, A3, B1, B2, B3, C1, C2, C3). Hope this makes sense. Any advice? Thanks for your help, Michael Link to comment Share on other sites More sharing options...
RodinBangkok Posted November 1, 2004 Share Posted November 1, 2004 Do a perform find script step for the first set of OR's then follow that by a contstrain found set step for the second set of OR's. For the OR's use the add new request for each OR required. Rather than scripting by keyboard perform the first find using the proper layout in find mode, then go into the script select the perform find step and the parameters you just used should show up in the menu. Do the same for the contrain step. Rod Link to comment Share on other sites More sharing options...
RalphL Posted November 1, 2004 Share Posted November 1, 2004 ANDs use the same request, ORs use new request. Thus you will need 9 requests. Your script will look something like this: Enter Find Mode [] Set field [1, "A"] Set field [2, "1"] New request Set field [1, "A"] Set field [2, "2"] New request Set field [1, "A"] Set field [2, "3"] New request Set field [1, "B"] Set field [2, "1"] New request Set field [1, "B"] Set field [2, "2"] New request Set field [1, "B"] Set field [2, "3"] New request Set field [1, "C"] Set field [2, "1"] New request Set field [1, "C"] Set field [2, "2"] New request Set field [1, "C"] Set field [2, "3"] Perform Find [] Link to comment Share on other sites More sharing options...
-Queue- Posted November 1, 2004 Share Posted November 1, 2004 You can use Duplicate Record/Request to streamline it. Enter Find Mode [ ] Set Field [1, "A"] Set field [2, "1"] Duplicate Record/Request Set field [2, "2"] Duplicate Record/Request Set field [2, "3"] Duplicate Record/Request Set field [1, "B"] Duplicate Record/Request Set field [2, "2"] Duplicate Record/Request Set field [2, "1"] Duplicate Record/Request Set field [1, "C"] Duplicate Record/Request Set field [2, "2"] Duplicate Record/Request Set field [2, "3"] Perform Find [ ] Link to comment Share on other sites More sharing options...
servebot Posted November 1, 2004 Author Share Posted November 1, 2004 Ralph's method works, but I need something more flexible, since users will be entering their own combinations of values. Rod's method works perfectly, but I need to automate this with a script. Is there a way to perform or simulate "add new request" in a script? --------------- Thanks, Michael Link to comment Share on other sites More sharing options...
-Queue- Posted November 1, 2004 Share Posted November 1, 2004 You can have the search done in Browse Mode using globals. Then use the script steps above, substituting your global field names for A, B, C, 1, 2, 3 (and don't use quotes). New Record/Request is the step you seek. Link to comment Share on other sites More sharing options...
servebot Posted November 2, 2004 Author Share Posted November 2, 2004 The script works! The "New Record/Request" step was exactly what I needed to make this work. Thanks everyone. ----------- Michael Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7116 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now