How to get ID using search service

Hi,

I am using search service and I am able to get name & location.

But i want to get nodeID.( What attribute should i use to get "ID" )

Can anybody help me.

Following is my code

SingleSearchRequest req = new SingleSearchRequest();

String sData = "'"+searchService.getDataCollections().get(0)+"'";
req.setDataCollectionSpec(sData);       // use the Enterprise search slice
req.setQueryLanguage(searchService.getSupportedQueryLanguages().get(0)); // use the Search API for queries
req.setFirstResultToRetrieve(1);                          // start retrieving results at Result #1
req.setNumResultsToRetrieve(50);                          // retrieve up to 50 search results
req.setResultOrderSpec("sortByRegion=OTCreatedBy");    // sort by the OTCreatedBy region
req.setResultSetSpec("where1=\"<OTSubType>0\"");   //   where clause of the query type = Folder

List alResultTran = new ArrayList<String>();

alResultTran.add("OTName");
alResultTran.add("OTLocation");

req.setResultTransformationSpec(alResultTran);

searchResp = searchService.search(req, "");

Find more posts tagged with

Comments

Kyle_Swidrovich

Hi Rahul,

The region you’re looking for is “OTDataID”.

Regards,

Kyle

Rahul_Bhagwat

Thanks for reply Kyle,

But still i couldn't get Id.
Not even only OTDataID ,i couldn't get attribute like OTOwnerID,OTCreateDate,OTParentID

But i am intresting only to get OTDataID.

Is there any attribute restiction for search service through java webservice?
beacuse I am getting OTName ,OTLocation & OTMimeType ..etc but not OTDataID,OTOwnerID,OTCreateDate,OTParentID.

Following is my code

SingleSearchRequest req = new SingleSearchRequest();

String sData = "'"+searchService.getDataCollections().get(0)+"'";
req.setDataCollectionSpec(sData);       // use the Enterprise search slice
req.setQueryLanguage(searchService.getSupportedQueryLanguages().get(0)); // use the Search API for queries
req.setFirstResultToRetrieve(1);                          // start retrieving results at Result #1
req.setNumResultsToRetrieve(50);                          // retrieve up to 50 search results
req.setResultOrderSpec("sortByRegion=OTCreatedBy");     // sort by the OTCreatedBy region
req.setResultSetSpec("where1=\"<OTSubType>0\"");   //   where clause of the query type = Folder

List alResultTran = new ArrayList<String>();
alResultTran.add("OTDataID");
alResultTran.add("OTName");
alResultTran.add("OTLocation");

req.resultTransformationSpec =alResultTran;

searchResp = searchService.search(req, "");

I have another question ,I couldn't see SingleSearchRequest.setResultTransformationSpec API.
Isn't it available on CS 2010?

Thanks

Colin_Lawton

Though I don't use the java webservice myself, just the .net one it strikes me that you can view the results when they are strings but your list of things you can't see are all the items that aren't strings (dates and integers).

I know the data I have returned from my search calls puts the strings and integers and dates all in seperate parts of the returned data structure so could it be you aren't looking in the right place for the non-string data?

Rahul_Bhagwat

Hi Colin,
you mean say, from where i am collecting search result data, right?

Following is place where i am collecting search result data.

List alResultTran = new ArrayList<String>();
alResultTran.add("OTDataID");
alResultTran.add("OTName");
alResultTran.add("OTLocation");

searchResp = searchService.search(req, "");

List<SGraph> alGraphs = searchResp.getResults().getItem();
for(SGraph sGraph: alGraphs){
alNodes = sGraph.getN();
System.out.print("\n");//Result row
for(SNode sNode: alNodes){
  for(Object sAttVal: sNode.getS()){
   System.out.print(sAttVal+"\t\t| "); // Each attribute Value.
               //here i am getting only OTName & OTLocation values
  }
}
}

Please suggest me if i am looking at wrong place.

Colin_Lawton

for(Object sAttVal: sNode.getS()){
   System.out.print(sAttVal+"\t\t| "); // Each attribute Value.
               //here i am getting only OTName & OTLocation values
  }

Again I am only guessing at this point as how I use this is different to what you're doing. But on my data response the strings are stored under s, the integers under i etc

I see you are using a lot of S's in your code getS etc. Maybe there is a getI?

Rahul_Bhagwat

Hi Colin,

Thanks for your help.

I understnad what u r saying.

getI() - For integer values

getS() - For String values

getD() - For Date values.

But getI() & getD() API returns null value every times.

I don't understand where i am wrong. Even i don't get any error.

System.out.print("String values : "+sNode.getS()+"\t\t| ");
System.out.print("Integer values : "+sNode.getI()+"\t\t| ");
System.out.print("Date values : "+sNode.getD()+"\t\t| ");

Also, In search result Analysis I can able to see Attributes/column names of type string only.

System.out.println("Attribute Names "+searchResp.getResultAnalysis().get(0).n.get(0).s);//String
System.out.println("Attribute Names "+searchResp.getResultAnalysis().get(0).n.get(0).i);//Int
System.out.println("Attribute Names "+searchResp.getResultAnalysis().get(0).n.get(0).d);//Date

sgrasley

Hi, Rahul.

Do you have OTDataID configured as a displayable region?

Also, when setting your ResultTransformationSpec, try doing this:

req.getResultTransformationSpec().add("OTDataID");

etc.

Thanks,

Scott

Rahul_Bhagwat

Hi Scott,
Thanks for reply,

I have configured "OTDataID" as display region but its not giving Id's.
I am able to get only string region values.
Are you able to get ID's with java search services?

Thanks

sgrasley

Hi, Rahul.

Can you send the response itself? That might be helpful in seeing what needs to be done via the JAX-WS proxies.

To pursue this issue further, enabling search logs might be the way to go. You can set the following in opentext.ini:

[general]
Debug=2

[options]
wantSearchLogs=TRUE
wantDebugSearch=TRUE

This will include search information in the Content Server thread logs as well as create separate logs for search.

Thanks,

Scott