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
Booking Holdings
IN
Virtusa PVT Ltd
LK
@BATTINIRAMESH hey, what is this function name?
Updated: 5 Jun 2023 23:59 EDT
Booking Holdings
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}
ENDPlease refer the links suggested by Bhavani Sagireddy on how to create function alias.
Virtusa PVT Ltd
LK
@Ramesh Reddy Battini 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.
@KasunS98 Hello
You can apply the function on 'Vehicle Current Value' column as below
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.