AnsweredAssumed Answered

Less-than symbol - SOAP

Question asked by andrade on Jun 24, 2015
Latest reply on Jun 25, 2015 by NAS_SPSE

Hello everyone,


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="" xmlns:ser="">
         <sid>SESSION ID/sid>
         <whereClause><![CDATA[open_date >= '1433127599' and open_date <= '1435719599']]></whereClause>


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 &lt;= '1435719599'" (Bad where clause)</faultstring>



So, SOAP webserver change the less-then symbol to &lt; value and I receive a bad where clause.


Anyone already face this error? I`m trying with SDM 12.9 (Apache Only).