So much good stuff in this article. From JSON building summary techniques, the While function, fast sorting on related records, fast summaries, recreating a found sets for PSOS scripts, passing large parameters/results, etc. Definitely worth the read and examining the demo files.
Today we’re going to compare various methods one might consider employing to render an arbitrary found set as a JSON object.
URL https://filemakerhacks.com/2020/09/07/render-found-set-as-json-object/