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

Developer Network Q&A

Last Post by Matt Nutsch 2 years ago

1 Posts

1 Users

0 Likes

1,778 Views

RSS

2022-01-11 15:22:13

Topic starter

Matt Nutsch

(@mnutschonenetwork-com)

Honorable Member

315 Posts
127 122 66

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?

Add a comment

Topic Tags

1 Answer

2022-01-11 15:22:40

Topic starter

Matt Nutsch

(@mnutschonenetwork-com)

Honorable Member

315 Posts
127 122 66

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>

Add a comment