Support Article
Error on executing report which uses WorkStatus Function alias
SA-56029
Summary
Error occurs on executing a report which uses the WorkStatus Function alias.
Error Messages
An error occured on executing the query for the report definition - There was a problem getting a list: code: 209 SQLState: S0001 Message: Ambiguous column name 'pxCreateDatetime'. DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: Ambiguous column name 'pxCreateDatetime'. | SQL Code: 209 | SQL State: S0001
Steps to Reproduce
- Create a report in the Work class and join it with Operator table
- Include WorkStatus function logic to calculate the case age
- Run the case
Root Cause
No prefix was added for the properties referred in the Function alias. The WorkStatus Function alias has a hardcoded property instead of a parameter reference.
Resolution
Apply HFix-43215.
Published July 23, 2018 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.