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)
@jcallen — Very cool!
And as they say, "I learn something new everyday!" 🙂
If you're looking after - how to parse JSON and select date range
Look at here https://gist.github.com/gangsta/702e071fd048db2e39c7907f40d0cfd4
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
@samrjack Another way to do the same without changing the order on the command line is to replace:
cat file | jq ...with:
< file jq ...You can put the
< fileanywhere on the command line, not just at the end