Need a dql to list down all the documents' object id from the repository

Hi friends,

I need a DQL query to list down all the documents from my repository(from all user created cabinets). while listing the documents I want to filter out the system templates and system related documents.

If i run the following dql

"select r_object_id, object_name from dm_document ;"

This is listing out all the system documents and templates like

09000003800001a8 Default Signature Page Template
09000003800001b2 Blank PowerPoint Pre-3.0 Presentation
09000003800001b3 Blank WordPerfect 6 Document
09000003800001b4 Blank WordPerfect 7 Document
09000003800001b5 Blank WordPerfect 8 Document
09000003800001b6 Blank Excel Workbook 5.0-7.0 Document
09000003800001b7 Blank Excel 97 / 2000 Workbook
09000003800001b8 Blank Excel 97 / 2000 Template
.... etc

Is there anyway i can filter out above documents and list down only the user created documents.

Your help is appreciated.

Thanks & regards

bless

Find more posts tagged with

Comments

DCTM_Guru

Assuming that you dont user docbase owner to create acct, you can filter that system user name from owner_attribute:

select r_object_id, object_name from dm_document where owner_name<>'dmadmin'

jnichols1971

blessbk wrote:Hi friends,I need a DQL query to list down all the documents from my repository(from all user created cabinets). while listing the documents I want to filter out the system templates and system related documents.If i run the following dql "select r_object_id, object_name from dm_document ;"This is listing out all the system documents and templates like 09000003800001a8  Default Signature Page Template  
09000003800001b2  Blank PowerPoint Pre-3.0 Presentation  
09000003800001b3  Blank WordPerfect 6 Document  
09000003800001b4  Blank WordPerfect 7 Document  
09000003800001b5  Blank WordPerfect 8 Document  
09000003800001b6  Blank Excel Workbook 5.0-7.0 Document  
09000003800001b7  Blank Excel 97 / 2000 Workbook  
09000003800001b8  Blank Excel 97 / 2000 Template  
.... etcIs there anyway i can filter out above documents and list down only the user created documents.Your help is appreciated.Thanks & regardsbless

Based on your example, you should be able to use something like this:

select

r_object_id, object_name from dm_document where not (object_name like '% Template%' or object_name like 'Blank %')

I'd run it without the "not" and scan through the results to make sure you're not dropping anything you might need - at which point you could add more 'where' clauses as necessary. For example, in our documentum instance all templates and such had a r_object_type of "dm_document" but all items I'd be interested in did not - so I would be able to refine the critera with a 'and not (r_object_type = 'dm_document') - but that might not apply to you.

lastnitescurry

you could filter by cabinet.... so add the following to your query

WHERE CABINET('/UserCreatedStuff', DESCEND)

blessbk

Hi guys,

Thank you for your responses.

Actually i want to display all user created documents and folder excluding the system generated documents, folders and etc.

Is it possible to get using a dql script?

Please help me

Thanks & regards

bless

XdctmX

Did you try Johnny's suggestion? If you haven’t used your repository owner to create documents and folders then by default all the system generated documents are owned by your repository owner

select r_object_id, object_name from dm_document where owner_name<>'YOUR Repository Owner Name'