You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When I use a parameter to filter columns dynamically, the query executes correctly, and the database returns what I expected.
SELECT ST_AsBinary(geometry) AS geometry, id, collection_id, $1
FROM table_features WHERE geometry && ST_MakeEnvelope(-63.7,-31.61,-63.72,-31.57,4326)
AND collection_id = $2 with args [elevation my_uuid_collection_id]
My params config:
[[maps.params]]
name = "param"
token = "!param!"
type = "string"
sql = ",?"
[[providers.layers]]
name = "table_features"
geometry_fieldname = "geometry"
geometry_type="GeometryCollection"
id_fieldname = "id"
sql = """SELECT ST_AsBinary(geometry) AS geometry, id, collection_id !param!
FROM table_features WHERE geometry && !BBOX! !COL!"""
When I used a parameter (for example !param!) in the query selct in the response I got something similar to this:
?column?:"elevation"
However, when I detail the column directly, the select is executed in the same way but I correctly obtain something similar to this:
[[providers.layers]]
name = "table_features"
geometry_fieldname = "geometry"
geometry_type="GeometryCollection"
id_fieldname = "id"
sql = """SELECT ST_AsBinary(geometry) AS geometry, id, collection_id, elevation
FROM table_features WHERE geometry && !BBOX! !COL!"""
elevation: value
The text was updated successfully, but these errors were encountered:
When I use a parameter to filter columns dynamically, the query executes correctly, and the database returns what I expected.
My params config:
When I used a parameter (for example !param!) in the query selct in the response I got something similar to this:
?column?:"elevation"
However, when I detail the column directly, the select is executed in the same way but I correctly obtain something similar to this:
elevation: value
The text was updated successfully, but these errors were encountered: