Extract SI_Runtime duration through Query Builder?

[Former Member]

Hi All,

Using query builder we are using the following query find reports run between

a set of dates using :-

select SI_NAME, SI_OWNER, SI_AUTHOR, SI_SCHEDULEINFO.SI_STARTTIME from

CI_INFOOBJECTS where SI_SCHEDULEINFO.SI_OUTCOME<2 and

SI_SCHEDULEINFO.SI_STARTTIME>='2013.10.21 04.00.00'

and SI_SCHEDULEINFO.SI_STARTTIME<='2013.10.21 09.00.00'

order by SI_SCHEDULEINFO.SI_STARTTIME

What we need, is the Runtime duration added to this. Is it possible to get this Information from Query Builder?

Regards,
Sandeep

[TammyPowlas]

Moved to BI Platform space for faster response