Query using SingleSearch.

Hi All,

Am trying to fetch the values of attributes from OT DB using singlesearch but it prints me only the attribute name not its value below is my code.

singleSearchRequest.setDataCollectionSpec(prop.getProperty("name"));

singleSearchRequest.setQueryLanguage("Livelink Search API V1");

singleSearchRequest.setResultSetSpec(prop.getProperty("where name='samplefolder' and subtype=0"));

if(null != singleSearchRequest.getDataCollectionSpec()){

val = singleSearchRequest.getDataCollectionSpec();

System.out.println(" *****value in the query " + singleSearchRequest.getDataCollectionSpec());

}

OUTPUT:*****value in the query name.

Thanks in advance

Find more posts tagged with

Comments

Kyle_Swidrovich

Girish,

Please refer to my old 9.7.1 SearchService sample posted here in the community for logic to parse search results.

Also, a point of clarification, the search service does not go against the Content Server database but rather searches the search index introduced by the creation of a data source folder.

Regards,

Kyle

Vrushu

Thanks Kyle,

For your reply , need some ore information

IN C# I CAN SEE THE SSOTAUTH is passed

SearchService.SingleSearchResponse results = ss.Search(ssOTAuth, query, "");

below is my java code

SingleSearchRequest singleSearchRequest = new SingleSearchRequest();

SearchService_Service service = new SearchService_Service();

SearchService search = service.getBasicHttpBindingSearchService();

singleSearchRequest.setDataCollectionSpec("'LES Enterprise'");

singleSearchRequest.setQueryLanguage("Livelink Search API V1");

singleSearchRequest.setFirstResultToRetrieve(1);

singleSearchRequest.setNumResultsToRetrieve(100);

singleSearchRequest.getResultTransformationSpec().add("OTName");

singleSearchRequest.setResultSetSpec("where1=\"OTSubType\":0 AND \"OTName\":\"WebServiceSha\" AND \"OTParentID\":70088");

System.out.println("Calling search");

SingleSearchResponse results = search.search(singleSearchRequest, "");

if(null != results){

System.out.println("This is the result "+results.getResults());

}

i dont see any option of passing auth token and am getting the below error

2015-02-19 12:31:16,423 WARN [http-apr-8080-exec-11] Livelink error occurred
2015-02-19 12:31:16,423 WARN [http-apr-8080-exec-11]   Status: -2147482645
2015-02-19 12:31:16,423 WARN [http-apr-8080-exec-11]   Error Code:
2015-02-19 12:31:16,423 WARN [http-apr-8080-exec-11]   Error Message:
2015-02-19 12:31:16,423 WARN [http-apr-8080-exec-11]   ApiError:
FAILED!
ns0:Core.LoginFailed : javax.xml.ws.soap.SOAPFaultException

Thanks in advance

eLink User

It is quite likely when your code is hitting the livelink server it does not have authentication information or expired info.So how do you find it out?

Method 1: Login to the livelink URL that usually ends in /llisapi.dll or livelink.exe or livelink.Do you see an authentication screen that looks like an HTML page and not one that looks like a windows auth prompt?.If you were seamlessly taken into the application then this "instance" of livelink server has its authentication set to some authentication.assuming the simplest mechanism it could be IWA also interchangeably known as NTLM,SSO etc etc.

Method2:Open up the opentext.ini file on your "instance".Put debug=2 and WantLapiLogs=true and re-start the instance. Then pass a simple wsapi call like calling enterprise workspace or so.One of the simple java samples you have here https://knowledge.opentext.com/knowledge/llisapi.dll/fetch/2001/15080935/-15106263/15106294/15106295/16376487/17990637/45500683/java_src/cwsCodeSamples_Java.zip.Look in the thread logs for places like <inArgs and <outArgs.It will have debug info.If you don't see it here and your code works perhaps your code is getting answered by another instance or terminating at the webserver not even reaching livelink.

Method 3-Put Fiddler and learn how to use it when you hit a webserver.Then you can actually see your WSAPI client code making requests in Action.Many times they are going to indicate something.

Method 4: There is a livelink sysadmin request handler that goes like <LIVELINKURL>?func=admin.testargs.Do you see "REMOTE_USER" filled and a auth mechanism something resembling this AUTH_TYPE =Negotiate REMOTE_USER =DOMAIN\USERID or userid@domain REQUEST_METHOD =GET Then chances are this livelink is protected by a auth method other than "anonymous" Most webservices samples written by OT pertains to simple anonymously authenticated livelink servers.Do you have SSO samples lying in the web or here.Sure search for Guy Pomerleaux or me for a few who have ventured with it in the forums .Just by trial and error of the Web.Config and App.Config I have suceeded.Why wouldnt OT put a official sample,guesses are different web server different ways of deploying livelink,too much work to officially support it although the OTDS mechanism is kind of a middleware to address that

