ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
How to create web services query for greater than symbol using XML Operators
Article ID: 35715
Updated On:
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 <= '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:
Component:
Resolution
Instructions:
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
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
Attachments
Feedback
Yes
No
Powered by
