This page will list out possible scenarios when malformed query error is raised.
Please note the majority of these errors occur when using temporal filter or when the form/field names are edited after the queries have been saved.
Recognition exception at input
This error occurs in the following scenarios:
- 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.
- 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 field or Invalid form
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:
- 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.
- 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.