Relationships and Checkin with DFS in C#

wperaud

Hello,

I used Composer to create a custom type ( let's call it "cType" ) thats inherits from dm_document.

I also created a custom relationship ( let's call it cRelation ) between two cType document, from master to child.

I use DFS in an application, and I can create, checkout, [...] and checkin cType document.

But I have to create a cRelation when I invoke the checkin.

****

DataObject dataO = new DataObject(masterIdentity);

dataO.Relationships =

null;

ObjectRelationship objectRelationship = new ObjectRelationship(); objectRelationship.Name =

"cRelation";

objectRelationship.Target =

new DataObject(childIdentity);

objectRelationship.TargetRole =

Relationship.ROLE_CHILD;

dataO.Relationships.Add(objectRelationship)

****

When I run the application and make a checkin, I have no error.

The checkin seems to work fine (version OK, content OK,..)

But, no relationship exists O_o

I tried adding a RelationshipProfile to the checkin operationOptions

****

RelationshipProfile

relationProfile = new RelationshipProfile();relationProfile.ResultDataMode =

ResultDataMode.REFERENCE;relationProfile.TargetRoleFilter =

TargetRoleFilter.ANY;relationProfile.NameFilter =

RelationshipNameFilter.ANY;relationProfile.DepthFilter =

DepthFilter.UNLIMITED;

****

That doesn't change anything.

Could someone help me please ?

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

abc123

Wilhelm,

I verified this function. Unfortunatelly, the Checkin operation does not process the relationships. I am not sure whether it should be a bug because there's consistency concern. But as you see at least, this behaviour is not documented well. Currently, you have to call ObjectService.Update() to add the relationships. Hope the workaround workable for your program. Thanks for finding out this issue.

- William

All comments

abc123

Hi Wilhelm,

Firstly, make sure you did have created the new relation type "cRelation". For example, you can DQL it with "select * from dm_relation where relation_name='cRelation'";

Secondly, for the new relationship to add, you need to set its modifier in your code, for example:

objectRelationship.IntentModifier = RelationshipIntentModifier.Add;

If the childIdentity already exists, you'd better use ReferenceRelationship to link the two objects.

- William

wperaud

Hi,

Thank you for your help.

As my childIdentity aldready exists, I change the objectrelationship to a reference one.

I also added :

referenceRelationship.IntentModifier =

RelationshipIntentModifier.ADD;

When I check thanks to DQL, the reference has not been created.

abc123

Wilhelm,

- William

wperaud

Hi again,

I'm glad that my problem has pointed out an issue

I added a calling to the ObjectService.Update().

The relation is created in dm_relation (I checked using DQL)

It is shown in webtop.

It works

Thank you.

abc123

Some more comments on it:

This was initially by design that checkin does not process relationships. But as time proved, customers would like the feature to be supported.

Now it has been an opening bug in DFS and is planned to be resloved in 7.0

- William

wperaud

Ok thank you for your comment.

There is something I would like to do.

Everything works fine when I Update with ReferenceRelationship , exept when I want to add properties.

*************

ReferenceRelationship referenceRelationship = new ReferenceRelationship();

StringProperty stringProperty = new StringProperty("child_label", "CURRENT");List<Property> propertiesList = new List<Property>();

propertiesList.Add(stringProperty);referenceRelationship.RelationshipProperties = new PropertySet();referenceRelationship.RelationshipProperties.Properties = propertiesList;************--> In this case, there is an error while invoking Update();************PropertySet properties = new PropertySet();List<Property> propertiesList = properties.Properties;propertiesList =new List<Property>();StringProperty stringProperty = new StringProperty("child_label","CURRENT");propertiesList.Add(stringProperty);referenceRelationship.RelationshipProperties = properties;************--> In this case, there is no error, but the "child_label" property is still empty. (( looked thanks to DQL ))I don't know what I do wrong

abc123

Hello Wilhelm,

The failed case is a known issue depending on DFC and has corresponding DFS bugs logged by our developers. The ObjectService does not support to update relationship properties for now.

The second case does not fail because you set nothing as a fact in the relationship proeprty list.

- William

wperaud

Hi,

As i need these properties, I use DQL. I can set a property, but I don't know how to get one.

I would like to use this kind of query :

SELECT child_label FROM dm_relation WHERE parent_id='[my parent id]' AND child_id='[my child id]'

***

I have a method that manages queries

public List<DataObject> GetElementQuery(String queryString)

{

try

{

PassthroughQuery query = new PassthroughQuery();

query.QueryString = queryString;

query.AddRepository(ConnectionInfoSingleton.Instance().Repository);

QueryExecution queryEx = new QueryExecution();

queryEx.CacheStrategyType = CacheStrategyType.DEFAULT_CACHE_STRATEGY;

OperationOptions operationOptions = null;

QueryResult queryResult = iQueryService.Execute(query, queryEx, operationOptions);

DataPackage resultDp = queryResult.DataPackage;

List<DataObject> dataObjects = resultDp.DataObjects;

turn dataObjects;

}

atch (Exception e)

{

throw e;

}

**********************

I use this method in order to get several table : dm_folder, dm_cabinet, etc..

With the query to get the child_label, the it fails : " Service method "Excecute" invocation failed"

Is there something I do wrong ? Or is there any other way to just get the child_label as a String ?