topic Unable to make complex queries with .NET SDK in ArcGIS Pro SDK Questions

Unable to make complex queries with .NET SDK

AntoineKlein — Fri, 26 May 2023 08:16:23 GMT

Hello everyone !

I'm working on an ArcGIS Pro add-in and I need to make SQL queries using keywords "SELECT COUNT(field)", "GROUP BY" and "HAVING".
At the moment, I use 2 methods to execute queries :
- Geodatabase.Evaluate(QueryDef)
- FeatureLayer.Search(QueryFilter)
For QueryDef and QueryFilter we have to set a Subfields property to get the columns, but we can't use the COUNT keyword.
I also tried to add a "GROUP BY" in the PostfixClause property but it doesn't work either...

So I would like to know if it is possible to do that, and if yes, how, or if there is a workaround to do that

Thank you for your advices.

Re: Unable to make complex queries with .NET SDK

GKmieliauskas — Fri, 26 May 2023 13:47:49 GMT

Hi,

For count you can use method GetCount(QueryFilter) Method—ArcGIS Pro from table or featureclass.

For records grouping I would suggest you look at the GroupBy Property (TableStatisticsDescription)—ArcGIS Pro.

Re: Unable to make complex queries with .NET SDK

AntoineKlein — Fri, 26 May 2023 14:42:41 GMT

Thanks for your answer, can I use these methods together ?

I would like to execute a query like this :

SELECT count(node.idnode) AS nbr_elements, node.idnode FROM node GROUP BY node.idnode HAVING count(node.idnode) > 1;

I'll try it.

I had another idea to this, but I'm not sure either, I thought to use a database view instead of, but I don't know if it is possible to query a view from ArcGIS PRO, is it ?

Re: Unable to make complex queries with .NET SDK

RichRuh — Fri, 26 May 2023 15:42:45 GMT

Antoine,

I think you can do everything but the HAVING clause using the table statistics methods described here.

--Rich

Re: Unable to make complex queries with .NET SDK

AntoineKlein — Wed, 31 May 2023 08:05:56 GMT

Hi,

Thank you for your help, finally I used database view to do this, it will be easier in our project context, but I'll probably need this later.

Have a nice day !