1450058 - Incorrect results in Query Builder with SI_STARTTIME in WHERE clause

Incorrrect results in Query Builder with SI_STARTTIME in WHERE clause. The query compares results with SI_SCHEDULEINFO.SI_STARTTIME instead of SI_STARTTIME.

Business Objects XI Release 2 Service Pack 5

Tomcat 5

• Run below query in Query Builder which retreives incorrect results as the query compares results with SI_SCHEDULEINFO.SI_STARTTIME instead of SI_STARTTIME
• SELECT * FROM CI_INFOOBJECTS WHERE SI_SCHEDULE_STATUS IN (3,1,9,0) AND SI_INSTANCE = 1 AND SI_RECURRING = 0 AND SI_STARTTIME >= '2010.02.04'

Use SI_ENDTIME in conjunction with SI_STARTTIME in where clause to get proper results of the query.

Example:

SELECT * FROM CI_INFOOBJECTS WHERE SI_SCHEDULE_STATUS IN (3,1,9,0) AND SI_INSTANCE = 1 AND SI_RECURRING = 0 AND SI_STARTTIME >= '2010.02.04' AND SI_ENDTIME <= '2010.02.10'

KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem