Hi Team,

I have a requirement where am using a select query in Function Alias rule and calling it in a report definition.

Here am using class referencing to define the table name in the SQL query. But I see that this feature is not working for my query in Funciton Alias and throwing an error when I run the report definition, the same query is working fine in Connect-SQl rules. 

Query: SELECT CUSTOMERID FROM {CLASS:ABC-Data-Customer} WHERE DATE_MODIFIED >= *some date here* 

The error it gives when I run the report containing the Function Alias.

An error occured on executing the query for the report definition - There was a problem getting a list: code: 0 SQLState: 42601 Message: ERROR: syntax error at or near "{" Position: 152 DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: syntax error at or near "{" Position: 152 | SQL Code: 0 | SQL State: 42601

Could you please check and let me know of any corrections.

Thanks !