Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

feat(config-api): session endpoint changes for search in jansSessAttr JSON #9856

Closed
pujavs opened this issue Oct 21, 2024 · 0 comments · Fixed by #9867
Closed

feat(config-api): session endpoint changes for search in jansSessAttr JSON #9856

pujavs opened this issue Oct 21, 2024 · 0 comments · Fixed by #9867
Assignees
@pujavs
Labels
comp-jans-config-api Component affected by issue or PR effort-3 Relative effort required for completion of issue or PR kind-enhancement Issue or PR is an enhancement to an existing functionality kind-feature Issue or PR is a new feature request priority-3 Issue or PR is relevant to core functions, but does not impede progress. Important, but not urgent
Milestone
1.1.6

Comments

@pujavs
Copy link
Contributor

pujavs commented Oct 21, 2024 •
edited
Loading

ORM now support to search inside JSON SQL columns
New MySQL/PostgreSQL ORM support search in JSON columns like jansdb.jansSessId.jansSessAttr
The filter API syntax is the same
Filter filterSessAttr = Filter.createGreaterOrEqualFilter("jansSessAttr.exp", expirationDate.getTimeInMillis());
In query above part .exp specify to which JSON property ORM should apply filter
Also this JSON ORM API update supports =, >= ,<=, partial match, contains
We can use this API to search in session attributes

Changes in search endpoint to support search based on jansSessAttr feild.
Example: fieldValuePair=auth_user=devrim,client_id=2000.583cef6f-36f4-4e9b-9bd2-5eeacd52081e,expirationDate>2024-09-25,expirationDate<2024-09-27

auth_user=devrim
client_id=2000.d86121b0-c77f-492d-af94-74badd0338c2
date_after=2024-09-15T12:00:00
date_before=2024-10-18T16:10:23
@pujavs pujavs added comp-jans-config-api Component affected by issue or PR effort-3 Relative effort required for completion of issue or PR kind-enhancement Issue or PR is an enhancement to an existing functionality priority-3 Issue or PR is relevant to core functions, but does not impede progress. Important, but not urgent labels Oct 21, 2024
@pujavs pujavs self-assigned this Oct 21, 2024
@mo-auto mo-auto added the kind-feature Issue or PR is a new feature request label Oct 21, 2024
@pujavs pujavs mentioned this issue Oct 21, 2024
Merged
6 tasks
@moabu moabu added this to the 1.1.6 milestone Nov 6, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@pujavs pujavs

Labels
comp-jans-config-api Component affected by issue or PR effort-3 Relative effort required for completion of issue or PR kind-enhancement Issue or PR is an enhancement to an existing functionality kind-feature Issue or PR is a new feature request priority-3 Issue or PR is relevant to core functions, but does not impede progress. Important, but not urgent
Projects
None yet
Milestone
1.1.6
Development

Successfully merging a pull request may close this issue.

feat(config-api): session endpoint changes for search in jansSessAttr JSON JanssenProject/jans
3 participants
@pujavs @moabu @mo-auto