Issue in Report definition Function pxCaseWhenNULLInput
Hi Team, In Report definition I'm applying a function "pxCaseWhenNULLInput" as below and condition like-
When ABCProperty IS NULL then Return XYZProperty ELSE RETURN PQRProperty
When I click on Submit button then somehow When Condition is replaced with Else condition and when I click on function again the above condition looks like below: When PQRProperty IS NULL then Return XYZProperty ELSE RETURN PQRProperty Any idea on this behaviour? Note: I'm using Pega 8.7.1 version.
***Edited by Moderator Marije to change Type from Discussion to Question***
IQZ Systems LLC
US
Hi @SwapnilK4562,
"pxCaseWhenNULLInput" will validate When {1} is NULL, then Return {2} else return {1}, it accepts only 2 param for your logic you should use some thing like below.
[ pxCaseWhenNULLInput When .ABCProperty IS NULL then Return .XYZProperty ELSE RETURN [( pxCaseWhen When .ABCProperty is NOT NULL, then Return .PQRProperty else return NULL )]]
Hope it helps.
Pegasystems Inc.
IN
Hi @SwapnilK4562,
If you do not want to return null if XYZProperty or PQRProperty is null, Then you can create a custom function class in Embed-UserFunction class.
Configure the function alias as defined in the screen shot.
Use the created function alias in your report.
Pegasystems Inc.
IN
@Jananee Kalaichelvan I already did the same as a workaround, Also opened a ticket with Pegasystems support for this issue. If pxCaseWhenNULLInput function When {1} is NULL, then Return {2} else return {1}, it accepts only 2 param then in the UI it should'nt have 3 param due to which When Condition is replaced with Else condition. I will post once I get updates from Pegasystems support team.