Obtain Document FileType and GUID using SearchService

[RajaneeshJM]

Hi, We are using SearchService to search for documents and folders

SingleSearchRequest singleSearchRequest = new SingleSearchRequest();
singleSearchRequest.setDataCollectionSpec("'LES Enterprise'");
singleSearchRequest.setQueryLanguage("Livelink Search API V1");
singleSearchRequest.setFirstResultToRetrieve(1);
singleSearchRequest.setNumResultsToRetrieve(100);
singleSearchRequest.setResultOrderSpec("sortByRegion=OTSubType&sortDirection=ascending");
singleSearchRequest.setResultSetSpec("where1=(\"OTSubType\":0 OR \"OTSubType\":144) AND \"OTParentID\":2000");

singleSearchRequest.getResultTransformationSpec().add("OTName");
singleSearchRequest.getResultTransformationSpec().add("OTDataID");
singleSearchRequest.getResultTransformationSpec().add("OTFileType");
singleSearchRequest.getResultTransformationSpec().add("OTLocation");

We are able to list records of type Documents/Folders. But we are not able to identify the type of the document. For example for a word document the type would be doc or docx, for excel xls or xlsx.

The attribute OTFileType is not helpful. Is there any other attribute that has to be specified?

Also, for a document which has multiple versions, there is a GUID which is common for the document across all versions. OTDataID does not provide the value of the GUID and instead provides the ID which is different for a document for different versions. Is there a different attribute for obtaining for the GUID. GUID is available when DocumentManagement service is used but not in SearchService

 

[appnair]

I dont know if this region is index but dversdata has a mimetype so in search it maybe OTMimeType
OTdataid will not change if a document has 10 versions.it is equivalent to GUID. DocID will be different for any dataid that has more than one version.
If I were you I would ask the administrator of livelink to screen print the OT Regions page which will help you

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

http://www.livelink.in