How to get properties from dm_relation using DFS

Question

Hi,

I'm using DFS 6.5 thanks to .Net.

I would like to get a property from the table dm_relation.

I have a query :

StringqueryString = "SELECT child_label FROM dm_relation"

+

"WHERE parent_id='" + r_object_idMaster + "' AND child_id='" + r_object_idChild + "'";

I would like to use the IQueryService in order to get the result :

PassthroughQuery query = new PassthroughQuery();query.QueryString = queryString;

query.AddRepository(myRepository);

QueryExecution queryEx = new QueryExecution();

queryEx.CacheStrategyType =CacheStrategyType.DEFAULT_CACHE_STRATEGY;

OperationOptions operationOptions = null;

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

The query works when I use Repoint.

Other queries work fine, for different tables : dm_folder,  dm_cabinet, etc..

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

How can i get the result as String ? (if it can work .. )

abc123 · Accepted Answer

Hi Wilhelm,

Please check if there is a blank char between "dm_relation" and "WHERE" in your expression.

StringqueryString = "SELECT child_label FROM dm_relation"+"WHERE parent_id='" + r_object_idMaster + "' AND child_id='" + r_object_idChild + "'";

Otherwise, I didn't find any mistakes in the code. The dm_relation table is queryable.

If there is still errors. Please copy the detail error stack here. Thanks!

I also notice that you have asked the same question in this thread: https://community.emc.com/thread/3712?tstart=0

- William