[jboss-jira] [JBoss JIRA] Commented: (JBPM-966) Modify Hibernate mappings to enable searching for TaskInstance's by VariableInstance

Modify Hibernate mappings to enable searching for TaskInstance's by VariableInstance ------------------------------------------------------------------------------------ Key: JBPM-966 URL: http://jira.jboss.com/jira/browse/JBPM-966 Project: JBoss jBPM Issue Type: Feature Request Components: Core Engine Affects Versions: jBPM jPDL 3.2 Environment: Any Reporter: Richard Tomlinson Assigned To: Tom Baeyens We want to be able to *efficiently* search for task instances based on the values of one or more variable instance. For example: TaskInstance myTasklnstance = .... myTaskInstance.setVariableLocally("owner", "theOwner"); myTaskInstance.setVariable("anId", new Long(123456)); Using this example we would like to create a Hibernate Criteria based query that will allow us to search and retrieve the task instance using the two variables as criteria of the search. At present, this does not appear to be possible. Querying for TaskInstances based on one or more VariableInstance's requires a convoluted HQL expression where each variableinstance (v) is obtained with the join to task instance (ti) with "v.processInstance.id = ti.taskMgmtInstance.processInstance.id" Observation: ----------------- TaskInstance hibernate mappings allows the retrieval of all variable instances for a given task instance. This mapping allows the resulting sql to join the JBPM_TASKINSTANCE table to JBPM_VARIABLEINSTANCE table. The JBPM_VARIABLEINSTANCE table has a FK back to JBPM_TASKINSTANCE but the Hibernate mappings do not contain the correponding reverse mapping.