Skip to Content
avatar image
Former Member

Help with Query Builder

Hi,

I am trying to get a daily statistics of failed instances using Query Builder. I tried to use fields like SI_UPDATE_TS and SI_STARTTIME to filter instances with in a date range, but date range functions does not seem to work. Is there documentation somewhere as to which fields can be used or how the query should be formatted to get results like this?

Thanks

Ajith

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 17, 2008 at 12:04 AM

    Hello Ajith,

    I advise you to look at the [SAP notes|http://service.sap.com/notes] listed below, these should help you with your problem.

    - Note 1200070 - How to use dates in Query Builder queries

    - Note 1185136 - How to query for recurring report instances in a date range using the Query Builder

    Hope this helps.

    Regards,

    Kristof

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Ted Ueda

      Hi Ted,

      As you mentioned above that we can use detailed level of columns in XI 3.1 in conditions, can we select the detailed level of columns in the query as ;

      Select SI_NAME, SI_PROCESSINFO,SI_PROCESSINFO.SI_LOGON_INFO.SI_LOGON1.SI_SERVER From CI_INFOOBJECTS Where SI_INSTANCE=0 And SI_PROCESSINFO.SI_LOGON_INFO.SI_LOGON1.SI_SERVER='tueda-sqlserver'

      Please let me know if we can select detailed level of columns and if yes can you please provide me a sample query.

      Thanks