List Webi documents with Query Builder, in public folder

[xavier_darre]

Hello experts,

I am trying to retrieve the list of Webi documents with Query Builder on SAP BI 4.1 SP5 : I only want to have the Webi documents' names for the ones I can found in the public folder. Do you know how I can retrieve only these documents ?

Thank you

[rajdeep_marathe · Accepted solution]

SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND=Webi AND SI_RUNNABLE_OBJECT = 0 AND SI_INSTANCE_OBJECT = 0 AND SI_ANCESTOR = 23

[TJe · Accepted solution]

This would give all the WebI documents, also in Subfolders.

[xavier_darre · Accepted solution]

Thank you Rajdeep. Any idea to mix this information with the folder names in the public folder ?

[TJe]

For the public folder you would use the si_parentid=23 condition, but guess there are no documents in the root folder only in subfolders. Here the query for the WebI samples folder:

select si_id, si_name, si_kind, si_parentid from ci_infoobjects where si_parent_cuid='AeN4lEu0h_tAtnPEjFYxwi8'

[xavier_darre]

Thank you Thomas. It seems that Rajdeep's query is the good one.