# Error on filter V20 on extra field

**URL:** <https://www.dolibarr.org/forum/t/error-on-filter-v20-on-extra-field/29460>\
**Category:** Using my Dolibarr\
**Tags:** Help\
**Created:** [October 7, 2024, 2:18pm UTC](https://www.dolibarr.org/forum/t/error-on-filter-v20-on-extra-field/29460 "2024-10-07T14:18:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![f.sintes](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/f/5f8ce5/32.png) [@f.sintes](https://www.dolibarr.org/forum/u/f.sintes)\
**Post date:** [October 7, 2024, 2:18pm UTC](https://www.dolibarr.org/forum/t/error-on-filter-v20-on-extra-field/29460/1 "2024-10-07T14:18:48Z")

</div>

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’)

---

<div class="post-metadata">

**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\
**Post date:** [October 7, 2024, 2:29pm UTC](https://www.dolibarr.org/forum/t/error-on-filter-v20-on-extra-field/29460/2 "2024-10-07T14:29:25Z")

</div>

Hello,

See here : [Issue in Dolibarr 20](https://www.dolibarr.org/forum/t/issue-in-dolibarr-20/29437)

---

<div class="post-metadata">

**Author:** ![f.sintes](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/f/5f8ce5/32.png) [@f.sintes](https://www.dolibarr.org/forum/u/f.sintes)\
**Post date:** [October 7, 2024, 2:47pm UTC](https://www.dolibarr.org/forum/t/error-on-filter-v20-on-extra-field/29460/3 "2024-10-07T14:47:47Z")

</div>

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