JQ: Select multiple conditions

Question

I have a json and at the moment using select to get only the data which match one condition, I need to filter based on more conditions.

For e.g:

.[] | select((.processedBarsVolume <= 5) && .processedBars > 0)

How I can do this ?

score 471 · Answer 1 · answered Oct 10 '15 at 21:13

471

jq supports the normal Boolean operators and/or/not, so it would look like:

.[] | select((.processedBarsVolume <= 5) and .processedBars > 0)

answered Oct 10 '15 at 21:13

Hans Z.

9

any reason for the extra braces around `.processedBarsVolume <= 5` ? – ssc Aug 30 '18 at 11:03
19

Nope, just kept the diff with the OPs suggestion to the relevant minimum – Hans Z. Aug 30 '18 at 11:11
3

seems unlikely to ever get the beloved checkmark at this point – JDS Nov 12 '18 at 21:25
13

Note: the and/or/not are case-sensitive. AND / OR do not work. – Joseph Larson Feb 10 '20 at 22:24
8

Abundant brackets are wise in jq. Operator precedence is a bit unintuitive if you are accustomed to imperative languages, and poorly documented in the otherwise stellar manual. – Leo Oct 04 '20 at 03:53
2

Here is the documentation for `and/or/not`: https://stedolan.github.io/jq/manual/#and/or/not – Martin von Wittich May 05 '21 at 16:41

score 3 · Answer 2 · answered Jun 24 '22 at 07:37

3

I had to wrap the piping to startswith with parentheses in order to make this work.

jq -n 'env | with_entries(select ((.key|startswith("CI_")) or .key == "DOCKER_CONTAINER_VERSION_TAG"))'

answered Jun 24 '22 at 07:37

siyb

2 Answers2