I have been trying to get this to work for a few days now with no success. I have a Data Rule that says IF ShipDtl_ShipCmpl = False or if ShipDtl_ShipCmpl = null. I know in this example that i can just say != true and it works, But other places where i would want to check null specifically don’t wor…

Change your operator… Try CONTAINS a value of null [image] Result: [image]

[image] dcamlin: act situatio Do you have any idea why Contains works here but elsewhere simply saying equals “nothing” works?

[image] BennyL: Do you have any idea why Contains works here but elsewhere simply saying equals “nothing” works? Was it a date field? maybe it was a string field instead and that is why and null string is nothing. Just a guess.

Null is not the same as empty. I can’t say I have a full grasp of the concepts, but an empty string (for example) is not the same as null. A string can be empty (" ") but that may just means it contains zero characters, or zero bytes of information. So, if you think about bytes of information, th…

Ya that makes sense, My problem was that i had successfully made an empty check against a String and have it work. [image] Which is why i am so confused with this one, as checking a string from a Baq request didn’t work. I am thinking that you are right, the BAQ returns “” while when checking a S…

Thank you, this worked for me today

Don’t use rules much. Isn’t it odd that you cannot do a proper null condition? The out of the box apps are full of them and DateField = null is the proper condition in the rules.json. Not what you get leaving value empty: DateField = '' nor what you get typing null without quotes: DateField = '…

Contains Null should work, i haven’t fought with app studio for over 2 years now, but the solution for testing if the value was equal to null was to do contains instead of equals. :man_shrugging:

That may work. For now. Still the problem remains, no apparent way to get field = null into rules.json like the epicor screens have. Proof perhaps that epicor developers don’t use AppStudio

Compare value to Null in a DataRule in App Studio

Kinetic ERP

dcamlin (David Camlin) July 16, 2024, 5:08pm 2

Change your operator… Try CONTAINS a value of null

Result:

Dashboard Properties - View Rule Issue

App Studio - data rules?

TransView and Kinetic Dashboard From Wizard

App Studio view rules on NullValue

Topic		Replies	Views
Dashboard Properties - View Rule Issue Kinetic ERP	4	423	August 19, 2024
Data Rule in Application Studio -- Check for null value? Kinetic ERP application-row-rule	2	85	April 13, 2026
How to evaluate if a date field is null? Kinetic ERP kinetic , application-studio	2	143	December 16, 2025
Dashboard View Rules not correctly translating to Kinetic Kinetic ERP dashboard , application-studio , data-rules , view-rule , data-rule	5	1757	March 13, 2023
Application Studio Data Rules Kinetic ERP	4	2922	March 1, 2023

Compare value to Null in a DataRule in App Studio

Related topics