BusinessObjects Board

how2differentiate btwn public folder and user reports path?

server administration XI Server Discussion
#1

Hi ,

I am trying to retrieve Most accessed documents report, but i want only public folder reports and i don’t want any inbox and favorite folder located reports?

What should i give as query filter in the report to retrieve only public folder docs? Any help would be appreciated.

Thanks in advance.

MightyBO :us: (BOB member since 2007-06-28)

#2

the following query lists all public folders basically all folders that have folder ‘23’ as an ancestor (23 is root folder) the inclusion of or si_id = 23 means that root folder is also returned

SELECT * FROM CI_INFOOBJECTS
WHERE si_kind = 'Folder' and (SI_ANCESTOR = 23 OR SI_ID = 23)

See this topic for more useful queries,

regards

AL

agulland :uk: (BOB member since 2004-03-17)

#3

Thanks AL.

But i am pulling the report from audit data, is there any indicator or special instructions to follow there?

Thanks

MightyBO :us: (BOB member since 2007-06-28)