BusinessObjects Board

Getting the list of documents in the XI Repository

sdk development
#1

I am trying to get the list document names from the BOXI repository as below but it brings only the open documents list
any one know how to get the list of documents in the repository
Thanks in advance

              Set docs = BOapp.Documents
                
                BOapp.ExchangeMode = boRepositoryMode
                        For I = 1 To docs.Count
                                strDocument = docs(I).Name
                        Next I

Rameshkumark (BOB member since 2002-08-29)

#2

Hello there -

I would look through the code posted in this utility found at the BOB downloads section:

It should have what you want.

Good luck.

Atul Chowdhury (BOB member since 2003-07-07)

#3

Not in Crystal interfaces

I am looking in COM references :shock:

Rameshkumark (BOB member since 2002-08-29)

#4

I think u can find the document names via the CMS database

AuguC (BOB member since 2009-11-20)

#5

sorry I should have explained clearly earlier

I know we can get the document name

but how???

It`s not working to me the above code
What I need is if any one done using COM VBA then how you managed to do it?

Thanks

Rameshkumark (BOB member since 2002-08-29)

#6

You would need to query the CMS database from your code. I have never done it in VBA but you would need something like this.

This is in C#

        InfoObjects objInfoObjectsReports = (InfoObjects)objInfoStore.Query
                    ("select SI_NAME from CI_INFOOBJECTS WHERE SI_KIND='Webi' OR 'FLASH'");

AuguC (BOB member since 2009-11-20)