How to find all the instances for specific recurring report

[Former Member]

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

[ted_ueda · Accepted solution]

You can try putting an unique value in SI_KEYWORD on scheduling. That property is indexed in the CMS DB.

Sincerely,

Ted Ueda

[Former Member · Accepted solution]

I can not find 'SI_KEYWORD' is a indexed properties in following SAP Notes.

1364250 - Which BusinessObjects Enterprise InfoObject properties are indexed

1499196 - Which of the InfoObject properties are indexed

Edited by: Gabriel Luk on Feb 15, 2011 5:09 AM

[ted_ueda · Accepted solution]

Have you looked in the CMS database for the indexes to the cms_infoobjects6 table columns?

Sincerely,

Ted Ueda

[Former Member · Accepted solution]

Hi all,

I see. Thanks for kindly response. I works now.

Gabriel.

Edited by: Gabriel Luk on Feb 15, 2011 8:21 AM