native query

[benito]

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

[meyerd]

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

[benito]

Hi Daniel,

that is exactly what i need!

thx
BJ