topic Re: Activiti Query Question in Alfresco Archive

Activiti Query Question

pp84 — Sat, 18 Aug 2012 23:53:01 GMT

How to query the activiti tables with case insensitivity?I want to be able to search on variables with case sensitivity disabled. Can someone please advice?

Re: Activiti Query Question

mitziuro — Mon, 20 Aug 2012 10:41:58 GMT

I think you can do it easily if your db engine supports COLLATE.
You just have to modify the activiti creation scripts inside the jar:

org/activiti/db/create

For MySQL you can use COLLATE *_ci like:

http://code.openark.org/blog/mysql/mysqls-character-sets-and-collations-demystified

For PostgreSQL you can (create)modify the indexes like this:

http://archives.postgresql.org/pgsql-novice/2011-01/msg00060.php

Re: Activiti Query Question

pp84 — Tue, 21 Aug 2012 22:14:42 GMT

Can activiti be configured to query ignoring case?