Page 1 of 1

Test on null value

Posted: Thu Sep 16, 2021 4:22 pm
by fabien
Hi,

we enable or disable panel with a condition on a null value.

Files attached :
- liste.mrt : report.
- data.json : data used to produce report.
- Line_type_1.png : expression to filter type 1.
- Line_type_2.png : expression to filter type 2.
- export.png : incorrect pdf export

lines with order 1, 3 and 4 should have "CASSOULET CREOLE AU COCO", "BOITE TRANSLUCIDE PP 37,5CL /500" and "ARABIS caucasica" captions. This the expression in Line_type_1.png who contains artgrilleval_lib1 == null
lines whith order 5 should have "ENSEIGNE DE TROTTOIR DIBOND SUR PIED RES" caption. This the expression in Line_type_2.png who contains artgrilleval_lib1 != null

I think expression are incorrect but i don't understand where is my error.
I've unchecked "Convert nulls" on report component.

Thanks,

Fabien

Re: Test on null value

Posted: Mon Sep 20, 2021 7:58 am
by Lech Kulikowski
Hello,

Your column is a string, please check the following expressions:
{lignepiece.lignepiece_lib == ""}

Thank you.

Re: Test on null value

Posted: Mon Sep 20, 2021 4:10 pm
by fabien
Hi,

It works.
it is important to know that the test should be done with double quotes and not single quotes.

Thanks,

Fabien.

Re: Test on null value

Posted: Mon Sep 20, 2021 9:19 pm
by Lech Kulikowski
Hello,

You are welcome.

Re: Test on null value

Posted: Thu Mar 07, 2024 7:39 am
by annakena
Hi rice purity test
It seems to be a technical issue related to enabling or disabling a panel based on a condition involving null values. The user is experiencing trouble with expressions in Line_type_1.png and Line_type_2.png but is unsure where the error lies, despite unchecking "Convert nulls" on the report component.