AnsweredAssumed Answered

Getting a list of ids

Question asked by JavierDura on Jan 3, 2015
Latest reply on Jan 17, 2015 by JavierDura

Hi.

I have a set of found records and I want to set a global variable with a List of all their ids. Something like:

 

ACAB47A2-D856-DF4A-9D8F-BD55E3BF653A

8813CE6C-6907-3C44-8E36-52DCE400502B

693A527E-0148-3E41-BD93-8E14A323E257

483313C6-B829-504C-AFF2-4F6B0CDFF0D1

 

The solution is hosted by FileMaker Server 13.

 

I am considering several approaches:

1.- Using Execute SQL: first I should “mark” the found records so I can SELECT them.

2.- Using a script: a loop that goes through the found set and takes the id of each record.

 

Which one will run faster?

Any other suggestions?

Maybe a little bit of “Perform Script on Server”?

As this variable will have hundreds of ids, I need to be as quick as possible.

 

Thanks!

Outcomes