topic Re: Adding Date as a column in ACT_RU_VARIABLE, and adding IN & NOT IN as operators in org.activiti.engine.impl.QueryOperator in Alfresco Archive

Adding Date as a column in ACT_RU_VARIABLE, and adding IN & NOT IN as operators in org.activiti.engine.impl.QueryOperator

devatha — Thu, 25 Apr 2013 21:57:02 GMT

HiI am wondering why the operators IN & NOT IN are added as operators in org.activiti.engine.impl.QueryOperator class. Do you have any plans to add them as operators in future releases?I am also wondering why the query support for a DATE typed Process or Task Variable is missing. In other words,

Re: Adding Date as a column in ACT_RU_VARIABLE, and adding IN & NOT IN as operators in org.activiti.engine.impl.QueryOperator

devatha — Thu, 25 Apr 2013 22:07:25 GMT

I could not extend QueryOperator since it is an Enum. Not sure how I can use/extend TaskQueryImpl to accept more operators on a Process/Task Variable.

I need this, since my query is complex and dynamically generated, containing lot of conditions joined by AND & OR. So, Native Query will not help. The User of my app has to be able to create this complex condition from the UI

Re: Adding Date as a column in ACT_RU_VARIABLE, and adding IN & NOT IN as operators in org.activiti.engine.impl.QueryOperator

jbarrez — Tue, 30 Apr 2013 08:26:56 GMT

It's just a matter of time and prioritization. The query api can be extended in many, many ways still. Of course, we welcome any contribution in that area.

The reason for storing long is probably to have it uniform on any database.