Error on filter V20 on extra field

Using my Dolibarr
1

I get this error on a list:

Error in request SELECT rowid as rowid, lastname FROM llxu0_user AND ((job = ‘mystringvalue’)) ORDER BY lastname 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 ‘AND ((job = ‘mystringvalue’)) ORDER BY lastname’ at line 1. Check setup of extra parameters.

This is the code for the filter list
user:lastname:rowid::(job:=:‘mystringvalue’)

2

Hello,

See here : Issue in Dolibarr 20

3

Solved as user:lastname:rowid::(job:like:‘%SAT’)

1 Like