Question
Infosys Ltd
CA
Last activity: 6 Jul 2022 15:39 EDT
Can we use Data Page in function alias.
Hi,
we have a single letter value on work Page and while displaying in section(case) we are displaying a label using a Data Page.
Eg.: Letter A in clipboard , then displaying America and Letter B in clipboard then Displaying Britain.
and now in report also my team expecting same, instead Clipboard value expecting the label as per the Data page already available.
Is there a way we can use function alias in Report definition to do.
Note: We can do Declare exp on case but inflight would be a problem, and On report displaying section we can do but do not want to modify pega ootb sections.
Empower Retirement
IN
Create a function alias and use that in the report (class should be Embed-UserFunction).
( CASE WHEN {1} IS NOT NULL THEN CASE WHEN {1} ='A' THEN 'America' WHEN {1} ='B' THEN 'Britain'
END END)
{1} is the input parameter say here the country name . if there are lots of countries then it will be difficult to maintain in the function.
IQZ Systems
US
@Phaneendra_Reddy Can you check if you can rely on the suggestion made in the post - https://support.pega.com/question/sql-function-alias-not-working ?