How to exclude the Personal folders from the query

sdk development
1

Hi
I am documenting all webi reports that we have in our repository except the documents in the personal folders. Is there a way I could exclude the documents in the personal folders. At the moment my query is as basic as:
select SI_NAME, SI_ID from CI_INFOOBJECTS Where SI_Kind=‘Webi’

Another issue I have is that I have to document the query for each datasource in the webi document to form a metadata information for our reporting platform.

Is there a way to achieve this.

Kindly help.

samirpamar79 (BOB member since 2012-04-24)

2

Instead of using the generic query that you have I would do this:

  • Get all of the folders under the root folder with a query like this:

Select SI_NAME, SI_ID from CI_INFOOBJECTS where SI_KIND = ‘Folder’ and SI_PARENTID = 0 and SI_NAME != ‘User Folders’

  • Using a recursive method, walk through each folder’s sub folders and their subfolders etc. Pull the reports for each using the folder’s ID as the parent ID.

This will get you some basic information about each report. Because the first query excludes “User Folders”, this will automatically exclude the reports in the personal folders.

From there I’m not sure how to get to the query in the report as I’ve never had to do this, but I’m sure someone else here does.

-Dell

hilfy :us: (BOB member since 2007-04-16)