Using NOT NULL clause in extrafields filter syntax

Developing for Dolibarr
1

Hi,
for an extra field I’m trying to set a filter in the list from table.

The following syntax works:

fichinter:description:rowid::(fk_statut:=:0)

But I would like to insert the IS NOT NULL clause but the corresponding syntax

fichinter:description:rowid::((fk_statut:=:0) AND (description IS NOT NULL))

gives me an error.
Which is the correct syntax?

Thanks

2

If you enable debug logging and look in the dolibarr.log file under the documents/ folder, does that give any clues?

3

Hi @mgribaudo

Have you tried this one?

fichinter:description:rowid::(fk_statut:=:0 AND !description)

Let me know if it works.

Thanks
Saikat Koley

4

Thanks @saikatkoley it works!
I am more and more convinced that you are a great resource in this environment :slightly_smiling_face:

1 Like
5

@mgribaudo I appreciate your kind words! And thanks for your appreciation!