topic Re: Query an array variable in Alfresco Archive

Query an array variable

javialfresco — Thu, 29 Jan 2015 08:17:29 GMT

I read about why variables of type ByteArray cannot be queried and I understand that Blobs cannot be queried in the where-clause but I'm not sure what could be the better approach for my situation:- I have an Array variable, lets say: validators = ["a","b","c"] stored in my activiti process - I wan

Re: Query an array variable

javialfresco — Mon, 09 Feb 2015 10:58:26 GMT

No one is facing this kind of situation? Am i misusing activiti process variables?

Thanks for your help.

Re: Query an array variable

martin_grofcik — Mon, 09 Feb 2015 11:55:14 GMT

Hi,

Am i misusing activiti process variables?

I do not think so.

Note 1: Long strings (>4000 chars) are stored in the blobs too.

Note 2: I would say that searching in blob (which serialize java array) depends on the DB vendor. (If the DB implementation supports it you can use it). In other case you have to parse variables in java.

Note 3: You can implement your own type (e.g. for arrays) and store array values there (in the format which can DB query) similar to org.activiti.engine.impl.variable.LongStringType
Regards
Martin