Help with Query Builder

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Thanks Kristof. That sure helps. But I have one more question I would like to filter for the data base environments too. In the Processing Info section of the results I am seeing values for SI_SERVER under SI_LOGON_INFO. But I am not able to use that field in the query. Is there a way I can get the structure of the table CI_INFOOBJECTS and how to access fileds in processing info.

Thanks

Ajith

[Former Member · Accepted solution]

Hello Ajith,

I think this note will help you out: 1205563 - How to use Processing Info fields in the Query Builder.

Regards,

Kristof

[Former Member · Accepted solution]

Thanks Kristof. Only problem with that option is that it allows only one level of fields. I searched notes for an option to access fields in lower levels. For example, SI_SERVER field in SI_LOGON_INFO. Is that possible? Is there any documentation about what each fields is for?

Appreciate your help.

Ajith

[Former Member · Accepted solution]

Hello Ajith,

The Query Builder interface is actually rather limited, as you have found out yourself. I don't know if you have any programming experience, but the Query Builder is nothing more than an interface which will use the SDK in the background to talk to the CMS. In other words, if you know how to program for your BO XI deployment (Java or .NET), you can write the logic necessary to retrieve whatever information you want. You'll also find that the SDK documentation contains an explanation (though sometimes limited) for the properties and members that are available.

Although using the SDK might seem overwhelming at first, it's actually quite easy and far more powerful than the Query Builder alternative. Also, Business Objects hosts quite a few code samples that should easily get you started. There's also a dedicated SDK forum for all specific issues relating to development.

Some links to get you up and running:

• [Developer Library|https://boc.sdn.sap.com/developer/library]

• [Code Samples|https://www.sdn.sap.com/irj/sdn/businessobjects-samples]

• [Business Objects SDK Application Development Forums|https://www.sdn.sap.com/irj/sdn/businessobjects-sdk-forum]

Hope this helps!

Kind regards,

Kristof

[Former Member · Accepted solution]

Thanks. I will try some SDK documentation. Anyways we are upgrading to CRS 2008 and the new instance manager gives us what we need. Thanks again.

[ted_ueda · Accepted solution]

Just as a follow-up:

In XI Release 2, you couldn't specify child property constraints, but you can in XI 3.0 (or Crystal Reports Server 2008). For example, with the newer version, you can run queries of the type:

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

Sincerely,

Ted Ueda

[Former Member · Accepted solution]

Hi Ted,

could you please tell me how to access Query Builder in CRS 2008? I could not find that in CMC. and CRS 2008 does not have an Admin Launchpad as in CRS XI R2.

Thanks

Ajith

[ted_ueda · Accepted solution]

It's been separated from the other Admin apps (in fact, Query Builder is the only one left):

http://<hostname>:<port>/AdminTools

Sincerely,

Ted Ueda

[Former Member · Accepted solution]

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