I cannot explain this.
SELECT SI_ID, SI_NAME, SI_CUID FROM CI_INFOOBJECTS WHERE SI_ID=23
| 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
| 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?
Like this:
Like Loading...
Related
bukhantsov.org 
haha, it seems the internal join is done through the CUID. Funny! wonder what else goes on there…
LikeLike
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).
LikeLike
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
LikeLike
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
LikeLike
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
LikeLike
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.
LikeLike
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
LikeLike