DFS script: The folder path is return with a semicolon (;)

Hi,

We are developing a .Net application using dfs to get folder path of all existing folders from a cabinet. We use Documentum 6.5 sp2.The folder path returns an semi colon(;) in front of the folder path while executing a dql query through the dfs.

The .Net script is as shown below

DQLQuery.QueryString = "select acl_name, acl_domain, r_folder_path from dm_folder where cabinet('/cabinet1')";

QueryExecution DQLQueryEx = new QueryExecution();

DQLQueryEx.CacheStrategyType = CacheStrategyType.DEFAULT_CACHE_STRATEGY;

OperationOptions DCTMOperationOptions = null;

QueryResult DCTMQueryResult = DCTMQueryService.Execute(DQLQuery, DQLQueryEx, DCTMOperationOptions);

DataPackage DCTMResultPackage = DCTMQueryResult.DataPackage;

List<Emc.Documentum.FS.DataModel.Core.DataObject> DCTMDataObjects = DCTMResultPackage.DataObjects;

if (DCTMDataObjects.Count > 0)

{

foreach (Emc.Documentum.FS.DataModel.Core.DataObject DCTMObjects in DCTMDataObjects)

{

PropertySet DCTMDocProperties = DCTMObjects.Properties;

ACLName = DCTMDocProperties.Get("acl_name").GetValueAsString();

ACLDomainName = DCTMDocProperties.Get("acl_domain").GetValueAsString();

FolderPath = DCTMDocProperties.Get("r_folder_path").GetValueAsString();

MessageBox.Show("Folder path is " + FolderPath);

}}

The system popups as the folder path “; /cabinet1/Test folder”

"; /cabinet1/Test folder A"

Is there anyway we can filter the semicolon (;) from the folder path which is not correct.

Thanks & regards

blessing

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

bacham2

That's what the method Property.getValueAsString() does for repeating attributes. What you want are the individual values stored in r_folder_path. So do it like this:

PropertySet DCTMDocProperties = DCTMObjects.Properties;

StringArrayProperty folderPathProps = (StringArrayProperty) DCTMDocProperties.Get("r_folder_path");
String folderPath = folderPathProps.getValues()[0];

Hicham

All comments

bacham2

This is probably because r_folder_path is a repeating attribute. Therefore, you should include r_object_id in your DQL query. That will give you each folder in a single result row, with r_folder_path values separated by ; You then probably just want to retrieve the first value of r_folder_path for each folder.

Hicham

blessbk

Still I am getting the values with semicolon(;).. Is there anyway i can get only the actual values for the repeated attributes in a row basis.. Not in a concatenated string format (delimited by ?

I need to list down the keywords of a folder and documents in a list box. Can you guys help me on this.

bacham2

That's what the method Property.getValueAsString() does for repeating attributes. What you want are the individual values stored in r_folder_path. So do it like this:

PropertySet DCTMDocProperties = DCTMObjects.Properties;

StringArrayProperty folderPathProps = (StringArrayProperty) DCTMDocProperties.Get("r_folder_path");
String folderPath = folderPathProps.getValues()[0];

Hicham

blessbk

Hi Hicham,

It works.. Thanks a lot

With Regards

bless