This page (revision-6) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
6 26-Nov-2021 10:22 1 KB rforbes to previous
5 26-Nov-2021 10:22 1 KB rforbes to previous | to last
4 26-Nov-2021 10:22 1 KB rforbes to previous | to last
3 26-Nov-2021 10:22 1 KB JEscott to previous | to last COMPARISON_OF_NULL_VALUES ==> COMPARISON OF NULL VALUES
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last
1 26-Nov-2021 10:22 1 KB JMyers to last

Page References

Incoming links Outgoing links
COMPARISON OF NULL VALUES
COMPARISON OF NULL VALUES

Version management

Difference between version and

At line 3 changed one line
Any column that does not have a value is known as being "NULL or UNKNOWN" and whenever you compare anything to a Null value the result will always be else and a NULL is not equal to another NULL.
Any column that does not have a value is known as being "NULL or UNKNOWN" and whenever you compare anything to a [Null value|NULL] the result will always be else and a NULL is not equal to another NULL.
At line 7 changed one line
In the workflow WF_CAND_INFO there is a need to see if the stage has changed but if this is an insert or if the stage on the old record was not filled out a direct comparison of old value to new value would fail and thus process the Else. To work around this we create a variable called old_rst_id and use the operator EQNL to assign the old value (OV) of the Stage (ID) to the variable IF it is not null BUT if it is null than the value of 0 (zero) will be assigned to the old_rst_id variable.
In the workflow WF_CAND_INFO there is a need to see if the stage has changed but if this is an insert or if the stage on the old record was not filled out a direct comparison of old value to new value would fail and thus process the Else. To work around this we create a variable called old_rst_id and use the operator [EQNL|EQNL_OPERATOR] to assign the old value (OV) of the Stage (ID) to the variable IF it is not null BUT if it is null than the value of 0 (zero) will be assigned to the old_rst_id variable.
This page (revision-6) was last changed on 26-Nov-2021 10:22 by rforbesTop