CA Service Management

  • Private Community

  • 1.  to fetch change order in particular timeframe using ca sdm webservice

    Posted Jul 31, 2017 03:09 AM

    hi, in my org we are using CA SDM 14.1,  i am trying to fetch change order tickets by using doSelect() method of web service, can i fetch tickets that raised in particular time frame? i tried using between keyword but no luck, pls help me



  • 2.  Re: to fetch change order in particular timeframe using ca sdm webservice

    Posted Jul 31, 2017 04:10 AM

    hi,

     

    you can use condition is this way:

    open_date >= SOME_DATE AND open_date <= ANOTHER_DATE

    dates should be defined in UNIX timestamp.

     

    Regards,

    cdtj



  • 3.  Re: to fetch change order in particular timeframe using ca sdm webservice

    Posted Jul 31, 2017 06:55 AM

    hi, this too used, no result :-(



  • 4.  Re: to fetch change order in particular timeframe using ca sdm webservice
    Best Answer

    Posted Jul 31, 2017 07:35 AM

    hi, see the below condition i have given :

         <whereClause> chg.affected_contact.delete_flag=0
                 and open_date>=1486642548 and open_date<=1486642599</whereClause>

     

    Error:  <faultcode>soapenv:Server.userException</faultcode>
             <faultstring>org.xml.sax.SAXParseException; lineNumber: 12; columnNumber: 54; The content of elements must consist of well-formed character data or markup.</faultstring>

            



  • 5.  Re: to fetch change order in particular timeframe using ca sdm webservice

    Posted Jul 31, 2017 08:05 AM

    as SOAP message is XML you need to replace "<" and ">" with "&lt;" and "&gt;"



  • 6.  Re: to fetch change order in particular timeframe using ca sdm webservice

    Posted Aug 01, 2017 10:05 AM

    hi, it worked!!! thank you!