# Sqlfilter proposal timestamps **URL:** \ **Category:** Developing for Dolibarr\ **Tags:** v18\ **Created:** [February 4, 2024, 12:22pm UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931 "2024-02-04T12:22:06Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\ **Post date:** [February 4, 2024, 12:22pm UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931/1 "2024-02-04T12:22:06Z")
Hi I want to look for a specific proposal when I have a timestamp from the automatic notification emails, In the email I have this field **NOW\_TMS** 1707039969 And when I look in the json for that proposal I can see that value several different places “date\_validation”: 1707039969, “date\_modification”: 1707039969, “datev”: 1707039969, The other date fields in the json are: “date\_creation”: 1707039934, “specimen”: 0, “socid”: “100”, “datec”: 1707039934, “date”: 1707001200, “datep”: 1707001200, “fin\_validite”: 1706953534, but I can not find all those in the database table or I can not use them in the sqlfilter | tms | timestamp | YES | | current\_timestamp() | on update current\_timestamp() | | datec | datetime | YES | | NULL | | | datep | date | YES | | NULL | | | fin\_validite | datetime | YES | | NULL | | | date\_valid | datetime | YES | | NULL | | | date\_signature | datetime | YES | | NULL | | | date\_cloture | datetime | YES | | NULL | | I’ve tried with these sqlfilters (t.datec:=:1707039934:) - which works but find nothing (t.date:=:1707001200:) - error Unknown column ‘t.date’ in ‘where clause’ (t.datep:=:1707001200:) - which also works, but doesn’t find anything (t.datev:=:1707039969:) - error Unknown column ‘t.datev’ in ‘where clause’ (t.tms:\<:1707001200:) - which works but doesn’t find anything Do I need to use non epoch time to get my data? MariaDB [dolidb]\> select rowid, tms, datec, datep, fin\_validite, date\_valid, date\_signature, date\_cloture from llx\_propal where rowid=432; ±------±--------------------±--------------------±-----------±--------------------±--------------------±---------------±-------------+ | rowid | tms | datec | datep | fin\_validite | date\_valid | date\_signature | date\_cloture | ±------±--------------------±--------------------±-----------±--------------------±--------------------±---------------±-------------+ | 432 | 2024-02-04 10:46:09 | 2024-02-04 10:45:34 | 2024-02-04 | 2024-02-03 10:45:34 | 2024-02-04 10:46:09 | NULL | NULL | ±------±--------------------±--------------------±-----------±--------------------±--------------------±---------------±-------------+ ---
**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\ **Post date:** [February 4, 2024, 12:37pm UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931/2 "2024-02-04T12:37:31Z")
> [@jonbendtsen](#): > > (t.tms:\<:1707001200:) these doesn’t find anything either ```auto (t.tms:like:%1707001200%:) (t.tms:like:%2024-02-04 10:46:09%:) (t.tms:like:%1707039969%:) ``` ---
**Author:** ![pcbleu](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/pcbleu/32/3120_2.png) [@pcbleu](https://www.dolibarr.org/forum/u/pcbleu)\ **Post date:** [February 25, 2024, 10:50am UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931/3 "2024-02-25T10:50:10Z")
Hello try this > SELECT \* FROM llx\_propal p where p.tms=“20170204104609”; Good continuation ---
**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\ **Post date:** [February 26, 2024, 5:47pm UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931/4 "2024-02-26T17:47:20Z")
doesn’t work “error”: { “code”: 400, “message”: “Bad Request: Error when validating parameter sqlfilters → Bad syntax of the search string” }, ---
**Author:** ![pcbleu](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/pcbleu/32/3120_2.png) [@pcbleu](https://www.dolibarr.org/forum/u/pcbleu)\ **Post date:** [March 13, 2024, 12:36pm UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931/5 "2024-03-13T12:36:49Z")
Hello can you try this > SELECT \* FROM llx\_propal p where p.tms=20170204104609; Good continuation ---
**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\ **Post date:** [March 13, 2024, 4:31pm UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931/6 "2024-03-13T16:31:28Z")
> [@pcbleu](#): > > > SELECT \* FROM llx\_propal p where p.tms=20170204104609; did not work { “error”: { “code”: 400, “message”: “Bad Request: Error when validating parameter sqlfilters → Bad syntax of the search string” }, “debug”: { “source”: “api\_proposals.class.php:210 at call stage”, “stages”: { “success”: [ “get”, “route”, “negotiate”, “authenticate”, “validate” ], “failure”: [ “call”, “message” ] } } } ---
**Author:** ![pcbleu](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/pcbleu/32/3120_2.png) [@pcbleu](https://www.dolibarr.org/forum/u/pcbleu)\ **Post date:** [March 14, 2024, 9:51am UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931/7 "2024-03-14T09:51:08Z")
Hello for the sqlfilters, can you try this ```auto t.tms='20170204104609' or t.tms=20170204104609 ``` ![image](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/2/25705768e797d8697ade1ba8efd22f3d2e9412c8.png) Good continuation ---
**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\ **Post date:** [March 14, 2024, 9:46pm UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931/8 "2024-03-14T21:46:22Z")
> [@pcbleu](#): > > `t.tms='20170204104609'` both suggestions gives the same error ![proposal_sqlfilter](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/b/b9077b456e2c003b5a1050ad716efa3983ba9a72.jpeg) ---
**Author:** ![pcbleu](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/pcbleu/32/3120_2.png) [@pcbleu](https://www.dolibarr.org/forum/u/pcbleu)\ **Post date:** [March 14, 2024, 10:10pm UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931/9 "2024-03-14T22:10:04Z")
Hello check the sortfield parameter ![image](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/f/ffc679a4be49880a08784ddb84afd10df82b1e10.png) Good continuation ---
**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\ **Post date:** [March 14, 2024, 11:05pm UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931/10 "2024-03-14T23:05:09Z")
> [@pcbleu](#): > > Hello > > check the sortfield parameter sorry, no change, still doesn’t work. I use 18.0.4 in tuxgasy container and my database is mariadb ---
**Author:** ![pcbleu](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/pcbleu/32/3120_2.png) [@pcbleu](https://www.dolibarr.org/forum/u/pcbleu)\ **Post date:** [March 15, 2024, 3:56pm UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931/11 "2024-03-15T15:56:48Z")
Hello for the sqlfilters, can you try this ```auto t.tms='2017-02-04 10:46:09' or t.tms=2017-02-04 10:46:09 ``` Good continuation ---
**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\ **Post date:** [March 15, 2024, 4:50pm UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931/12 "2024-03-15T16:50:39Z")
@pcbleu doesn’t work ---
**Author:** ![eldy](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/eldy/32/12_2.png) [@eldy](https://www.dolibarr.org/forum/u/eldy)\ **Post date:** [March 29, 2024, 8:39am UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931/13 "2024-03-29T08:39:32Z")
You must follow the syntax provided as example for sqlfilters Example: (t.tms:=:‘2020-12-12 10:00:00’) ---
**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\ **Post date:** [March 29, 2024, 9:12am UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931/14 "2024-03-29T09:12:34Z")
Where are API examples provided? And wouldn’t it be nice if the API explorer linked to those examples? ---
**Author:** ![eldy](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/eldy/32/12_2.png) [@eldy](https://www.dolibarr.org/forum/u/eldy)\ **Post date:** [March 29, 2024, 10:20am UTC](https://www.dolibarr.org/forum/t/sqlfilter-proposal-timestamps/24931/15 "2024-03-29T10:20:24Z")
I started a page on the wiki for accurate information: [Universal Search Filter Syntax - Dolibarr ERP CRM Wiki](https://wiki.dolibarr.org/index.php?title=Universal_Search_Filter_Syntax#Syntax_of_UFS)