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

[devatha]

Hi

I 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, are you planning to add a DATE_ column in ACT_RU_VARIABLE table? I can covert to & from Date to Long and perform queries, but it is a round about way to achieve things. I think a common data type like DATE should be there as a column in ACT_RU_VARIABLE table.

Your thoughts? Please reply.

A reply from Activiti developers is greatly appreciated.

[devatha]

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

[jbarrez]

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.