find in ()

[jimlongo]

Is there a way to do a find that is similar to the mysql type WHERE field IN()

Each record in a table has an unique ID and I'd like to find many in one operation.  It seems like this would be a common find operation, but I can't find any mention of it.

 

select * from `table` where `id` IN (1,2,3,4,5)

 

[LAIRY]

Hi jim

Here is a demo :

https://filemakerhacks.com/2012/12/15/executesql-using-in-with-faux-dynamic-variables/

May help ?

G

[comment]

3 hours ago, jimlongo said:

Each record in a table has an unique ID and I'd like to find many in one operation.

I am assuming you mean a "regular" Filemaker find, not ExecuteSQL? If so, this would be performed as any OR find: by creating a separate find request for each item on the list.

Another option is to place the search values, separated by carriage returns, in a global field and define a relationship matching the global field to the ID field in your table. Then you can use the Go to Related Record [] script step to create a found set of matching ID's only.