Skip to Content
Former Member
Feb 14, 2011 at 04:21 PM

How to find all the instances for specific recurring report


How can I use UQery Builder to find out all the instance related to specific Recurring job. I have tried using following query to get the result with poor performance.

select SI_ID, IS_SCHEDUILE_STATUS from ci_infoobjects where SI_NEW_JOB_ID = 2604480

Since I find that SI_ID stores the current instance id and SI_NEW_JOB_ID stores the recurrign job's ID.

Please Help.

Edited by: Gabriel Luk on Feb 14, 2011 5:21 PM