Hi Experts
I'm working with a few collections in the front end, and I would like to know is it possible for me to write "normal" SQL queries to join them and query get data from them? At the moment, one of my collections has nearly 20k objects and I need to populate another collection based on that one. To do this, I use a ForEach iteration over it which takes a long time. I need to lookup stuff in a few more collections in each loop iteration - it would be great if I could just do a select statement and join the various collections in memory which would be so much more efficient.
Is this possible?
Thanks
Kin
