topic Re: native query in Alfresco Archive

native query

benito — Fri, 24 Aug 2012 14:36:34 GMT

Hello,Where are some predefined queries for ProcessInstances and TaskInstances, but i need to combine this (example: get all processInstances which were created today and having open tasks of a distinct assignee)Is where a way to execute native queries on the activiti tables?grz,BJ

Re: native query

meyerd — Mon, 27 Aug 2012 04:18:01 GMT

Hi Benito,

We've been talking about this:
http://jira.codehaus.org/browse/ACT-1293

For the moment, you would have to construct you own mybatis session factory ant run the query from there.

Here are also some examples:
https://app.camunda.com/confluence/display/foxUserGuide/Performance+Tuning+with+custom+Queries

Re: native query

benito — Mon, 27 Aug 2012 06:38:41 GMT

Hi Daniel,

that is exactly what i need!

thx
BJ