[jboss-user] [JBoss jBPM] - HQL query to select taskinstances

Hi I am trying to write an HQL query which will return all TaskInstances for an actor id joining on a VariableInstance for that TaskInstance where the variable has a particular name and value. The stored VariableInstance has a variable of type Long and when I try to get the object by joining, the resulting query defaults to the StringValue column. Does anyone know how I could join the TaskInstance onto the VariableInstance by the Long value column? Basically I need something along the lines of: from TaskInstance as taskinstance join taskinstance.variableInstances as variable where variable.name = 'name' and variable.value = 'requiredvalue' But I need to tell it to use the LONGVALUE column in the table somehow. I am doing this to get everything that I need from the one query as it is going to be used very heavily in my application. Any help would be much appreciated Thanks Joe View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3979812#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...