event

sdk development
1

Dear Forum Member

I need to get the list of the reports related to particular
Event(File Based).

How i can get this list form query builder

Syetm env : Boxir3
OS : Windows 2003

Regards

kksoft2002 (BOB member since 2009-12-10)

2

I don’t believe you can get it directly. You’ll need to get the ID of the Event that you want, then use the Query Builder to find reports that wait for Events, and then check the SI_DEPENDENCIES of those report to see if your Event is there.

Joe

joepeters :us: (BOB member since 2002-08-29)

3

Hi joePeters
Thanks for your support

i can use this query and get the details of the reports and in that result
i can see the event id under si_scheduleinfo - SI_DEPENDENCIES
How i cans pass this event id .
in my result the event id is 204841

select si_name, si_scheduleinfo from ci_infoobjects where si_runnable_object = 1 and si_scheduleinfo.si_dependencies.si_total > 0

I attached the result out put

Regards
output.xls (26.0 KB)

kksoft2002 (BOB member since 2009-12-10)

4

I don’t know of any way to do it just using the Query Builder. You’ll either have to dump out all reports into Excel and look for that Event ID, or use the SDK to iterate through them.

Joe

joepeters :us: (BOB member since 2002-08-29)

5

Thanks Joepeters
I will do it in excel , Thanks for your support & help
Regards

kksoft2002 (BOB member since 2009-12-10)