Filter on JSON attribute's values content?

[ghost]

Is it possible to filter on an attribute value embedded in the value of a JSON attribute when using TypeORM with Postgres? Consider this json -- 'attrs' is an attribute of item that has JSON content with fields name and status.

{
    "id": 2,
    "name": "Item #2",
    "attrs": {
        "name": "Item #2",
        "status": "rejected"
    }
}

I would like to find all items were the status value is rejected.
Note: The JSON of the attrs column is highly variable from instance to instance.

[michaelyali]

no, I believe it's not possible to filter embedded fields.
nevertheless, we have this PR #267 and I need to test it including filtering those columns

[ghost]

I was able to eventually figure this out -- basically needs a query with a "Where" clause that goes something like this (NOTE: This is Postgres specific), --

WHERE 'attrs' ::jsonb ->> 'status' = 'rejected'

Using this approach, I have been able to make progress. It seems like it should definitely be possible to adapt the nestjsx/crud to support such complexity although from a design perspective I see that the query criteria on a request could get rather complicated.

Thoughts?

[Diluka]

there are some concepts #149 #150

[mattsidjohn]

Any update on this @zMotivat0r ?