I'm trying to use doQuery to retrieve tickets count using open_date as criteria.
So, I want to know how many tickets i have between two specific dates.
So, i create a XML Envelope with this information:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://www.ca.com/UnicenterServicePlus/ServiceDesk"> <soapenv:Header/> <soapenv:Body> <ser:doQuery> <sid>SESSION ID/sid> <objectType>cr</objectType> <whereClause><![CDATA[open_date >= '1433127599' and open_date <= '1435719599']]></whereClause> </ser:doQuery> </soapenv:Body> </soapenv:Envelope>
When I try to do that (using SOAPui) and I receive this as response:
<faultstring>Error fetching: AHD03053:Bad where clause: Parse error at : "open_date >= '1433127599' and open_date <= '1435719599'" (Bad where clause)</faultstring>
So, SOAP webserver change the less-then symbol to < value and I receive a bad where clause.
Anyone already face this error? I`m trying with SDM 12.9 (Apache Only).