# Issues with SQL Filters in Dolibarr REST API

**URL:** <https://www.dolibarr.org/forum/t/issues-with-sql-filters-in-dolibarr-rest-api/25426>\
**Category:** Developing for Dolibarr\
**Tags:** Issue\
**Created:** [June 10, 2024, 7:52pm UTC](https://www.dolibarr.org/forum/t/issues-with-sql-filters-in-dolibarr-rest-api/25426 "2024-06-10T19:52:08Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![DG-Rilling](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/d/e495f1/32.png) [@DG-Rilling](https://www.dolibarr.org/forum/u/DG-Rilling)\
**Post date:** [June 11, 2024, 12:30pm UTC](https://www.dolibarr.org/forum/t/issues-with-sql-filters-in-dolibarr-rest-api/25426/3 "2024-06-11T12:30:51Z")

</div>

For products you can use the following sqlfilter:

```auto
(t.datec:>=:'2022-11-13' and t.datec <'2022-11-16')

```

Syntax described in ~/htdocs/core/lib/functions.lib.php  
 → function forgeSQLFromUniversalSearchCriteria(…)

// Must be (aaa:bbb:…) with aaa is a field name (with alias or not) and bbb is one of this operator ‘=’, ‘\<’, ‘\>’, ‘\<=’, ‘\>=’, ‘!=’, ‘in’, ‘notin’, ‘like’, ‘notlike’, ‘is’, ‘isnot’

---

_[View the full topic](https://www.dolibarr.org/forum/t/issues-with-sql-filters-in-dolibarr-rest-api/25426)._