topic Query process instances and JPA entity in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/query-process-instances-and-jpa-entity/m-p/169678#M123039 <HTML><HEAD></HEAD><BODY><SPAN>I have a process with a JPA entity "vacation". When I created the process instance, I also create an empty vacation record in the database. The vacation record also stores the associated process instance id.</SPAN><BR /><BR /><SPAN>I also have a process instance search where i can do things like:</SPAN><BR /><BR /><SPAN>List&lt;HistoricProcessInstance&gt; processInstances = </SPAN><BR /><SPAN>&nbsp; historyService.createNativeHistoricProcessInstanceQuery()</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .sql("SELECT * FROM " + managementService.getTableName(HistoricProcessInstance.class) + </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; " h, vacations v where h.proc_inst_id_ = v.processinstanceid and v.decision = 'Denied'")</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .list();</SPAN><BR /><BR /><BR /><SPAN>As I understand the createNativeHistoricProcessInstanceQuery method, it works with pure SQL.</SPAN><BR /><BR /><SPAN>Would it be possible to make such queries with JPA or Hibernate? I use HibernatePersistence for my vacation objects. </SPAN><BR /><BR /><SPAN>Best regards</SPAN><BR /><SPAN>Oliver Brüning</SPAN></BODY></HTML> Mon, 03 Feb 2014 11:29:13 GMT ollib 2014-02-03T11:29:13Z Query process instances and JPA entity https://connect.hyland.com/t5/alfresco-archive/query-process-instances-and-jpa-entity/m-p/169678#M123039 I have a process with a JPA entity "vacation". When I created the process instance, I also create an empty vacation record in the database. The vacation record also stores the associated process instance id.I also have a process instance search where i can do things like:List&lt;HistoricProcessInsta Mon, 03 Feb 2014 11:29:13 GMT https://connect.hyland.com/t5/alfresco-archive/query-process-instances-and-jpa-entity/m-p/169678#M123039 ollib 2014-02-03T11:29:13Z Re: Query process instances and JPA entity https://connect.hyland.com/t5/alfresco-archive/query-process-instances-and-jpa-entity/m-p/169679#M123040 <HTML><HEAD></HEAD><BODY><SPAN>You can access the EntityManagerSession object that provides an EntityManager. So you can use the EntityManager instance to execute any queries you would like to execute. You can get it from the ProcessEngineConfiguration getSessionfactories method.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Tue, 04 Feb 2014 13:18:56 GMT https://connect.hyland.com/t5/alfresco-archive/query-process-instances-and-jpa-entity/m-p/169679#M123040 trademak 2014-02-04T13:18:56Z