#14 Filtering not working
The SQL generation for filters does not seem to be correct. For instance,
when I try creating and using the following filter:
[Month of year (Invoicing)~Name.en] = 5
on the BeeDemo data, I get this error when tryign to run the report:
Error occured while generating a report.
SCache (ID:aadASHJfQgl) Query Failed
SQL execution failed for: demohost/demo_bee
demohost/demo_bee.> CREATE TABLE sc_aaadf9z6raq4o9 SELECT
lu_zakaznik_fakturujici.kraj_id a1,lu_datum_fakturace.kvartal_id a2,SUM
(polozky_dodak.cena) m1 FROM polozky_dodak, lu_datum AS
lu_datum_fakturace, faktura, lu_zakaznik AS lu_zakaznik_fakturujici
WHERE (('] IN (5))) AND lu_datum_fakturace.id=faktura.datum_id_fakturace
AND lu_zakaznik_fakturujici.id=faktura.zakaznik_id_fakturujici AND
faktura.id=polozky_dodak.faktura_id GROUP BY a1,a2 You have an error
in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near ''] IN (5))) AND
lu_datum_fakturace.id=faktura.datum_id_fakturace AND lu_zakaznik' at
line 1
It looks like the SQL for the filter where clause is mangled:
WHERE (('] IN (5)))
How can I fix this?
