topic Re: Custom Sql query and Serialize variable in Alfresco Archive

Custom Sql query and Serialize variable

nik10_mah — Tue, 03 Jun 2014 06:53:54 GMT

Hi, I am passing a serialized bean named WfeBean( which contains entityId and statusId as fields) as process variable. And it seems it stores the bean in act_ge_bytearray table. Now i want to create a query which fetches all the entityId of the tasks assigned to a user. I am created a query as desc

Re: Custom Sql query and Serialize variable

martin_grofcik — Wed, 04 Jun 2014 06:23:31 GMT

Hi Nikhil,

I would recommend to use taskService.createTaskQuery to get a list of tasks assigned to the user. From the fetched task list you can get task ids.


taskService.createTaskQuery().taskAssignee(asigneee).list();

Regards
Martin

Re: Custom Sql query and Serialize variable

nik10_mah — Wed, 04 Jun 2014 07:51:12 GMT

Actually i wanted the list of entityIds in WfeBean as mentioned in question. If i fetch tasks the i would have to iterate through all the tasks to the entityIds so i am trying to skip this loop. And fetch the entity Ids only.

I have able to fetch the list of WfeBean using following query:-

<java>SELECT bytear.NAME_ as name, bytear.bytes_ as value from ACT_GE_BYTEARRAY bytear
   inner join ACT_RU_VARIABLE variable on variable.bytearray_id_ = bytear.id_
   inner join ACT_RU_TASK task on task.PROC_INST_ID_ = variable.PROC_INST_ID_
   where task.ASSIGNEE_ = '1'</java>

But what i want is list of entityIds which is an Integer field of WfeBEan.

Re: Custom Sql query and Serialize variable

jbarrez — Wed, 04 Jun 2014 08:28:05 GMT

You can't, as the bean is serialized as bytes. There is no sql query that allows to do that