topic Re: How to make nativesql queries on activit tables in Alfresco Archive

How to make nativesql queries on activit tables

ahmetkara — Mon, 14 Feb 2011 09:54:50 GMT

Hi,Is there a way to map activiti tables with jpa and run nativesql's on those tables??

Re: How to make nativesql queries on activit tables

tombaeyens — Tue, 15 Feb 2011 07:19:56 GMT

You can run native sql on the activiti tables.
You can store JPA entities as process variables and Activiti will store references to those entities.

Can you explain a bit more what you mean with "map activiti tables with JPA"?

Re: How to make nativesql queries on activit tables

ahmetkara — Tue, 15 Feb 2011 09:46:06 GMT

Actually I need to run nativesql queries on activiti tables. For example; I want to display a processes which has been started by loggedin user. To do this(as I know), I should query the ActHiProcInst table like this "select a from ActHiProcinst a where startUserId = (:loggedInUserId)", but this is not met by activiti history api, so I need to query activiti history tables. To do that, I thought I might get the JPA entities by reverse engineering and then I could query tables using JPA entity manager (I don't know it is right way or not). So I am asking how to query acitiviti's own tables by JPA not any persistable entity. I hope, I could be clear . By the way, thanks for reply.

Re: How to make nativesql queries on activit tables

vander230 — Tue, 15 Feb 2011 10:00:59 GMT

Hello, Firstly I personally roll backwards. might be a bit harder for some. but quite easy to keep everything in place and trying for these queries.

Re: How to make nativesql queries on activit tables

tombaeyens — Wed, 16 Feb 2011 12:05:54 GMT

You can add a Jira to request a feature that adds the capability to the HistoricProcessInstanceQuery to filter on who started the process instance.

historyService
  .createHistoricProcessInstanceQuery()
  .startedBy("johndoe")
  .list();

Is that what you want?