cancel
Showing results for 
Search instead for 
Did you mean: 

How to query historic task by form property?

sherlockq
Champ in-the-making
Champ in-the-making
I'd like to query historic tasks by submitted form property values through HistoricTaskInstanceQuery. There's two methods related in it, processVariableValueEquals and taskVariableValueEquals. The first is not applicable obviously and the second doesn't work because all submitted properties recorded in ACT_HI_VARINST appeared without task_id.  Though in ACT_HI_DETAIL they're recorded with type 'FormProperty', HistoricTaskInstanceQuery doesn't query by that column I suppose.

So I wonder if anyone have the same issue here. Thanks.
1 REPLY 1

frederikherema1
Star Contributor
Star Contributor
Aren't the variables, submitted by the form-properties, also recorded as a HistoricDetail? The HistoricTaskInstanceQuery uses the ACT_HI_DETAIL table and only uses "VariableUpdates" indeed.

If no "VariableUpdate" detail is written alongside the form-properties, it makes sense we add additional methods on the HTIQuery to look for form-properties instead of variable-updates. Can you create a jira-issue for this, if the statement above is true?