nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Custom Sql query and Serialize variable

nik10_mah

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 described in this blog http://www.jorambarrez.be/blog/2014/01/17/execute-custom-sql-in-activiti/.
Tis is the query i have made.

SELECT variable.NAME_ as variableValue FROM ACT_RU_VARIABLE variable",
   "inner join ACT_RU_TASK task on variable.PROC_INST_ID_ = task.PROC_INST_ID_",
   "where task.ASSIGNEE_ = #{assignee}" })‍‍‍

Now when i try to get the wfeBean from result Map it gives me wfeBEan as string ans when i try to cast it it throws nullpointer exception.

So how can i get this object. Can i use native query for this.?

Find more posts tagged with

Comments

martin_grofcik

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.

<br>taskService.createTaskQuery().taskAssignee(asigneee).list();<br>
Regards
Martin

nik10_mah

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.

jbarrez

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