Return entire object from Array based on key value in object using jq

Question

I have a .json file that I would like to filter through jq to return the entire object in the array if the key value in that object equals 'failed'. How would I do this ?

Example json:

"version": "0.26.0",
"controls": [{
    "id": "os-1.0",
    "status": "passed",
    "code_desc": "File /etc/profile content should match /umask\\s*022/",
    "profile_id": "test"
}, {
    "id": "os-1.0",
    "status": "passed",
    "code_desc": "File /etc/bashrc content should match /umask\\s*022/",
    "profile_id": "test"
}, {
    "id": "os-1.0",
    "status": "failed",
    "code_desc": "File /etc/csh.cshrc content should match /umask\\s*022/",
    "profile_id": "test"
   "message": "\nexpected: \"/sbin/sulogin\"\n     got: \n\n(compared using `cmp` matcher)\n"
}]

Output to a new file :

{
    "id": "os-1.0",
    "status": "failed",
    "code_desc": "File /etc/csh.cshrc content should match /umask\\s*022/",
    "profile_id": "test"
    "message": "\nexpected: \"/sbin/sulogin\"\n     got: \n\n(compared using  `cmp` matcher)\n"
}

@BhavinSolanki This is what I've tried so far : cat file.json | jq -c '.[] | select(.controls | . and contains("failure"))' but I believe I'm missing an array coordinate — hedda
– hedda, Commented Jul 13, 2016 at 16:38

peak · Accepted Answer · 2016-07-13 17:37:09Z

4

The text shown as JSON is invalid as JSON. Assuming it is fixed to have the structure {"version": _, "controls": _}, the following filter would yield the result shown below:

.controls[] | select(.status == "failed")

Output:

{
  "id": "os-1.0",
  "status": "failed",
  "code_desc": "File /etc/csh.cshrc content should match /umask\\s*022/",
  "profile_id": "test",
  "message": "\nexpected: \"/sbin/sulogin\"\n     got: \n\n(compared using `cmp` matcher)\n"
}

Note: For robustness you might want to use .status? instead of .status.

answered Jul 13, 2016 at 17:37

peak

119k21 gold badges185 silver badges218 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Return entire object from Array based on key value in object using jq

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related