script in formula in filter query

UserBird

Problème rencontré lors d'une requête sur un champ string (filtre pour conserver uniquement des dossiers 2017)

slice("sdoss_numdoss",2,4)=="2017"

ou

substring("sdoss_numdoss",2,4)=="2017" (ou substring("sdoss_numdoss",1,4)=="2017" )

message en-dessous : "Formula is valid"



(structure du champ sdoss_numdoss = P201704160494SIA)

résultats --> 0 observation

cperdigou

You don't need quotation marks around the column name.

Also, you should try without the boolean test to see what the substring outputs.

Anyway, substring(sdoss_numdoss, 1, 5)=="2017" should work.

thomas_dziedzic

i tested but it doesnt work

substring(sdoss_numdoss, 1, 5)=="2017"

and 0 result

cperdigou

Did you try without the boolean test? See what the substring outputs?

thomas_dziedzic

mistake , last dataset wasnt update and was empty...

substring(sdoss_numdoss, 1, 5)=="2017" works !

thank you