It there an easy way to simulate a multipart match relationship using find instead?
If I have
Owners::State < - > Restrictions::RestrictedStates
How can I simulate this using find instead?
You can script the find alright*, but why not let the/a relationship work for you?
Assuming that the field RestrictedStates holds one or more values that can match an owner state, if you have a relationship that is based on these two fields, you can perform a simple
Go to Related Record [ matching only ]
*Write a script that within a loop generates one Find request per value, all of which are then executed as a Boolean OR, i.e. find all records where owner state is one of the values.
Got it that's exactly how I was doing it (with GoTo Related Record) but wondered if there was a script step that could do it. There should be one so that you don't have to create the extra tables just to narrow it.
Thanks for the confirm!
There can be times when GTRR can't do what's needed--such as when you need to further constrain a found set instead of creating a new one.
There can be found a working example of the looping script mentioned in the following discussion that will find all records that have at least one of the listed values specified as criteria:
Scripted Find Examples
Retrieving data ...