Find pending timer events

[zaiteki]

Hello,

Is there a way to list (using activiti DB direct query?) the pending timer events with the respective timer value? e.g. "broadcastTimeEnd" value for the "broadcastTimeEnd" events

<boundaryEvent id="broadcastTimeEnd" name="Broadcast time end" cancelActivity="true" attachedToRef="broadcastAction">
            <timerEventDefinition>
                <timeDate>${timer.broadcastTimeEnd}</timeDate>
            </timerEventDefinition>
        </boundaryEvent>
‍‍‍‍‍‍‍

I have a problem that some timer events are not triggered, so I would like to check if there are some pending timer events with invalid fire dates (e.g. in the past)

Thank you,
Andrei

[martin_grofcik]

Hi Andrei,

Try to use

ManagementService.createJobQuery

Regards
Martin

[zaiteki]

Hello Martin,

But is there a way to get it using direct SQL queries?

Thank you,
Andrei

[martin_grofcik]

Hi,

yes,
http://www.activiti.org/userguide/#queryAPI - native queries

or

http://www.activiti.org/userguide/#advanced.custom.sql.queries

Regards
Martin