search cancel

How to create web services query for greater than symbol using XML Operators


Article ID: 35715


Updated On:


SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager


When building SOAP web service queries, using 'doQuery' method gives an parse error message on the field 'open_date' with XML operators as criteria .

Below error message occurs when incorrect operators are user.

"Error: On creating SOAP web services query  <faultstring>Error fetching: AHD03053: Bad where clause: Parse error at : "open_date >= 'xxxxx' and open_date &lt;= 'xxxx'" (Bad where clause)</faultstring>" 

For example: "open_date >= '1433127599' and open_date <= '1435719599'" 


Release: SDMU0M99000-14.1-Service Desk Manager-Full License



Please follow the below steps to correct the parse errors:

1.    Replace the following ">=" symbols and use "&gt;=" instead, so the query will look like as shown in the screenshot below.

2.    For other list of XML operators please find the below screenshot

Additional Information

In XML, several characters are part of the syntactic structure of XML and will not be interpreted as themselves if simply placed within an XML data source. You need to substitute a special character sequence called an "entity" by XML