Regarding the query layer parameter documentation:
There are SQL Server and PostgreSQL examples in the docs for view_extent and view_scale. Could Oracle examples be added too?
view_extent
- In SQL Server: WHERE shape.STWithin(geometry::STGeomFromText(::view_extent, 4326)) = 1
- In PostgreSQL: WHERE ST_Within(shape, ST_GeomFromText(::view_extent, 4326))
view_scale
- In SQL Server: WHERE IIF(::view_scale > 100000, <do this>, <do that>)
- In PostgreSQL: WHERE (CASE WHEN ::view_scale >= 100000 THEN <do this> WHEN ::view_scale >= 50000 AND ::view_scale < 100000 THEN <do that> ELSE <do the other thing> END)