Hi, i want to sort the tasks by the value of the process variables.
I explored solving it using native queries but i want the solution to be extensible for any type of task query.
Wanted to check the following:
(1) Is it possible to suffix the query generated by task query with where NAME_=’’ order by LONG_/TEXT_? what is your suggestion here? in that case, what is the direction, how do i create and inject a custom xml into mysql? Lets say i have 10000 records at any point of time, Will it improve my performance by sorting it at database level instead of application side sorting.
(2) Is there a way to exploit native query for this and make it generic for any task
(3) Is flowable planning to release this feature any time soon?