Hi There,
I have some instances of webi report.
In history I see more than 200 instances.
From Query builder for particular date i am able to see instances.
eg
select
SI_PARENTID,SI_STARTTIME,SI_ENDTIME,
SI_CREATION_TIME,SI_NAME,SI_SCHEDULEINFO.SI_SUBMITTER,
SI_HAS_PROMPTS,SI_KIND,SI_SCHEDULE_STATUS
FROM CI_INFOOBJECTS
WHERE SI_PARENTID=289435
and SI_STARTTIME >= '2009/02/14/00/00/00'and SI_ENDTIME < '2009/02/14/16/59/59'
ORDER BY SI_ID DESC
I am able to see 5 instances created on 14th Feb 2009.
3 instances of morning
and 2 instances of afternoon.
but if I modify the above query to
select
SI_PARENTID,SI_STARTTIME,SI_ENDTIME,
SI_CREATION_TIME,SI_NAME,SI_SCHEDULEINFO.SI_SUBMITTER,
SI_HAS_PROMPTS,SI_KIND,SI_SCHEDULE_STATUS
FROM CI_INFOOBJECTS
WHERE SI_PARENTID=289435
and SI_STARTTIME >= '2009/02/14/16/00/00' and SI_ENDTIME < '2009/02/14/16/59/58'
ORDER BY SI_ID DESC
I am not able to get instance which was created on ' 2009/02/14/16/10/20 '.
Can anybody plz look into the query and let me know if i need to make any changes.
Product XI 3.0.
Any help appreciated...
Thanks,
Praveen.
Edited by: Praveen SG on Feb 27, 2009 2:49 PM
Edited by: Praveen SG on Feb 27, 2009 2:50 PM