Notifications
Clear all

File is Invalid: ParseError When Using Less Than or Equal to

1 Posts
1 Users
0 Reactions
2,007 Views
0
Topic starter

When using a less than or equal to comparison in the following format of a Report, I get a ParseError.

(Retrieval Field) <= (Custom Filter Field)

image

What is a work around for this?

1 Answer
0
Topic starter

The following answer was provided by @gmerrill:

This is a limitation of XML. You can't use a < except to start a new xml tag. You have two options:

Option 1: use an "entity" to define the <

<SqlDef Name="BookstoreReportTutorial" GroupName="BookstoreReportTutorial">
 ...
 and ${filterIfNotNull:argQtySoldHigh, QUANTITY_SOLD &lt;= $argQtySoldHigh$}
 ...
</SqlDef>

Option 2: put the entire sql text in a <![CDATA[ ]]> enclosure

<SqlDef Name="BookstoreReportTutorial" GroupName="BookstoreReportTutorial"><![CDATA[
 ...
 and ${filterIfNotNull:argQtySoldHigh, QUANTITY_SOLD <= $argQtySoldHigh$}
 ...
]]></SqlDef>