query for first nesting level

[Chutchev]

Hi, @volans-
I have json like this:

{
    "id": "uuid4",
    "vendor": {
        "id": "vendor_uuid4",
        "name": "vendor_name",
        "slug": "vendor_slug"
    },
    "vendor_id": "vendor_uuid4",
    "name": "course_name",
    "slug": "course_slug",
    "status": "course_status"
} 

status can have values such as: published, archived. I want to check that this course have status equals published, but I can't create query to status field. I didn't find similar examples In original library documentations. How can I do it?

[volans-]

@Chutchev what do you mean exactly by I want to check that this course have status equals published? What kind of object you'd want as a result of the check?
Is this a single object or do you have a list of objects from which you want to extract only the ones with a specific status?

[Chutchev]

this is a single object.
Result should be this object if status=="published"

[volans-]

Ok, then in order to use the query capabilities you have to convert this to a list/array and query for the first object with status=="published". To create a list of the whole current JSON you can use the @this modifier.

So putting all together that would be:

[@this].#(status=="published")

If the status is published it will return the whole object. Let me know if that's what you needed.

[Chutchev]

Wow, thank you. It works

[Chutchev]

Okay, does this mean that if I want to use a filter on the first level, I must always wrap the root in a list?
And if this json will be a list of subject, I would have to use an expression like this?

@this.#(status=="published")

[volans-]

It's not the level, but the fact that queries works only on lists, see https://github.com/tidwall/gjson/blob/master/SYNTAX.md#queries

If you have already a list of objects you don't need the @this but can query them directly. With a JSON of:

[
  {
    "id": "uuid4_1",
    "vendor": {
        "id": "vendor_uuid4",
        "name": "vendor_name",
        "slug": "vendor_slug"
    },
    "vendor_id": "vendor_uuid4",
    "name": "course_name",
    "slug": "course_slug",
    "status": "published"
  }, 
  {
    "id": "uuid4_2",
    "vendor": {
        "id": "vendor_uuid4",
        "name": "vendor_name",
        "slug": "vendor_slug"
    },
    "vendor_id": "vendor_uuid4",
    "name": "course_name",
    "slug": "course_slug",
    "status": "archived"
  }
]

You can query the first object with a given status with:

#(status=="published")

or all the objects with a given status with:

#(status=="published")#