In weather readings find cities where temperature is higher than 25°C and the sky is clear.$..*[@..temp > 25 and @.clouds.all is 0].name
$points to the root of the document. It can be either object or a list of objects. ObjectPath queries works for both! Here the JSON document describes weather readings within provided geopraphic coordinates.
@points to current item from the list generated from executing expression on the left side of
. Here we check if temperature in each city is greater than 25°C.
..finds all objects in the subtree. Here it selects all objects from the readings.
*selects all objects from array. This is a helper for
.goes one level deeper into data structure (selects child of a parent). In conjunction with property name like
.tempand array of objects it returns array of values under each object's
tempattribute.More at paths reference
is an advanaced tool for filtering lists of objects. It can do almost anything! More at selectors reference
Easy to start with and suitable for complex data-discovery jobs.
Allows for working with big nested tree structures. Up to the size of your RAM.
Actively developed, backed and used in enterprise-level software.