featjans-orm): PostgreSQL ORM should allow to search inside JSON attributes #9754
Description
Here is sample request which it should produce:
select *, "doc"."doc_id"
from "public"."jansSessId" "doc"
where jsonb_path_exists("doc"."jansSessAttr", '$."exp" ? (@ >= 1729009000139)'::jsonpath)
Sample ORM filter for query above:
Filter filterSessAttr = Filter.createGreaterOrEqualFilter("jansSessAttr.exp", expirationDate.getTimeInMillis());