Skip to Content
0
Former Member
Feb 27, 2009 at 01:47 PM

Not able to sort Instances

31 Views

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