How do you find out the children of a recurring instance

[handle1134]

I am trying to find out the instance objects for a recurring instance.

Suppose that we have two recurring instances for a given report: one that executes DAILY and one that executes WEEKLY. After two weeks from scheduling these 2 instances, we will have 14 instance objects for the DAILY one and 2 for the WEEKLY one.

The question is how do we connect the instance objects from the parent recurring instance? What is the property that connects them ?

Thx

 

[MJRBIM]

The parent-child relationship is only between the ReportObject and the ReportInstances - not between ReportInstances.

If you are using unique parameters DAILY vs. WEEKLY, you may be able to use the parameters to link the various ReportInstances.

 

[jedownsjr]

Using the query builder:

select * from ci_infoobjects where si_parentid='123456'

where the id number is the id number of your recurring instance (2 separate id numbers in this case - 1 unique ID for daily, 1 for weekly).

ID #'s for reports are the parentid's for recurring instances (schedules) ... recurring instances' id numbers are parentid's for the historical instances they produce.

 

[ShortyA]

For info we run the different schedules with different logonids. Therefore all of our reports that run each daily run with a logonid of DAILY. Therefore we can see all instances via the Instance Manager for the daily schedules. Additionally you can then set retention periods for differents schedules. You may want to keep daily reprots for 14 days but weekly ones for 90 days. This can be done simply if you use different logonids for each schedule frequency.

Hope this helps a bit.
ShortyA