Sqlfilter between

Developing for Dolibarr
1

How do I use the sqlfilter between?

This doesn’t seem to work (t.date_creation:>:1697883386:<:1697883386)

I still get all 3 orders this thirdparty have made, and I would expect to either get the middle one or get nothing at all

"date_creation": 1697719790,
"date_creation": 1697883386,
"date_creation": 1698653358,
2

you probably have to write it something like this which I haven’t tried yet, but I had to put in () and () to get it to work with the 2 checks below.

(t.label:like:‘%member%’) and (t.tosell:=:1)

so aka, try

(t.date_creation:>:1697883386) and (t.date_creation:<:1697883386)