I want to achieve the below result with ‘,’
FROM table1 t1,
LATERAL jsonb_array_elements(secret_data->’rating’->’subRating’) AS subRatings
WHERE
I want to achieve this with criteria API.
I know we can create a lateralJoinSubquery and add it in this way –
JpaDerivedJoin lateralJoin =
((SqmRoot) Root).joinLateral(lateralJoinSubquery);
But this will yield –
table1 t1 JOIN LATERAL (The subquery)
which i do not want.
Nothing that i was expecting i need approach.
Amber is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.