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

[Richard Tomlinson (JIRA)]

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.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira