Problem of ApplyQuery - search.SORTBYREGION

Hi, I'm writing a Java using ApplyQuery (search.SORTBYREGION). I use "OTName" as the "rankby" parameter. But the result is not sorted by "OTName". What is the problem? Thanks a lot.The coding is showed as follows:status = search.ApplyQuery(nBrokerId,vSelectFields, "("+szSearchFor+")"+ " AND (" +szSearchLocationID+ ")" + " AND-NOT(OTName:\"Home Page Config\")"+ " AND(OTCurrentVersion:\"TRUE\")" + " AND ((OTSubTypeName:\"Alias\" )" + " OR (OTSubType:" + Integer.toString(documents.DOCUMENTSUBTYPE)+ " OR "+Integer.toString (documents.URLSUBTYPE)+" OR 2015))", search.SORTBYREGION, "OTName", intStartNo, intRecPerPage-1, "LivelinkQueryLanguage", vQueryResults );Best Regards,

Find more posts tagged with

Comments

William_Eddy_(parsadmin_-_(deleted))

Richard,I have the same problem. The livelink didn't sort the results based on the region in rankBy. Further it crashes when rankBy is set to "OTObjectTime". Let me know if you have found any solution.

Richard_Ma_(mtrcadmin_-_(deleted))

Have recently installed Livelink v9.1 SP2 with September patch and find that the SortByRegion (by OTName) works!I have also tried sort by OTObjectTime but no records can be retrieved, seems OTObjectTime cannot be used.But...... what surprising me is that when SortbyRegion (OTName) , the OTName result is in descending order (starts from "Z" to "A") instead of normal case ascending orderTry to find how to change into ascending order but in vain.Feel a bit frustrated how "good" ApplyQuery() is!