This is a quick post to say that JSONQuery 2.0 is finally here with many new features, and some improvements to existing features as well.
What is JSONQuery?
A FileMaker custom function authored by Steve Senft-Herrera that enables you to query JSON (works with FM 18+).
Basic Things JSONQuery Does
1) Query – Allows for finding elements that match a supplied value, with a variety of options for operators.
2) Aggregate – Allows for returning an aggregate, e.g., SUM, AVG, LIST, etc., of values taken from either the matched elements, or all of the input.
3) Transform – Allows for customization of how the results are returned, with the option to pick-and-choose what attributes are included in the output, and how they are named.
