SyntaxFix

[arrays] How to filter an array of objects based on values in an inner array with jq?

Very close! In your select expression, you have to use a pipe (|) before contains.

This filter produces the expected output.

. - map(select(.Names[] | contains ("data"))) | .[] .Id

The jq Cookbook has an example of the syntax.

Filter objects based on the contents of a key

E.g., I only want objects whose genre key contains "house".

$ json='[{"genre":"deep house"}, {"genre": "progressive house"}, {"genre": "dubstep"}]'
$ echo "$json" | jq -c '.[] | select(.genre | contains("house"))'
{"genre":"deep house"}
{"genre":"progressive house"}

Colin D asks how to preserve the JSON structure of the array, so that the final output is a single JSON array rather than a stream of JSON objects.

The simplest way is to wrap the whole expression in an array constructor:

$ echo "$json" | jq -c '[ .[] | select( .genre | contains("house")) ]'
[{"genre":"deep house"},{"genre":"progressive house"}]

You can also use the map function:

$ echo "$json" | jq -c 'map(select(.genre | contains("house")))'
[{"genre":"deep house"},{"genre":"progressive house"}]

map unpacks the input array, applies the filter to every element, and creates a new array. In other words, map(f) is equivalent to [.[]|f].

Examples related to arrays

• PHP array value passes to next row • Use NSInteger as array index • How do I show a message in the foreach loop? • Objects are not valid as a React child. If you meant to render a collection of children, use an array instead • Iterating over arrays in Python 3 • Best way to "push" into C# array • Sort Array of object by object field in Angular 6 • Checking for duplicate strings in JavaScript array • what does numpy ndarray shape do? • How to round a numpy array?

Examples related to json

• Use NSInteger as array index • Uncaught SyntaxError: Unexpected end of JSON input at JSON.parse (<anonymous>) • HTTP POST with Json on Body - Flutter/Dart • Importing json file in TypeScript • json.decoder.JSONDecodeError: Extra data: line 2 column 1 (char 190) • Angular 5 Service to read local .json file • How to import JSON File into a TypeScript file? • Use Async/Await with Axios in React.js • Uncaught SyntaxError: Unexpected token u in JSON at position 0 • how to remove json object key and value.?

Examples related to select

• Warning: Use the 'defaultValue' or 'value' props on <select> instead of setting 'selected' on <option> • SQL query to check if a name begins and ends with a vowel • Angular2 *ngFor in select list, set active based on string from object • SQL: Two select statements in one query • How to get selected value of a dropdown menu in ReactJS • DATEDIFF function in Oracle • How to filter an array of objects based on values in an inner array with jq? • Select unique values with 'select' function in 'dplyr' library • how to set select element as readonly ('disabled' doesnt pass select value on server) • Trying to use INNER JOIN and GROUP BY SQL with SUM Function, Not Working

Examples related to jq

• Passing bash variable to jq • How to install JQ on Mac by command-line? • Using jq to parse and display multiple fields in a json serially • How to filter an array of objects based on values in an inner array with jq? • How to get key names from JSON using jq • How to count items in JSON object using command line? • How to merge 2 JSON objects from 2 files using jq? • Select objects based on value of variable in object using jq

Examples related to negation

• How to filter an array of objects based on values in an inner array with jq? • Negation in Python