Select to view content in your preferred language

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

581
0
03-25-2023 11:10 AM
Status: Open
Labels (1)
Bud
by
Honored Contributor

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)