How to evaluate if a date field is null?

Kinetic ERP
,
1

I am working on building a dashboard in application studio that has a number of optional filters. I’ve accomplished this by setting some “is empty” field prior to calling a BAQ via rest. However, I’m having trouble with one of my date filters. How do I evaluate if a date field is null and return a boolean value before making a rest call?

2

You can put a condition widget in your event, prior to the rest call:

For example:
'{OrderHed.NeedByDate}' === null || '{OrderHed.NeedByDate}' === 'null'

I added the “or” statement because an initial value of null worked, but if I put in a date and then deleted it, which according to the dataview in debugger reset the value to null… it didn’t trigger my condition. But putting both options null & ‘null’ seemed to capture both.

2 Likes
3

Uhg! I think I forgot to put parenthesis around null. That fixed it.