topic Unable to query for variable in History in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/unable-to-query-for-variable-in-history/m-p/161351#M115282 <HTML><HEAD></HEAD><BODY><SPAN>Hi all !</SPAN><BR /><SPAN>I'm trying to query for a process variable value- since the process has ended at the time of the Query, I'm using the History Service.</SPAN><BR /><SPAN>So I guess I'd need first HistoricDetail:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp;List&lt;HistoricDetail&gt; details = historyService.createHistoricDetailQuery().processInstanceId(procId).list();<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>However the details' list is empty. Do you have any idea that brings me in the right direction?</SPAN><BR /><SPAN>Thanks</SPAN><BR /><SPAN>Frank</SPAN><BR /></BODY></HTML> Mon, 18 Nov 2013 09:32:38 GMT frank41 2013-11-18T09:32:38Z Unable to query for variable in History https://connect.hyland.com/t5/alfresco-archive/unable-to-query-for-variable-in-history/m-p/161351#M115282 Hi all !I'm trying to query for a process variable value- since the process has ended at the time of the Query, I'm using the History Service.So I guess I'd need first HistoricDetail:&nbsp;&nbsp;&nbsp;List&lt;HistoricDetail&gt; details = historyService.createHistoricDetailQuery().processInstanceId(procId).list();‍ Mon, 18 Nov 2013 09:32:38 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-query-for-variable-in-history/m-p/161351#M115282 frank41 2013-11-18T09:32:38Z Re: Unable to query for variable in History https://connect.hyland.com/t5/alfresco-archive/unable-to-query-for-variable-in-history/m-p/161352#M115283 <HTML><HEAD></HEAD><BODY><SPAN>I hope, following snippet from the test could help you:</SPAN><BR /><BR /><CODE><BR />…<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;HistoricProcessInstance&gt; instanceList = historyService.createHistoricProcessInstanceQuery().includeProcessVariables().list();<BR />…<BR /></CODE><BR /><SPAN>Martin</SPAN></BODY></HTML> Mon, 18 Nov 2013 09:40:24 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-query-for-variable-in-history/m-p/161352#M115283 martin_grofcik 2013-11-18T09:40:24Z Re: Unable to query for variable in History https://connect.hyland.com/t5/alfresco-archive/unable-to-query-for-variable-in-history/m-p/161353#M115284 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for your reply, however in the release of Activiti (5.11) I'm using I cannot find the method includeProcessVariables() in the HistoricProcessInstanceQuery() <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></SPAN></BODY></HTML> Mon, 18 Nov 2013 10:40:33 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-query-for-variable-in-history/m-p/161353#M115284 frank41 2013-11-18T10:40:33Z Re: Unable to query for variable in History https://connect.hyland.com/t5/alfresco-archive/unable-to-query-for-variable-in-history/m-p/161354#M115285 <HTML><HEAD></HEAD><BODY><SPAN>Hi Frank,</SPAN><BR /><BR /><SPAN>Can you cherry-pick this feature?</SPAN><BR /><BR /><SPAN>Martin</SPAN></BODY></HTML> Tue, 19 Nov 2013 08:54:52 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-query-for-variable-in-history/m-p/161354#M115285 martin_grofcik 2013-11-19T08:54:52Z Re: Unable to query for variable in History https://connect.hyland.com/t5/alfresco-archive/unable-to-query-for-variable-in-history/m-p/161355#M115286 <HTML><HEAD></HEAD><BODY><SPAN>Another possibility is to use native queries. 5.11 supports them.</SPAN></BODY></HTML> Tue, 19 Nov 2013 13:29:38 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-query-for-variable-in-history/m-p/161355#M115286 martin_grofcik 2013-11-19T13:29:38Z