topic How to query historic task by form property? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-query-historic-task-by-form-property/m-p/129540#M91009 <HTML><HEAD></HEAD><BODY><SPAN>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.&nbsp; Though in ACT_HI_DETAIL they're recorded with type 'FormProperty', HistoricTaskInstanceQuery doesn't query by that column I suppose.</SPAN><BR /><BR /><SPAN>So I wonder if anyone have the same issue here. Thanks.</SPAN></BODY></HTML> Mon, 04 Feb 2013 07:06:04 GMT sherlockq 2013-02-04T07:06:04Z How to query historic task by form property? https://connect.hyland.com/t5/alfresco-archive/how-to-query-historic-task-by-form-property/m-p/129540#M91009 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 Mon, 04 Feb 2013 07:06:04 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-query-historic-task-by-form-property/m-p/129540#M91009 sherlockq 2013-02-04T07:06:04Z Re: How to query historic task by form property? https://connect.hyland.com/t5/alfresco-archive/how-to-query-historic-task-by-form-property/m-p/129541#M91010 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>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?</SPAN></BODY></HTML> Mon, 04 Feb 2013 08:59:51 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-query-historic-task-by-form-property/m-p/129541#M91010 frederikherema1 2013-02-04T08:59:51Z