Help with Java Search LAPI Please

I'm trying to figure out how to search Livelink via the Java API's and I'm getting a bit confused. Any help or comments would be greatly appreciated (please, I'm tired of reading about LAPI's shortcomings, so only post something useful

)Here's the situation...According to the Livelink API Developer's Reference (pp.494), the method ApplyQuery() takes in the following arguments: objID, selectList, where, sortBy, rankBy, startAt, forHowMany, queryConversion.My primary issue (right now) is with the selectList value. The selectList is supposed to be an LLValue object containing all the fields which you want returned. I've created an LLValue object like so: LLValue selectList = new LLValue().Than I try to add an item to it using the following syntax: selectList.add("OTName"); // <-- a valid search fieldThe code compiles fine, but upon execution I get the following error: com.opentext.api.LLIllegalOperationException: add(value) not implemented for this datatype at com.opentext.api.LLInstance.add(LLInstance.java) at com.opentext.api.LLValue.add(LLValue.java) at qcpinc.livelink.Livelink.search(Compiled Code) at qcpinc.livelink.Livelink.main(Compiled Code)I've checked the API documentation, and it showes that there is "supposed" to be an add(datatype value) method, where the datatype is a valid object type, such as String. I'm assuming my code does this, but apparently not. Can someone provide an example of how to do this type of add to an LLValue?If anyone has any code examples of searching Livelink via the API's that they could forward, I would be very much appreciative.Again, thank you in advance for any help and support in this.

Find more posts tagged with

Comments

Development_Base4_(Base4User10_(Delete)_2261135)

It seems like you didn't set selectList to the type List. Try using the initialization asLLValue selectList = (new LLValue()).setList();John

Ray_Peterson_(rpeterso_-_(deleted))

Thank you, that worked and got me past that problem. :-) Now that I'm past that, I format the rest of the variables accordingly, but I'm getting a return value of -2147482647 (whatever that means - also, if anyone has any ideas of how I can determine what these error codes means, that would be great) when I execute the ApplyQuery() method. :-(Have you (or anyone) performed any searches via the Java API's? If so, can you post an example of the ApplyQuery() method?Thanks again.

Ray_Peterson_(rpeterso_-_(deleted))

I've figured out how to get more error information using the (documented) session method calls, and I've fixed the previous error (apparently, the RankBy was incorrectly formatted), but now I get a new error number, but nothing else, no status message, error message or api error, just a number... any suggestions? Error number is -2147481632.Thanks again for the help and support.

eLink User

Message from Simone Oettinger via eLinkIs your "SortBy" empty? The following problem is reported in the ReleaseNotes:"ApplyQuery() will not work properly if sortBy is not specified (left as anempty list), but rankBy is initialized with a value."Thanks,SimoneSimone OettingerProduct ManagerOpen Text Corporation847-267 9330 ext 4224simone@opentext.com> -----Original Message-----> From: eLink Discussion: LAPI Discussion> [mailto:lapi@elinkkc.opentext.com]> Sent: Tuesday, August 15, 2000 1:38 PM> To: eLink Recipient> Subject: RE- RE- RE- Help with Java Search LAPI Please>>> RE- RE- RE- Help with Java Search LAPI Please> Posted by rpeterso on 08/15/2000 02:33 PM>> I've figured out how to get more error information using the> (documented) session method calls, and I've fixed the previous> error (apparently, the RankBy was incorrectly formatted), but now> I get a new error number, but nothing else, no status message,> error message or api error, just a number... any suggestions?> Error number is -2147481632.>> Thanks again for the help and support.>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Topic: Help with Java Search LAPI Please> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objI> d=2324325&objAction=view>> Discussion: LAPI Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=765428&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Ray_Peterson_(rpeterso_-_(deleted))

Here's what I've got for my code:LLValue selectList = (new LLValue()).setList();selectList.add("OTName");selectList.add("OTObjectDate");selectList.add("OTObjectSize");selectList.add("OTLocation");String where = "OTName regex \"TGP\"";int sortby = LAPI_SEARCH.SORTBYRELEVANCY;String rankby = "";int startat = 0;int forhowmany = 10;String queryconversion = "None";int result = search.ApplyQuery(objID, selectList, where, sortby, rankby, startat, forhowmany, queryconversion, objInfo);It looks like I'm defining the sortby as the default (according to the documentation), but... I've been wrong before. :-) )Thanks for the help.

