Filtering records with condition of $NULL$ with BMC remedy

Products

• ConnectAll On-Prem

Issue/Introduction

I want to do flow filter based on condition i.e. "('Assignee Group' = "XYZ") and ('Assignee' != $NULL$)". The same search condition filter in Remedy, But this condition cannot be used in ConnectAll.

How should this condition be written in ConnectAll? 

Environment

Component: BMC Remedy 

Release: 2.11.X, 3.X

Cause

Search condition unable to filter due to invalid configuration. The $NULL$  is BMC Remedy variable and not available/accessible within ConnectAll.

Resolution

As per the document BMC Remedy: Null Values in Relational Algebra for Relational algebra and qualifications involving NULL values, the condition should be something like below

 "('Assignee Group' = "XYZ") and ('Assignee' != NULL)"

Additional Information

Related Knowledge Documents

• In ConnectAll Java Heap size memory configurations setting to default values while upgrading from 2.11x to 3.x version