Jump to content
Sign in to follow this  
brundlefly

Complex Find within a Find using Show

Recommended Posts

I have a user in my office who need to do a complex Find in our very large databases using many related fields. This looks like it will take a lot of time.

Simplified database setup:

Database A contact ID, contact name, title & status

Database B contact ID, event & year

My script is as follows:

I do a Find in Database B to find specific events & years. I then switch to a layout in Database B that has only the contact ID on it and perform a copy all records. I switch back to Database A and paste into a global field. I have a relationship set up between this global & the contact ID field of Database A. I perform a Go to Related record [show only related] script step. The resulting found set is the list of contacts that attended the events I chose. This is faster than Finding on the related fields in a portal.

Anyway, I now want to Find only those contacts with specific Titles in this found set so I use the Show event found in Applescript. This works fine.

My problem is that this is for a user in my office who needs to find MULTIPLE titles in this found set. Adding to the problem is the fact that the number of titles needed is variable (it could be 3 one time but 7 another). I can script Applescript so that the user can enter these multiple titles but I do not know how to get the Show statement to use them.

My show statement in the Applescript is as follows:

show (every record whose Status =

Share this post


Link to post
Share on other sites

Personally, I wouldn't use AppleScript for this. I would mark the records that were found with your Go to Related record, and then construct the rest of the find manually using ScriptMaker to access global fields from the user's input. If all the fields being searched on are indexed, then this should be slow.

Chuck

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    PathGeek 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.