AnsweredAssumed Answered

Search a ticket logged by a particular user

Question asked by Ritu on Jun 1, 2016
Latest reply on Jun 2, 2016 by Ritu

I need to search an incident/request on the basis of the ticket number and the user handle (for a particular user).

Here is the request xml that i am using:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://www.ca.com/UnicenterServicePlus/ServiceDesk">

   <soapenv:Header/>

   <soapenv:Body>

      <ser:doSelect>

         <sid>1480381124</sid>

         <objectType>cr</objectType>

         <whereClause>ref_num='TKT3484812' AND customer='122BE77CCECC7248BCCB24F3E73EFDFE'</whereClause>

         <maxRows>100</maxRows>

         <attributes>

            <!--1 or more repetitions:-->

         </attributes>

      </ser:doSelect>

   </soapenv:Body>

</soapenv:Envelope>

 

But this gives the error:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

   <soapenv:Body>

      <soapenv:Fault>

         <faultcode>soapenv:Client</faultcode>

         <faultstring>Error fetching: AHD03053:Bad where clause: Parse error at : "ref_num='TKT3484812' AND customer='122BE77CCECC7248BCCB24F3E73EFDFE'" (Bad where clause)</faultstring>

         <faultactor/>

         <detail>

            <ErrorMessage>Error fetching: AHD03053:Bad where clause: Parse error at : "ref_num='TKT3484812' AND customer='122BE77CCECC7248BCCB24F3E73EFDFE'" (Bad where clause)</ErrorMessage>

            <ErrorCode>103</ErrorCode>

         </detail>

      </soapenv:Fault>

   </soapenv:Body>

</soapenv:Envelope>

 

Pls. help me out with this.

Outcomes