Bug in EE Showcase sample sql_dynamic_reporting

[Blama]

Hi Isomorphic,

while trying to avoid creating a testcase, I found some bugs in the sql_dynamic_reporting-sample.

Please try the following:
Filter for Quantity=19 (no results)
Filter for Quantity=1 (1 and 2 in the results)
Filter for Total Sales (error message)

Best regards,
Blama

[Isomorphic]

The total sales field is populated via custom SQL - it doesn't map to a real table column, so default filtering doesn't work by default.
To make it work we'd have to further modify the where clause, or have some custom operation logic written in Java to handle an attempt to filter by this field. Doable but not written into the sample as is.

So this is actually just a bug in the sample - that field should be marked as canFilter:false. We'll make that change.

Regards
Isomorphic Software