Clarify the docs: Advanced SQL syntax is supported in FGDB views and expression subqueries

Bud — Wed, 21 Dec 2022 20:28:48 GMT

It looks like we can use advanced SQL syntax such as GROUP BY and HAVING in FGDB views and FGDB expression subqueries.

For example, I can create a FGDB view like this:

select
    text_a
from
    table_a
group by
    text_a
having 
    1=1
--I can use JOIN in FGDB views too.

And I can create an FGDB SQL expression subquery like this:

id_a in (select id_b from table_b group by id_b having 1=1)

I'm aware that the above example queries are fake/not terribly useful. They're just meant to demonstrate that the SQL syntax is valid.

Idea:

As far as I can tell, the docs don't mention that the above syntax is valid in FGDB views and subquery expressions. Could the docs be improved?

I'm aware of the SQL syntax mentioned in this page: SQL for reporting and analysis on file geodatabases. But if I understand correctly, the syntax on that page pertains specifically to the .NET API/ArcObjects, not SQL syntax for FGDB views or expressions.

idea Clarify the docs: Advanced SQL syntax is supported in FGDB views and expression subqueries in ArcGIS Pro Ideas

Clarify the docs: Advanced SQL syntax is supported in FGDB views and expression subqueries