topic Re: Sorting tasks by task variable values in Alfresco Archive

Sorting tasks by task variable values

ilyagalahov — Wed, 30 Mar 2016 13:15:01 GMT

Hello!Is it possible to sort TaskQuery.list() results by task variable values or process variable values ?We ought to implement it via custom ibatis mappings. Is it possible via core functionality ?Regards, Ilya.

Re: Sorting tasks by task variable values

martin_grofcik — Thu, 31 Mar 2016 08:26:04 GMT

Hi Ilya,
TaskQuery does not support sort by variable value.

You can implement your own native queries or extend ibatis mappings.

Regards
Martin

Re: Sorting tasks by task variable values

ilyagalahov — Thu, 31 Mar 2016 08:29:33 GMT

Thanks for your answer.

Should we expect this feature in next versions of engine ?

Don't you have any mapping examples with sorting by task vars ?

Regards

Ilya

Re: Sorting tasks by task variable values

ilyagalahov — Thu, 31 Mar 2016 08:42:01 GMT

We are using activiti with alfresco.

To show tasks in client's ui grids with sorting and filtering we store alfresco document properties in process variables.

To allow sorting and filtering in ui grids, we implemented custom ibatis mappings.

But the problem is in that we should store document properties in any process and subprocess, and tables ACT_RU_VARIABLE and ACT_HI_VARINST become very big. With every BP action created about 300 variables.

When we tried to load document properties from alfresco node itself, it was very slowly

We tried to store variables in one, "main" process by document, but with this approach mapping became very complex and unmaintainable.

Any ideas will be helpful.

Ilya.

Re: Sorting tasks by task variable values

martin_grofcik — Mon, 04 Apr 2016 08:28:48 GMT

Hi,
Ideas:

do not store all variables in history tables (implement your own listener and listen only to relevant changes),
optimize DB,
not store document variables in the process

Regards
Martin

Re: Sorting tasks by task variable values

ilyagalahov — Mon, 04 Apr 2016 12:31:12 GMT

Hello Martin!

Thanks for your answer.

– >do not store all variables in history tables (implement your own listener and listen only to relevant changes)

Does it mean, we need to turn off history (history level = none) and write to this tables on our own ?

Where can I read about it ?

Regards

Ilya.

Re: Sorting tasks by task variable values

jbarrez — Mon, 04 Apr 2016 14:44:44 GMT

Storing that many variables for each process instance is not a good idea, it'll lead to some poor performance.
I'd guess optimizing the db + query is the first thing to try.

Turning off history and listen to events, as Martin suggests, is surely an option, but a heavy one. I would first try to optimize the process, try to store way less data and try to optimize the query (indices maybe?)

Re: Sorting tasks by task variable values

cacaponkayaker — Thu, 19 May 2016 17:46:45 GMT

We are trying to do the same thing: show tasks in client's ui grids with sorting and filtering. If you don't suggest that we store the values for the grid in user variables, where should we put them?

Re: Sorting tasks by task variable values

ilyagalahov — Thu, 19 May 2016 19:24:14 GMT

For historic variables we implemented CustomHistoryManager which extends HistoryManager and then mocked unnecessary methods. You could override History manager in "activitiProcessEngineConfiguration" bean in "customSessionFactories" property.
So now we can store only necessary tasks and variables in historic tables. We do not store information about processes.