ipbastola/jq to filter by value.md

Last active September 3, 2024 14:40

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ipbastola/2c955d8bf2e96f9b1077b15f995bdae3.js"></script>
Save ipbastola/2c955d8bf2e96f9b1077b15f995bdae3 to your computer and use it in GitHub Desktop.

JQ to filter JSON by value

Raw

JQ to filter JSON by value

Syntax: cat <filename> | jq -c '.[] | select( .<key> | contains("<value>"))'

Example: To get json record having _id equal 611

cat my.json | jq -c '.[] | select( ._id | contains(611))'

Remember: if JSON value has no double quotes (eg. for numeric) to do not supply in filter i.e. in contains(611)

To get an array back and persist it to a file, I wrapped the whole expression in an array like this:

cat input.json | jq '[ .[] | select( .field | contains("something")) ]' > output.json