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

Article Id: 35715

Status: Published

Updated On: 24-09-2019 11:17

Legacy Id: TEC1465237

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:

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