Changing the query result to a string for dotnet consumers in dfs

Hi All,

I am facing some problems while trying to change the query result in dfs to a string value for dotnet consumers.

I thought the following piece of code does the work for java consumers but the same does not work for dotnet consumers :

String strMaxValue = queryResultForId.getDataObjects().get(0).getProperties().get("max_value_from_repository").getValueAsString();

Can anyone tell me what can I change in the above line of code to make it work for dotnet consumers?

The following is the complete piece of code that I am using :

PassthroughQuery

query = new PassthroughQuery();query.QueryString =

"select max_val,cur_val,prefix_val from test_table where status=1";query.AddRepository(_repository);

QueryExecution queryEx = new QueryExecution();queryEx.CacheStrategyType =

CacheStrategyType.DEFAULT_CACHE_STRATEGY;

OperationOptions operationOptions = null;

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

strMaxValue = queryResult.getDataObjects().get(0).getProperties().get(

"max_val").getValueAsString();

Find more posts tagged with

Comments

aflowers001

What error/symptom are you seeing in the .NET application?

Rajesh_Chandak

Hi Andy,

The error that I get when I build the solution in Visual Basics is as follows:

Error 1 'Emc.Documentum.FS.DataModel.Core.Query.QueryResult' does not contain a definition for 'getDataObjects' and no extension method 'getDataObjects' accepting a first argument of type 'Emc.Documentum.FS.DataModel.Core.Query.QueryResult' could be found (are you missing a using directive or an assemblyreference?)

aflowers001

Ah...The issue is that whilst the .NET DFS Client API is semantically the same as the Java API (i.e. it does the same things) it does it in a .NET way (i.e. uses properties instead of getters/setters).

If you look in the .NET SDK documentation yo will be able to see this, and for your specific line of code it should look something like

strMaxValue = queryResult.DataObjects(0).Properties.Get("max_val").getValueAsString();

NOTE : This is not an exact translation as it is from memory but it should be enought ot get you started.

BTW : IntelliSense should assist greatly with this when typing in the code.

Rajesh_Chandak

Hi Andy,

Thanks for the reply. Your solution was useful to a good extent but it still threw an error saying DataObjects(0) is not allowed as it is not a method. I tried other combinations as well like

strMaxValue = queryResultForId.DataObjects.GetRange().GetProperties().GetValue("max_val").ToString();

but another error was thrown as the GetValue() should only take the int array value. Hence I thought of dropping the idea of generating the string value with this approach and used another approach to get the same value. Here it is:

PassthroughQuery

queryForId = new PassthroughQuery();queryForId.QueryString =

"select max_val,cur_val,prefix_val from testid_vars where status=1";queryForId.AddRepository(_repository);

QueryExecution queryExForId = new QueryExecution();queryExForId.CacheStrategyType =

CacheStrategyType.DEFAULT_CACHE_STRATEGY;

OperationOptions operationOptionsForId = null;

QueryResult queryResultForId = _queryService.Execute(queryForId, queryExForId, operationOptionsForId);

DataPackage resultDp = queryResultForId.DataPackage;

List<DataObject> dataObjectsForId = resultDp.DataObjects;

foreach (DataObject dObj in dataObjectsForId){

PropertySet docPropertiesForId = dObj.Properties;

strMaxValue = docPropertiesForId.Get("max_val").GetValueAsString();strCurVal = docPropertiesForId.Get(

"cur_val").GetValueAsString();strPrefix = docPropertiesForId.Get(

"prefix_val").GetValueAsString();

Console.WriteLine(" max value is " + strMaxValue);

Console.WriteLine(" current value is " + strCurVal);

Console.WriteLine(" prefix value is "+ strPrefix);

}

As the dotnet people were in hurry of this functionality, I have done it as above. Meanwhile, I am trying to get the String value with that single line of code.

More inputs are always welcome:)

Thanks

Rajesh Chandak