How to create web services query for greater than symbol using XML Operators
Article ID: 35715
SUPPORT AUTOMATION- SERVERCA Service Desk Manager - Unified Self ServiceKNOWLEDGE TOOLSCA Service Management - Asset Portfolio ManagementCA 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 <= 'xxxx'" (Bad where clause)</faultstring>"
For example: "open_date >= '1433127599' and open_date <= '1435719599'"
Please follow the below steps to correct the parse errors:
1. Replace the following ">=" symbols and use ">=" 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
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