Negative conditions in Business rules don't work with null values
search cancel

Negative conditions in Business rules don't work with null values

book

Article ID: 264663

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

You are creating a negative business rule (ex- Location ≠ Chicago).  When using this rule and the field is null, it does not work correctly.  If the value for the field is null, then it does not match the rule so the rule should be in effect.

Steps to Reproduce: 

  1. In MUX, go to Administration>>Blueprints
  2. Copy and rename the Standard Project blueprint
  3. Open blueprint and click Edit
  4. Click on Rules
  5. Create a new rule
    • Target Object=Project
    • Rule Type=View Page
    • Filters=Location≠Chicago
    • Actions=Hide Sections
    • Select = Settings
  6. Save
  7. Go to Projects Workspace
  8. Using the Column flyout, add Location and blueprint to the grid view
  9. Add a new Project with the required information and Location as Chicago and the blueprint you just created
  10. Open Project and go to properties page
  11. Note the Settings section is there
  12. Go back to grid view and remove Location so that it is blank
  13. Open Project Properties page

Expected Results: Since Location does not equal Chicago, Settings should not be visible

Actual Results: Settings section is visible

Environment

Release : 16.0.3, 16.1.1

Cause

DE69609

Resolution

Resolved in 16.1.3

Workaround - 

Add one more rule for Is Empty.

I.E-

Rule #1 : Is Not Equal to Chicago / Hide Module 

Rule #2 : Is Empty / Hide Module