Hello Everyone,
I need to search the JBPM4_VARIABLE for a variable that's stored in JBPM4_LOB - by contents.
I want to avoid the standard API calls - and instead am using Command<T> in order to execute a custom HQL query.
As long as I search for string or numeric values (stored in variables table itself) - it works allright.
The problem I face is that as soon as I try searching on the LOB relation (variable.lob = lob.dbid) - I don't get any results.
I probably should be using the public API - but I feel that iterating through every execution in search of a variable might become serious overkill once there are many executions.
Anyone solved this problem before?
Thanks in advance and a jolly new year!