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

Products

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

Issue/Introduction

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'" 

Environment

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

Resolution

Instructions:

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