Find multiple records in a field

[bv2000]

I have an ID field and want to find all IDs that start with SMIT JONE WILS and want to do it simultaneously. How do I phrase that from within a "FIND

 

[JeanW]

If your 'simultaneously' is within the found set, like:

Find all the records with 'SMIT', in this range find all the records with 'JONE' and in this found set find all the records with 'WILS', you need to constrain or narrow the found set.

1. Perform a find so that your database contains the found set for SMIT.
2. Switch back to Find mode and make the criteria to narrow the search to JONE and choose Requests menu > Constrain Found Set.
3. Switch back to Find mode and make the criteria to narrow the search to WILS and choose Requests menu > Constrain Found Set.

There you have the constrained found set.

If your 'simultaneously' is broadening the found set, like:

Find all the records with 'SMIT', all the records with 'JONE' and all the records with 'WILS', you need to extend the found set.

It's the same as above, just replace Requests menu > Constrain Found Set, by Requests menu > Extend Found Set.

 

[bv2000]

It seems that if i had to find 10 specific names that I wanted for a report, it would take 10 separate find requests to do that. Isn't there a way to do it with one find request. When I was using Approach i could perform a find for many criteria in the same field separated by a comma. for example: smit*,jone*,wils* -

 

[JeanW]

You can do this with the List() function or a valuelist based upon that field, to have a return separated list of unique values.

From there you can go with a global to find related records, to show in a list or in a portal.