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

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&...]