How to fix 'Malformed Query' error?

This page will list out possible scenarios when malformed query error is raised.

Recognition exception at input

This error occurs in the following scenarios:

1. The function used in the temporal expression is invalid or non-existent. The error highlights the incorrect function name.
   • Fix: Refer to the document for the correct function name and its usage.
2. The field name starts with a number like '260280ratio'. The error highlights the form having the erroneous field name.
   • Fix: Edit the form to rename the field. All form fields should start with an English alphabet (a-z or A-Z).

Invalid form or field name

This error occurs when an invalid field is referenced in the query. The error highlights the erroneous field name. This error occurs in the following scenarios:

1. User is creating a temporal filter and typed incorrect field name.
   • Fix: Edit the temporal filter and choose the fields from the suggestions offered by the wizard.
2. The form fields were renamed after the query was created. To fix the error, delete and recreate the filter
   • Fix: When the offending field is in the filter, delete and recreate the filter.
   • Fix: When the offending field is in the results view, open columns wizard, first unselect all the fields and finally reselect the required fields.

Too many tables

This error occurs when large number of fields are selected in the results view. This is the limitation imposed by the underlying database (esp. MySQL/MariaDB) and not the query interface itself.

• Fix: Open columns wizard, and remove sub-form fields selection that will reduce the number of table lookups.