Extract the jq record only when match the first and last name

Question

I can get the first and birthday,

{
  "users": [
    {
      "first": "Stevie",
      "last": "Wonder",
      "birthday": "01/01/1945"
    },
    {
      "first": "Michael",
      "last": "Jackson",
      "birthday": "03/23/1963"
    }
  ]
}

So with this jq command, I can get the record:

$ cat a.json |jq '.users[] | .first + " " + .last + " " + .birthday'
"Stevie Wonder 01/01/1945"
"Michael Jackson 03/23/1963"

And I am close to the answer to match the first name

$ cat a.json |jq '.users[] | select(.first=="Stevie") | .birthday '
"01/01/1945"

But how to get the output which matched both first and last name?

Does this answer your question? [JQ: Select multiple conditions](https://stackoverflow.com/questions/33057420/jq-select-multiple-conditions) — Inian, Jul 13 '20 at 06:30

score 2 · Answer 1 · answered Jul 13 '20 at 20:58

Here is an approach which starts by filtering out .users which do not meet your criteria:

.users |= map(select(
  (.first == "Stevie") and (.last == "Wonder")
))

if you Try it online! you will observe it simplifies your data to just

{
  "users": [
    {
      "first": "Stevie",
      "last": "Wonder",
      "birthday": "01/01/1945"
    }
  ]
}

Then you can add more filters if you want particular elements (e.g. .birthday):

  .users |= map(select(
    (.first == "Stevie") and (.last == "Wonder")
  ))
| .users[].birthday

to obtain Try it online!

"01/01/1945"

This may seem needlessly redundant but may be easier if you are experimenting without precise requirements.

Extract the jq record only when match the first and last name

1 Answers1