STEPS TO REPRODUCE:
Note: Issue is only on a Postgres based system.
1. Create a query using the following (Administration -> Queries):
select
@select:dim:user_def:implied:query130420:temp.col0:
[email protected],
@select:dim_prop:user_def:implied:query130420:temp.col1:
[email protected]from
(
select 1 as col0, 10 as col1
union
select 2 as col0, 10 as col1
union
select 3 as col0, 20 as col1
union
select 4 as col0, 30 as col1
)temp
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.
Actual Result:
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 \."