VOI
Member
Hi,
since a recent github update I am getting a SQL error when trying to open a list with the following pre-filter:
Field: any dropdown element with an entry where the label is empty, but not the value
Condition: IS NULL
Value: (empty)
Type: Text
The corresponding part in the SQL Statement for a dropdown element called 'dp1' and the label of the empty dropdown entry been "Please Select" is:
i.e. the value of the dropdown entry is incorrectly added after the 'is null' operator.
Could someone please have a look at the code which generates the SQL statement for the list view?
Thanks
Chris
since a recent github update I am getting a SQL error when trying to open a list with the following pre-filter:
Field: any dropdown element with an entry where the label is empty, but not the value
Condition: IS NULL
Value: (empty)
Type: Text
The corresponding part in the SQL Statement for a dropdown element called 'dp1' and the label of the empty dropdown entry been "Please Select" is:
Code:
WHERE table.dp1 is null Please Select
i.e. the value of the dropdown entry is incorrectly added after the 'is null' operator.
Could someone please have a look at the code which generates the SQL statement for the list view?
Thanks
Chris