Crow Canyon Software Forum

Crow Canyon User Community ForumNITRO Studio: Forms DesignerHow to use advanced condition - F …

Please or Register to create posts and topics.

How to use advanced condition - Fetch list items and empty column

#1 · January 28, 2025, 6:06 pm

I have a fetch list items which is returning two person fields. How do I check with advanced conditions if the BackupDivision feield is "Blank", Null?, Empty... I have tried numberous itterations with equals with no success.

$QL(CCSQLBureau##BackupDivision,,"")

$strlen($QL(CCSQLBureau##BackupDivision)),,0

$QL(CCSQLBureau##BackupDivision,,null)

#2 · January 30, 2025, 1:34 pm

Hi Archie

To check if the BackupDivision field is empty, Please try using the below syntax and let us know.

CCSQLBureau##BackupDivision,,

Example: Advanced condition - equals to - CCSQLBureau##BackupDivision,,