I want to filter customer based on last modification

Developing for Dolibarr
, , ,
1

I try this Api call:
thirdparties?sortfield=t.rowid&sortorder=ASC&limit=100&page=0&mode=1&sqlfilters=(t.tms%3A%3E%3A’20211021061010’)

2

Hello

and what is your results - you may give a screenshot ???
and what is your Dolibarr’s version ???
and did you try with another fiels ‘t.datec’ for example ???

Good continuation

3

image
image995×918 29.9 KB

Dolibarr Version: 7.0.0
Right now I am using “t.datec” field for filter but I want last modified data.

4

Hello (on this forum, we say hello, and we eventually thank the volunteers!!!)

Version 7 is 4 years old !!!
If it works with “t.datec”, it is probably because field “tms” is not in the sql selection for api thirdparties
You might check “api_thirdparties.class.php” source and correct this

Good continuation !!!

5

Hello,

At least updgrade to 7.0.5

6

I used t.datec but I change in record it is not changed.