I'm trying to use the webservices to do a query of KT with webservices, I'm using "Search" method, but when I want to sort by another field different to "Relevant" I get the following error "AHD03203:Wrong number of values from db" and in the stdlog "Could not create list using KD_list_web_HITS in factory KD:FAC:NC:ATTR:OB:MTH:".
For the test, I'm using the App SoapUi, and how example this is the parameters:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://www.ca.com/UnicenterServicePlus/ServiceDesk"><soapenv:Header/><soapenv:Body><ser:search><sid>97288201</sid><problem>problemas</problem><resultSize>10</resultSize><properties>TITLE,DOC_TYPE_ID,HITS</properties><sortBy>HITS</sortBy><descending>1</descending><relatedCategories>1</relatedCategories><searchType>1</searchType><matchType>0</matchType><searchField>15</searchField><categoryPath></categoryPath><whereClause></whereClause><maxDocIDs>10</maxDocIDs></ser:search></soapenv:Body></soapenv:Envelope>
What is the problem??
What is the SDM version and patch level you are testing this on?
Hi, I test in 12.6 (CUM#2) and 14.1 (CUM#3)
I would recommend raising a support case for this, the problem seems to be just with the
RELEVANCE is the only item that seems to work there...
Andres, try use "HITS DESC" instead of "HITS" in <sortBy>. Thanks _Chi
Please ignore this update...we tried it with HITS_DESC and HITS DESC, none of them worked...please open a Support case so we can
investigate. Sorry for the confusion. Thanks _Chi
I have successfully tested on 14.1.04.01 using "faq" web services call with HITS as the sortBy value.