Symfony5 Error: Class 'jsonb_each_text' is not defined.

[martin-georgiev]

Symfony5 Error: Class 'jsonb_each_text' is not defined.

[martin-georgiev]

The constructed query is invalid. You must JOIN with another entity that has a defined relationship with App:Product. Entities can't be joined with the result of a function (in your case you try to join with jsonb_each_text).

[shubaivan]

@martin-georgiev okey, one more quesiton, I have simple postgres query

            select 
            DISTINCT e.key,  
            jsonb_agg(DISTINCT e.value) as fields 
            from products AS p 
            join jsonb_each_text(p.extras) e on true
            WHERE e.key != :exclude_key       
            GROUP BY e.key

Exist some opportunity transform it to query builder with this bundle?

[martin-georgiev]

Hey @shubaivan,

again joining on jsonb_each_text won't be valid in the context of Doctrine. DQL was not built for such uses. DQL's purpose is to make queries over object model. It is not a query language for your relational schema.