I'd love to create a found set based a list of record IDs I got.
e.g. from SQL I got records and would love to display them in FileMaker. So I would like to pass the list of record IDs to build a found set.
I already posted this as GoToRecordIDs[recordIDs_list] Script Step
Please support it
I think it's also covered with New script step: open snapshot.
Would also love this command but there is already an easy and very fast solution to create a found set with the results of an ExecuteSQL:
1) Create a global TEXT field in the same table
2) Create a indexed calculation field that calculates the ID of every record AS A TEXT ("=ID" but result is text)
3) Create an internal link between the new global field and the calculated text field
If you then fill (with SET FIELD) the global text field with the found ID's list (result of an ExecuteSQL-command) and executes a GTRR, you have your found set in fractions of a second, even for a result of thousands of records
Retrieving data ...