Skip to content

featjans-orm): PostgreSQL ORM should allow to search inside JSON attributes #9754

@yurem

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());

Metadata

Assignees

Labels

kind-featureIssue or PR is a new feature request

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions