2022-01-11 15:22:13
Topic starter
Notifications
Clear all
Developer Network Q&A
1
Posts
1
Users
0
Reactions
2,092
Views
0
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)
What is a work around for this?
1 Answer
0
2022-01-11 15:22:40
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 <= $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>