Brad_Bosley_(bradbosley_-_(deleted))

I would love to find out the solution to this as well! I'm trying out some similar code, and I'm getting the exact same return status (-2147481632) and no error messages. The only difference is that I'm doing this in C++, instead of Java.Mmmm....suspicious....the LLAPI documentation for 8.1.5 (for Solaris) does not include a Search example. There's examples of most everything else, but no search.

David_Slimmon

Hi Brad,I'd recommend that you open up a call to our LAPI (SDK) support guys on some of these issues in this thread. Having said that, I've just had this forwarded an example you might consider using for testing in the meantime. See attached.Regards,Dave

Brad_Bosley_(bradbosley_-_(deleted))

Dave,Thanks for the example. I'm now able to successfully execute the LL_ApplyQueryRecArray function.I had the queryConversion set to "None". I was unaware of the "LivelinkQueryLanguage" option, since it isn't mentioned in the LLAPI documentation. Thanks again!

Ray_Peterson_(rpeterso_-_(deleted))

Any chance of getting a Java example? I've printed out the C++ example and am going to attempt to convert it, but if you happen to have a Java example lying around... :-)Thanks

Brad_Bosley_(bradbosley_-_(deleted))

Simply try changing the queryConversion to "LivelinkQueryLanguage". That's the only thing I changed, and it worked.

Ray_Peterson_(rpeterso_-_(deleted))

I changed the query language to LivelinkQueryLanguage, and now I get the following error:Error Number: -2147481632Status Message: Unable to process query: the WHERE clause is missing or badly formatted.Error Message:API Error:I've changed my where string to "livelink" (just like the example), and I've tried "OTName = livelink", "OTName = \"livelink\""... it just won't work. :-(Help me please.... I've fallen and can't get up...

Brad_Bosley_(bradbosley_-_(deleted))

I suspect I'm having a "where" problem as well. I'm getting a good status return on the LL_ApplyQuery function, but I'm getting 0 results each time, regardless of what I try.

eLink User

Message from David Slimmon via eLinkHi again guys,It would really be best to open up logs on these so the SDK Support guys cantalk you through some of this.Cheers,Dave-----Original Message-----I suspect I'm having a "where" problem as well. I'm getting a good statusreturn on the LL_ApplyQuery function, but I'm getting 0 results each time,regardless of what I try.

Jeremy_OConnor

Try adding OTObject to the selectlist. I believe this is required or ApplyQuery will not return any results. As for the Where clause try the following format:"[region \"OTName\"] \"test\""I have also attached a Java example for you to look at.

Jeremy_OConnor

Just a couple of corrections to my last post. The where clause that I gave in my last post "[region \"OTName\"] \"test\"" will only work if you use "none" instead of LivelinkQueryLanguage as the queryConversion. If you use LivelinkQueryLanguage then you must use the following syntax:"(OTName $:\$ "test\")"eg:status = search.ApplyQueryRecArray( nBrokerId,vSelectFields,"(OTName $:\$ "test\")",search.SORTBYDEFAULT,"",0,25,"LivelinkQueryLanguage",vQueryResults );orstatus = search.ApplyQueryRecArray( nBrokerId,vSelectFields,"[region \"OTName\"] \"test\"",search.SORTBYDEFAULT,"",0,25,"none",vQueryResults );

Ray_Peterson_(rpeterso_-_(deleted))

Thank you, with your example and your help, I was able to get it to execute the query, however it's still not returning anything from the query. I've got documents in there, and when I execute a search via the web page, the correct documents are returned, but I can't seem to get the java code to return anything... do you have any other suggestions? I've opened a ticket with OT Support, but I'm now in the queue and waiting for their callback.Thanks again.

Brad_Bosley_(bradbosley_-_(deleted))

After adding OTObject, I was able to receive the results. Now, the only problem is that some of the queryable fields do not have values. OTMIMEType is the primary example of this. I'm able to find data in many of the queryable fields, but this field in particular (a field that we need to use for our queries) doesn't return anything.I'd appreciate any input.Thanks!

Jacob_Gsoedl_(eu0013543_-_(deleted))

Error number -2147482644Any ideas what is this?

x-scoruser8_-_(deleted)

I've found session.getStatus(), session.getErrMsg(), and session.getStatusMessage() on the LLSession object helpfull...