Hi , i have a table transformer code written like below. The highlighted code check if the date is blanks does not work. could you please let me know how exactly to check for this please? It always executes the else statement and returns T1.'End date'
5th column in the below table is T1.'End date'.
Last column is the 'Story max date' that i am trying to return.
thanks
Nagarajan.
case when T1.'End date' ="" then "Nov 30, 2025"
when (((select max(T2.'End date') from T2 where T2.'Epic Link'=T1.'Epic Name' and T2.'End date'!="" and upper(T2.'Status') in ("NEW","IN ANALYSIS","IN PROGRESS","IN REVIEW","READY","BLOCKED") group by T2.'Epic Link' ) !=NULL)
and ((select max(T2.'End date') from T2 where T2.'Epic Link'=T1.'Epic Name' and T2.'End date'!="" and upper(T2.'Status') in ("NEW","IN ANALYSIS","IN PROGRESS","IN REVIEW","READY","BLOCKED") group by T2.'Epic Link' ) !="") )
then (select max(T2.'End date') from T2 where T2.'Epic Link'=T1.'Epic Name' and T2.'End date'!="" and upper(T2.'Status') in ("NEW","IN ANALYSIS","IN PROGRESS","IN REVIEW","READY","BLOCKED") group by T2.'Epic Link' )
else T1.'End date'
end as 'Story max date'
SNo | Division | Epic | Epic name | Epic end date | Epic status | Story max date |
94 | X-Divisional | X-Divisional P&C & SB Data Analytics ICTO-24278 Financial Messaging and Sanction Filtering Data Mart | ICTO-24278 | Nov 30, 2025 | IN PROGRESS | Nov 30, 2025 |
46 | NCL | NCL Securities Settlements (APAC) ICTO-12571 POETS-CLEARANCE | ICTO-12571 | Dec 31, 2025 | IN ANALYSIS | Dec 31, 2025 |
15 | GWM | GWM Bahamas ICTO-28181 Treasury Suite | ICTO-28181 | TO DO | ||
84 | X-Divisional | X-Divisional GCS ICTO-391 ELAR - ELARBAS CH | ICTO-391 | TO DO | ||
85 | X-Divisional | X-Divisional GCS ICTO-4269 Regulatory Compliant Records Repository - RCR Americas | ICTO-4269 | TO DO |
Instead of using != use IS NOT NULL. You are also switching between "" and NULL, should be able to just use NULL.
From:
https://www.w3schools.com/sql/sql_null_values.asp
It is not possible to test for NULL values with comparison operators, such as =, <, or <>.
We will have to use the IS NULL
and IS NOT NULL
operators instead.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.