How to extract documents without recycle bin ?

Hello,

I need to make a liveroprt extracting all the documents (subtype=144) but only those who are not deleted. Not in the recycle bin.

Anybody has an idea ?

Thanks a lot

Line Franco

Find more posts tagged with

Comments

Colin_Schmidt

Not a problem, except in the volume of data.

You'd have to know the OWNERID of the Recycle Bin to exclude it.

Select dt.dataid, dt.name from dtree dt where dt.ownerid = -2000 /* Doesn't include documents under Projects */

Select dt.dataid, dt.name from dtree dt where dt.ownerid <> <recyclebin> /* But excludes documents under Personal WS */

The complexity varies with exactly what areas you want to include or exclude.

If you have a DB tool (Toad, SQL Developer, etc.), you can see the schema and the columns in each table to then know what it is you want out of the report. If you have the Schema manual, that will help too. Get the Schema Champion and Reference Guide for some codes that may help you. There are many others, though not easily found.

Colin J.

On Thu, Jan 16, 2014 at 8:00 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

How to extract documents without recycle bin ? Posted byline.franco@savoye.com (Franco, Line)On 01-16-2014 08:00

Hello, I need to make a liveroprt extracting all the documents (subtype=144) but only those who are not deleted. Not in the recycle bin. Anybody has an idea ? Thanks a lot Line Franco
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.

savoye

Thanks for your reply!

I do this request ===>

select dt.name, dt.versionnum , lastname,dv.datasize from dtree dt join dversdata dv on dt.dataid = dv.docid and dt.versionnum = dv.version, kuaf K where dt.subtype = 144 and dt.versionnum>1 and createdby=K.id and dt.name not in(select name from(SELECT * FROM DTREE t4 start with t4.DATAID=2432 connect by prior t4.DATAID=t4.PARENTID)) order by dv.datasize desc

What do you think about that?

Thanks a lot.

best regards

Line Franco

Colin_Schmidt

It looks as though you want documents with more than one Version.

With the Oracle function it looks like you have it.

You might add "subtype = 144" in the Start code to pick up only Documents or the list would be longer and more to check against.

Colin J.

On Thu, Jan 16, 2014 at 11:13 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

How to extract documents without recycle bin ? Posted byline.franco@savoye.com (Franco, Line)On 01-16-2014 11:09

Thanks for your reply! I do this request ===> select dt.name, dt.versionnum , lastname,dv.datasize from dtree dt join dversdata dv on dt.dataid = dv.docid and dt.versionnum = dv.version, kuaf K where dt.subtype = 144 and dt.versionnum>1 and createdby=K.id and dt.name not in(select name from(SELECT * FROM DTREE t4 start with t4.DATAID=2432 connect by prior t4.DATAID=t4.PARENTID)) order by dv.datasize desc What do you think about that? Thanks a lot. best regards Line Franco
[To post a comment, use the normal reply function]
Topic: How to extract documents without recycle bin ?
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.