Query layer parameter docs — Provide Oracle SQL examples for view_extent and view_scale

Bud — Fri, 14 Jun 2024 19:44:47 GMT

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)

idea Query layer parameter docs — Provide Oracle SQL examples for view_extent and view_scale in ArcGIS Pro Ideas

Query layer parameter docs — Provide Oracle SQL examples for view_extent and view_scale

view_extent

view_scale