Report definition - return null value
Here, When the case status= Resolved-Completed, this Vehicle Current Value should be Null. How I do this one ?
Please provide your valuable input
Virtusa
IN
@KasunS98 Hello
You can apply the function on 'Vehicle Current Value' column as below
![[IMAGE]](/sites/default/files/collaboration/inline-images/Capture_64.JPG)
Note: This will not update your case data, If you want to update your case data as well, then you need to nullify it before resolving the case in post actions.
Updated: 5 Jun 2023 23:59 EDT
Virtusa
IN
@KasunS98 First you need to create the function alias can be named as CaseWhenEqual with pattern template like 'When {1} equals {2} return {3} else return {4}' and with below source code. Then you can use this function in report definition.
CASE WHEN {1} = {2}
THEN {3}
ELSE {4}
END
Please refer the links suggested by Bhavani Sagireddy on how to create function alias.
Virtusa PVT Ltd
LK
@RameshBattini Yes, it's working properly. but the thing is when we add this function inside the report definition. our main column also delete from my section. So, any idea why it's working like this ?
Infosys Private Limited
IN
Hi @KasunS98
Using the "function alias" in the report definition, we can fulfil this requirement.