How do you specify a null on the button condition "Expression used To Enable Button" see screen shot.docx. As in "{STATUS} == null"
Announcement
Collapse
No announcement yet.
specifying null when adding a button
Collapse
X
-
I believe a null value would come through to the front-end as an empty string (''), so you wouldn't be able to distinguish between an empty/blank value and a null value. If your file can have both null values AND empty/blank values in that field, then I'd suggest you adjust your data source to handle nulls explicitly -- for instance, you could use coalesce to return a string value of *NULL whenever the field is set to null:
select FREQUENCY, coalesce(STATUS,'*NULL') as STATUS from XXXX...Last edited by robert.swanson; 12-21-2022, 02:00 PM.
Comment