Sorting and Filtering in Activiti Rest

[mhanrahan]

As part of our Activiti implementation, we are building a UI that connects to the Activiti REST interface, and we have noticed some perculiarities with the filtering and sorting functions of the REST interface and Activiti in general.

It seems that the sorting on Ids is done as text, so you would receive the response in an odd order, such as:

1
2
22
3

instead of:
1
2
3
22

Also, when using 'nameLike' or similar for filtering, it seems to be case sensitive.

Is there any way to work around these two issues?

[jbarrez]

The id is a string, so indeed string ordering is done if you dont provide any specific ordering.

case sensitive will depend on your db. Some db's are case insensitive, some arent.

[mhanrahan]

I'm using MySQL, which as far as I can tell, isn't case sensitive for LIKE by default.