[jboss-user] [jBPM] - jBPM 4.4 : search by execution variable stored as LOB

[michal pisanko]

michal pisanko [http://community.jboss.org/people/milnauf] created the discussion

"jBPM 4.4 : search by execution variable stored as LOB"

To view the discussion, visit: http://community.jboss.org/message/578162#578162

--------------------------------------------------------------
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!
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/578162#578162]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110103/115edc88/attachment.html