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

SAP Knowledge Base Article - Public

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

Symptom

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

Environment

Business Objects XI Release 2 Service Pack 5

Tomcat 5

Reproducing the Issue

  • 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'

Resolution

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'

 

Keywords

KBA , BI-BIP-ADM , BI Servers, security & CrystalReports viewing in BI platform , Problem

Product

SAP Crystal Reports 9.0