Everything About Nothing

Lava testing results:

If == Null == Empty == ''
Is Null
{% assign tNull = null %}
Variable Does Not Exist
{% if tDoesNotExist %}
Empty
{% assign tEmpty = '' %}
Has Value
{% assign tHasValue = 'Hello' %}
Attribute Does Not Exist
{% assign attributeNotExists = CurrentPerson | Attribute:'Nope' %}
Attribute Blank
{% assign attributeBlank = CurrentPerson | Attribute:'TestGroup' %}
Null Person Property
{% if CurrentPerson.RecordStatusReasonValueId %}
Empty Person Property
{% if CurrentPerson.MiddleName %}
Invalid Person Property
{% if CurrentPerson.Nope %}
Array With Two Items
2 Items
Array With No Items
0 Items
Dictionary With Items
1 Items
Empty Dictionary
0 Items
CurrentPerson is Null
null

Want to Learn More?

Watch the latest videos from Triumph.

No Business Logic in SQL

No Business Logic in SQL

Learn the benefits of removing business logic to simplify your SQL in Rock.

Tricks with Dates

Tricks with Dates

Unlock the full potential of date manipulation in SQL

SQL Order of Execution

SQL Order of Execution

Join us as we break down the step-by-step process of how SQL queries are processed by the database engine.

Let’s get to work

Ready to bring your Rock RMS ideas to life?

We’re here to help.

Contact Us