Error on executing report which uses WorkStatus Function alias
Error occurs on executing a report which uses the WorkStatus Function alias.
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
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.