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

Document ID : KB000035715
Last Modified Date : 14/02/2018
Show Technical Document Details

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

001.JPG

 

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.

002.JPG

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

003.JPG

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