we are seeing this error, just created one report definition and when try to run its giving bad query, we are selecting fields from the drop down only. also, we have added property and field matching on class as well under the external mapping-
An error occured on executing the query for the report definition - There was a problem getting a list: code: 1064 SQLState: 42000 Message: 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 ‘.`AccruedInterestAmount` AS “AccruedInterestAmount” FROM dm_litigation.LegalFina’ at line 1 DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: 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 ‘.`AccruedInterestAmount` AS “AccruedInterestAmount” FROM dm_litigation.LegalFina’ at line 1 | SQL Code: 1064 | SQL State: 42000