Query Builder

[system]

Hi,

These topics can help:

120×120 10.4 KB

Hi Can somebody help me to understand what is mean by Query Builder in BO and where can I find it and its uses? Thanks. stvel (BOB member since 2007-10-04)

120×120 10.4 KB

Hi This post is a list of CMC queries, i.e. queries that can be executed using the Query Builder tool, that I use most often. If anyone else has some useful queries then reply and add them to this topic - hopefully we can build up a good library of CMC queries! List of all user groups SELECT * FROM CI_SYSTEMOBJECTS WHERE SI_PROGID='CrystalEnterprise.UserGroup' or SELECT * FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'UserGroup' List of all folders SELECT * FROM CI_INFOOBJECTS WHERE SI_PROGID = 'C…

120×120 10.4 KB

I have compiled a list of queries that will get some basic information out of the CMC. I’m trying to figure out how to run more complex queires to get all the reports that I need. here is the initial list. feel free to add queries… Thanks Get All Webi reports Select SI_ID, SI_NAME From CI_INFOOBJECTS Where SI_PROGID=‘CrystalEnterprise.Webi’ And SI_INSTANCE=0 Get Full Client Reports SELECT SI_ID, SI_NAME,SI_FILES FROM CI_INFOOBJECTS WHERE SI_KIND in( ‘webi’ ,‘FullClient’) Get All reports S…

---

Marek Chladny (BOB member since 2003-11-27)