STEPS TO REPRODUCE:
Note: Issue is only on a Postgres based system.
1. Create a query using the following (Administration -> Queries):
select 1 as col0, 10 as col1
select 2 as col0, 10 as col1
select 3 as col0, 20 as col1
select 4 as col0, 30 as col1
where @[email protected]
2. Click on "Attributes" tab. Click on "status_id"
3. Choose "Extended Data Type" = "Lookup - Numeric". Choose "Lookup" = "Status Report Status". Save.
4. Choose values under "Display Mapping" section. Save.
Expected Result: Display Mappings get saved.
The following error gets thrown.
"NPT-0120: There was an error while handling your request. Make sure your NSQL/SQL syntax is correct. Note that the : and @ delimiter characters used in expressions must be escaped with \."