Fun with Query Builder

I cannot explain this.

SELECT SI_ID, SI_NAME, SI_CUID FROM CI_INFOOBJECTS WHERE SI_ID=23
1/1
Properties
SI_NAME Root Folder
SI_CUID ASHnC0S_Pw5LhKFbZ.iA_j4
SI_ID 23
SELECT SI_ID, SI_NAME, SI_CUID, SI_PARENTID, SI_PARENT_CUID
FROM CI_INFOOBJECTS WHERE SI_PARENTID=23
1/10
Properties
SI_NAME Report Conversion Tool
SI_CUID AY9zJ8BgaF9OucZ2h2slcJM
SI_PARENT_CUID ASHnC0S_Pw5LhKFbZ.iA_j4
SI_PARENTID 0
SI_ID 123

Why the hell SI_PARENTID=0 in the result if SI_PARENTID=23 is in the query restriction?

7 thoughts on “Fun with Query Builder

  1. Matthias

    Well it is even worse. Those ID’s are constant, while the names are internationalized. So 23 or 0 is just scratching on the surface (and yes, the root is 4).

    Like

    Reply
  2. Kumar

    Hi Bukantsov,
    I have been reading your blogs related to “Query builder series”,I have a requirement where I need to get the contents of BIAR file(generate a detailed list of reports moved thru biar file).I have written the below query and was able to get the BIAR file details but not able to get the names of the reports moved through BIAR file.Reports moved through BIAR file entries i could find i file store folder->input folder->properties file has the names of report but these are not stored physically.
    ***************** my query ********************
    Select SI_ID, SI_NAME, SI_PARENTID, SI_KIND From CI_INFOOBJECTS Where SI_KIND In (‘CrystalReport’,’Webi’,’Excel’,’PDF’,’Rtf’,’Txt’,’Universe’,’Word’,’LCMJob’) And SI_INSTANCE_OBJECT < 1 Order By SI_NAME, SI_ID
    I need the list of reports moved by using BIAR file meaning BIAR file contents.
    I have tried various forms of queries after reading your blogs and by googling but of no use.Can you help me with a custom query or any other suggestion.
    Regards,
    Kumar

    Like

    Reply
    1. dmytro Post author

      Hi Kumar,
      I do not quite understand how you run the query against BIAR. It is possible to query what is in the BO but not what is in BIAR (?)
      Do you import a BIAR and then want to find what was imported? Or do you want to find what is in the BIAR without importing?
      Thanks,
      Dmytro

      Like

      Reply
      1. kumar

        Hi Dymtro,
        my requirement is to get the list of reports (report names and other details related to moved report executables) moved using BIAR file.
        I want to import the BIAR and get the deatils of what was imported through BIAR file.
        I want to generate a custom report or export these details of the contents that have been moved through BIAR file and send it to my supervisor(manager),I have downloaded your custom Query builder utility and tried to get the output by through Queries but was not able to get.
        Do you have any query that can fetch these details or any custom sdk java program to get these details.
        One more thing i want to specify is that inside file store object in input folder there are properties file that store the details of the reports or content moved using BIAR file,How do i get these details exported to excel?Do you have any java program (sdk) to achieve this or any custom query that i can run.

        Regards,
        kumar

        Like

      2. dmytro Post author

        Hi Kumar
        Thanks for explanation.

        I tried to import a BIAR using ImportWizard and the command line tool but this has not created any properties file in my Input File Store (BO XI 3.1 SP5). So I am still curious how do you get one and how it looks.

        I do not think it is possible to find what was imported. BO does not keep history about the origins of objects. So as to my knowledge, you cannot check if a report came from a BIAR or it was created on this system. It might be that BO Auditing tracks this, but I do not know.

        If you have BIAR file, you can find what is inside by unzipping it and looking into BusinessObjects.xml.

        Like

  3. Kumar

    Hi Dymtro,

    I am Looking for query to find List of DESKI and WEBI reports having Filter with a Calculation operand “Objects from this query” and “Results from the another query” and DESKI reports on Freehand SQL.

    Thanks,
    Kumar

    Like

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s