Now I have given you many pointers that would lead to successful coding.However let it be known that a livelink can be configured in very many different ways such as an admin can put a expiration of livelink cookie to a very low value,you could be bouncing off livelink servers ,your code may come from a redirected system such as SAP or SP lots of problems could occur if the architecture is not well understood by replying people like me or even you.I am not a OT employee but have worked enough to know certain things that could occur.So my simple request to you would be to as much as possible educate yourself and the forum about the same. Also try the simplest mechanisms of OT code first to iron out the difficulties.It should not be too hard.

FYI I recently took Kyles' code and re-purposed it for a project I am doing.I wouldn't know where to start if it was not there

..Appu

I wonder how one could debug livelink if Fiddler, Wireshark and Softerra LDAP browser was not invented and not free

On Thu, Feb 19, 2015 at 1:47 AM, eLink Entry: Content Web Services Forum <otdncontentwebservices971forum@elinkkc.opentext.com> wrote:

RE Query using SingleSearch. Posted bygirish_pande@infosys.com (Pande, Girish)On 02/19/2015 02:41 AM

Thanks Kyle,For your reply , need some ore informationIN C# I CAN SEE THE SSOTAUTH is passedSearchService.SingleSearchResponse results = ss.Search(ssOTAuth, query, "");
below is my java code
SingleSearchRequest singleSearchRequest = new SingleSearchRequest();
SearchService_Service service = new SearchService_Service();
SearchService search = service.getBasicHttpBindingSearchService();

singleSearchRequest.setDataCollectionSpec("'LES Enterprise'");
singleSearchRequest.setQueryLanguage("Livelink Search API V1");
singleSearchRequest.setFirstResultToRetrieve(1);
singleSearchRequest.setNumResultsToRetrieve(100);
singleSearchRequest.getResultTransformationSpec().add("OTName");
singleSearchRequest.setResultSetSpec("where1=\"OTSubType\":0 AND \"OTName\":\"WebServiceSha\" AND \"OTParentID\":70088");

System.out.println("Calling search");

SingleSearchResponse results = search.search(singleSearchRequest, "");
if(null != results){
System.out.println("This is the result "+results.getResults());
}
i dont see any option of passing auth token and am getting the below error

2015-02-19 12:31:16,423 WARN [http-apr-8080-exec-11] Livelink error occurred
2015-02-19 12:31:16,423 WARN [http-apr-8080-exec-11]   Status: -2147482645
2015-02-19 12:31:16,423 WARN [http-apr-8080-exec-11]   Error Code:
2015-02-19 12:31:16,423 WARN [http-apr-8080-exec-11]   Error Message:
2015-02-19 12:31:16,423 WARN [http-apr-8080-exec-11]   ApiError:
FAILED!
ns0:Core.LoginFailed : javax.xml.ws.soap.SOAPFaultException

Thanks in advance
[To post a comment, use the normal reply function]
Topic: Query using SingleSearch.
Forum: Content Web Services Forum
Content Server: Knowledge Center

sıɹɥɔ

Quoted Girish Pande on 02/19/2015 08:36 AM:

Thanks Kyle,

For your reply , need some ore information

IN C# I CAN SEE THE SSOTAUTH is passed

SearchService.SingleSearchResponse results = ss.Search(ssOTAuth, query, "");

below is my java code

SingleSearchRequest singleSearchRequest = new SingleSearchRequest();

SearchService_Service service = new SearchService_Service();

SearchService search = service.getBasicHttpBindingSearchService();

[...]

i dont see any option of passing auth token and am getting the below error

[...]

Hi Girish,

There are subtle differences between using C# and Java. As you noted the C# code passes authentication information with each method call. In Java, however, you don't need to do this and instead you set authentication information into the object representing the service.

In your code above you're missing one line:

setSoapHeader((WSBindingProvider) search, otAuth);

Please see the Getting Started section of the documentation, specifically the Java-related description and code samples.

Hope this helps,

-chris

Vrushu

Thanks Chris,

It worked for me.

But the query result is fetched only at enterprise workspace level , say if i want to retrive all the folder objects present in OT DB, and let say:

Workspace foldercount foldername

Enterprise wrkspace 3 a,b,c

personal wrkspcA 5 1,2,3,4,5

and singleSearchRequest.setResultSetSpec(wher1=\"OTSubType\":0)

singleSearchRequest.getResultTransformationSpec().add("OTName")

the singalsearchresponse gives result a,b,c.

below is the logic i used to print the result set.

results = srrSvr.search(singleSearchRequest, "");

if(null != results){

System.out.println("This is the result "+results.getResults().getItem().size());

SResultPage res = results.getResults();

if(0!=res.getItem().size()){

List<SGraph> metaLis = res.getItem();

for(int i=0; i< metaLis.size(); i++){

for(int j=0;j<metaLis.get(i).getN().size();j++){

for(int k=0; k<metaLis.get(i).getN().get(j).getS().size(); k++){

System.out.println("THe values are "+ metaLis.get(i).getN().get(j).getS().get(k));

}

Thanks in advance