topic Re: Optimizing History Queries in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/optimizing-history-queries/m-p/198768#M151898 <HTML><HEAD></HEAD><BODY><SPAN>You could store your process variables in an separate table with the JPA option, see chapter 10 of the user guide. The process instance id should be a column in this table. You can then join this table and the activiti act_hi_procinst table and query with your filter requirements. Even better is to create a database view on both tables. </SPAN></BODY></HTML> Tue, 02 Dec 2014 06:11:03 GMT ollib 2014-12-02T06:11:03Z Optimizing History Queries https://connect.hyland.com/t5/alfresco-archive/optimizing-history-queries/m-p/198767#M151897 We have the following SQL in the NativeHistoricProcessInstanceQueryImpl making a query for the 10 most recent top level root process instances that have a certain variable associated, which is ‘policyCd’.List&lt;HistoricProcessInstance&gt; filteredHistoricalProcessInstanceList = new NativeHistoricPr Wed, 26 Nov 2014 19:05:44 GMT https://connect.hyland.com/t5/alfresco-archive/optimizing-history-queries/m-p/198767#M151897 ag91375 2014-11-26T19:05:44Z Re: Optimizing History Queries https://connect.hyland.com/t5/alfresco-archive/optimizing-history-queries/m-p/198768#M151898 <HTML><HEAD></HEAD><BODY><SPAN>You could store your process variables in an separate table with the JPA option, see chapter 10 of the user guide. The process instance id should be a column in this table. You can then join this table and the activiti act_hi_procinst table and query with your filter requirements. Even better is to create a database view on both tables. </SPAN></BODY></HTML> Tue, 02 Dec 2014 06:11:03 GMT https://connect.hyland.com/t5/alfresco-archive/optimizing-history-queries/m-p/198768#M151898 ollib 2014-12-02T06:11:03Z