Can you delete files from the repository programmatically? 1

[xlbo]

I have successfully run queries againmst the repository to find the reports currently unretrieved against each user. What I would like to do is to take this one step further and use VBA to delete those reports that were sent prior to a certain date.

Have searched this and other forums but cannot find any definite yes / no answers as to whether it can actually be done never mind any sample code to do it......don't really want to delete via SQL as I have no idea what other links may get damaged by doing so...

any ideas ??

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[blom0344]

Wait a minute, this is confusing. Do you mean deleting the documents as files or the fact that they are registrated in the repository?
AFAIK the files themselves are not stored in the repo?

Ties Blom
Information analyst

 

[skrandel]

Why do you need to use code to do this. The Supervisor has the command in it already. There is the ability to delete unread inbox documents.

So, given that it's in Supervisor, you'd have to see if the Supervisor API has the ability. I think it does not.

Blom, prior to XI, documents are stored in the OBJ_X_DOCUMENTS table as blobs. So the whole thing is in there.

Steve Krandel
Symantec

 

[xlbo]

Steve - thanks for the info - I am more of a 'power user' of business objects with some db experience rather than DBA / SysAdmin who manages the Supervisor module so I am unaware of some of the functionality that exists there.

Does the functionality exist (within supervisor) to delete reports sent before a certain date for all users in a specified Supervisor Group in one go ??

If not, you have your answer as to why I am trying to do this.

If so, then that will do nicely

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[skrandel]

Actually, the functionality deletes all reports that are a specified age for ALL users regardless of group.

Steve Krandel
Symantec

 

[xlbo]

Thanks all

For anyone wondering it is under Tools>Purge Inbox Documents

Whilst this doesn't quite give me the control I want, I really don't think it is worth trying to crack this one with code so thanks to Steve for the info

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question