07-17-2015 10:15 PM
### 253 Queries
### Taking 1.001277 to 1.567178 seconds to complete
SET timestamp=XXX;
select RES.*
from ACT_RU_JOB RES
LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_
where (RES.TYPE_ = 'XXX')
and (RES.DUEDATE_ is not null)
and (RES.DUEDATE_ < 'XXX')
and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ < 'XXX')
and (RES.RETRIES_ > XXX)
and (
(RES.EXECUTION_ID_ is null)
or
(PI.SUSPENSION_STATE_ = XXX)
)
order by DUEDATE_;
### 225 Queries
### Taking 1.000308 to 1.255745 seconds to complete
SET timestamp=XXX;
select RES.*
from ACT_RU_JOB RES
LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_
where (RETRIES_ > XXX)
and (DUEDATE_ is null or DUEDATE_ <= 'XXX')
and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ <= 'XXX')
and (
(RES.EXECUTION_ID_ is null)
or
(PI.SUSPENSION_STATE_ = XXX)
)
LIMIT XXX OFFSET XXX;
select RES.*
from ACT_RU_JOB RES
LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_
where (RES.TYPE_ = 'timer')
and (RES.DUEDATE_ is not null)
and (RES.DUEDATE_ < '2015-07-15 10:42:47.464')
and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ < '2015-07-15 10:42:47.464')
and (RES.RETRIES_ > 0)
and (
(RES.EXECUTION_ID_ is null)
or
(PI.SUSPENSION_STATE_ = 1)
)
order by DUEDATE_;
select RES.*
from ACT_RU_JOB RES
LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_
where (RETRIES_ > 0)
and (DUEDATE_ is null or DUEDATE_ <= '2015-04-17 14:59:09.982')
and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ <= '2015-04-17 14:59:09.982')
and (
(RES.EXECUTION_ID_ is null)
or
(PI.SUSPENSION_STATE_ = 1)
)
LIMIT 1 OFFSET 0;
select RES.*
from ACT_RU_JOB RES
LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_
where (RES.TYPE_ = 'timer')
and (RES.DUEDATE_ is not null)
and (RES.DUEDATE_ < '2015-04-20 09:12:13.551')
and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ < '2015-04-20 09:12:13.551')
and (RES.RETRIES_ > 0)
and (
(RES.EXECUTION_ID_ is null)
or
(PI.SUSPENSION_STATE_ = 1)
)
order by DUEDATE_;
07-18-2015 11:35 PM
07-19-2015 12:07 AM
07-19-2015 12:42 AM
07-19-2015 12:43 AM
07-19-2015 01:08 AM
07-19-2015 01:13 AM
07-19-2015 09:32 PM
07-23-2015 11:22 AM
07-28-2015 04:48 AM
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.