Accessing custom properties in C# via WSDL

Hello everyone.

I'm new to Documentum and completely lost. I hope someone can answer this.

I'm making the Console app in C# to access Documentum server using wsdl.

the goal is to select all documents that may need an update in custom properties. Then I need to update some properties and post them back

( or update an document object as I figure form manuals). When I list documents through a web browser in WebTop, each document has a set of Custom Attributes

that I need to read and then update. However, when I query the server I get standart or general list of properties ( 18 of them ) that do not include ones that I can see in the browser. I use select statement "SELECT * FROM dm_sysobject WHERE FOLDER ('/.......')"

Am I doing it wrongly?

I'm using PassthroughQuery and QueryService. which returns a DataPackage (DataPackage resultDp = queryResult.DataPackage;)

Any help is greatly appreciated.

Thanks

Vadim

Find more posts tagged with

Documentum

Comments

liaojiyong

Hello,

Vadim

if you want query custom attrs,you should query from subtype of "dm_sysobject“ or "dm_document"。

e.g. select r_object_id,customattr from custom_type

Vadim0303

Thanks, but that's what I do - I query dm_sysobject.

In Webtop, when I rightclick the document and select Properties I get small window with several tabs on it: General Atttributes, Custom Attributes, Date Attributes.

Custom Attributes tab shows some of data that I'm trying to get.

When I run my query "Select * from dm_sysobject" and check what it returned, I do not see any of Custom properties in the return.

Do I need to specify the field in the query or when I check returned object?

Do I need to link dm_sysobject and dm_document ( if yes, on what fields?)

Thanks

zhou_simonq

yes, you should specify the field in DQL. Just have a try.

What did you mean by "link"? actually, dm_document is inherited from dm_sysobject. so dm_document get all attributes from dm_sysobject.

Vadim0303

I'll be more specific.

Our documents will have a number of custom attributes,like ICN, MemberID and such.

If I use these fields in the query I get an error that query fails.

Here is the example of what I do:

"SELECT icn,member_id FROM dm_sysobject WHERE FOLDER ('/vg_test_folder')"

If I just use "SELECT * FROM dm_sysobject WHERE FOLDER ('/vg_test_folder')", I get basic 18 properties.

Same thing if I select from dm_Folder.

I read documentation it says that there are r_objects and s_objects, and those two are linked on r_object_id, so I thought that may be custom properties are stored in another table or object? It's a guess.

Again, in the WEBtop, I can see those custom properties in the Properties window.

May be solution to this problem is very simple, but I so far I can't figure it out.

Thanks

Vadim

abc123

Hi Vadim,

Extended properties are not querable from parent tables. From the example, icn and member_id are extended properties of the custom type and can not seen by its parent type.

- SELECT r_object_id FROM dm_sysobject will return all objects that has type dm_sysobject or type descendant extending from dm_sysobject.

- SELECT non_sysobject_attribute FROM dm_sysobject is not allowed.

- SELECT ASTERISK (*) only returns a selected list of properties, depending on the query type.

Please refer to DQL reference to get more information.

Regards,

William

Vadim0303 wrote:
If I use these fields in the query I get an error that query fails.Here is the example of what I do:"SELECT icn,member_id FROM dm_sysobject WHERE FOLDER ('/vg_test_folder')"