Support Article
Error when running report with function alias
SA-17605
Summary
Report does not work correctly after migration from Postgresql to Oracle 11g while running a report with an SQL function alias for a column. Function alias is defined as below:
WHEN [1]!='' THEN {1}
ELSE 'Undefined'
All the records are displayed with value as 'Undefined' in the column which is not expected as per the data.
Error Messages
{$SAVE(ErrorMessage)}
Steps to Reproduce
1. Create a report.
2. Create an SQL function alias for a column in the report.
3. Run the report.
Root Cause
The function alias is not circumstanced based on Database.
Resolution
Circumstance the function alias as per Database.
We have Function Alias as below:
Go to Specialize by circumstance :
While doing so, create property as below and save the circumstance:
Circumstanced version will be visible as below:
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.