Dear Axon Ivy community,
we have case widgets and task widgets, that take a lot of time to load the data for display. The reason is the big number of cases or tasks in the result set and possibly a suboptimal SQL query.
To make the loading more efficient, (besides pagination) we want to execute a reading SQL query directly on the system database via jdbc (bypassing the CaseQuery or TaskQuery API).
However, at this point we do not know how to translate certain methods from these APIs into native SQL syntax. Among these methods are
-TaskQuery.create().where().currentUserIsInvolved()
-TaskQuery.create().where().currentUserCanWorkOn()
-TaskQuery.FilterQuery.roleIsInvolved(IRole)
-CaseQuery.FilterQuery.userIsInvolved(IUser)
-etc.
Does somebody know how to translate these methods into native SQL, ie by logging the query on the system database directly?
Thank you very much in advance for any answers!
Best regards
