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="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 &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).

 

Thanks

Outcomes