Notifications

25 views

Description

When I open a record which contains a filter using changes to I receive a SQL exception such as the SQL illustrated below:

Example:

Business rules that use the ChangesTo operator in the Query Builder receive the error : Error MessageSyntax Error or Access Rule Violation detected by database (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CHANGESTO 

Release or Environment

All releases

Cause

There is a record count on the filter. Changes to is not a valid option which can be used with a record count. 

Resolution

1) Right click on the filter condition field on the form and select configure dictionary

2) Review the attributes and configured on this dictionary record and remove the attribute "how_condition_count=true"

Article Information

Last Updated:2019-09-15 20:21:59
Published:2019-09-16