jq Recursive search values by key, starting with

Question

TL;DR

What is jq's equivalent to grep '"\/v6' in the following command;

jq '.. .pattern? // empty' /tmp/all.json | grep '"\/v6'

Consider the following json;

{
  "payload": {
    "groups": [
      {
        "pattern": "/v6/",
        "groups": [
          {
            "pattern": "something/",
            "groups": [
              {
                "pattern": "somethingElse/",
                "groups": [
                  {
                    "pattern": "{specialPattern:[0-9]+}/",
                    "groups": [],
                    "routes": [
                      {
                        "type": "variable",
                        "pattern": "/v6/notImportant/{specialPattern:[0-9]+}/",
                        "methods": {

^{The json file is quite large, with a lot of irrelevant data}

I'm trying to capture all the .pattern in the json file, based on this question I've created the following jq command:

jq '.. .pattern? // empty' /tmp/all.json

This works as expected, creating a output similar to this;

"/v6/"
"something/"
"somethingElse/"
"{specialPattern:[0-9]+}/"
"/v6/notImportant/{specialPattern:[0-9]+}/"

Question: How would I only select each .pattern that starts with /v6/ ? I've used grep like so

jq '.. .pattern? // empty' /tmp/all.json | grep '"\/v6'

However, there must be a jq-only solution to this.

Google taught me about jq's contains that seems to be the answer on some-sort-of related question;

Unfortunately I can't manage to make it work with my situation, since using select seems unnecessary.

score 2 · Accepted Answer · edited Aug 28 '20 at 14:12

2

To perform the selection, you could use

select( test( "^/v6/" ) )

So the command becomes;

jq '.. .pattern? // empty | select(test("^/v6/"))' /tmp/all.json

Or similarly with startswith.

edited Aug 28 '20 at 14:12

0stone0

34,288
4
39
64

answered Aug 28 '20 at 13:11

peak

105,803
17
152
177

Thank you for your answer! Could you please provide a full example of the command? – 0stone0 Aug 28 '20 at 13:18
1

@0stone0: pete means it to use it along with your original pattern - `.. .pattern? // empty | select( test( "^/v6/" ) )` – Inian Aug 28 '20 at 14:04
Any idea if using `select` is the only option? Only Using `test` isn't an option? – 0stone0 Aug 28 '20 at 14:16
`def grep($s): select(test($s));` – peak Aug 28 '20 at 18:39

jq Recursive search values by key, starting with

1 Answers1