How to group a field in *.geodatabase using `AGSQuery`?

MuruganandhamKuppan1 — Wed, 06 Mar 2019 13:36:12 GMT

I would to like to group a field from `geodatabase`. The desired query is,

SELECT PINCODE
FROM <table-name>
GROUP BY PINCODE;

How to create a `AGSQuery` object focusing above SQL Query?

I'm using ArcGIS runtime SDK 10.2.5.

This guide helped me explore more. The expected result should be like,

PINCODE: [
10002,
10004,
10007,
...
10022
]

But, I got as follows,

{
PINCODE = 10002;
"PINCODE_COUNT" = 147;
},
{
PINCODE = 10004;
"PINCODE_COUNT" = 198;
},
{
PINCODE =10007;
"PINCODE_COUNT" = 71;
},
...
}

The PINCODE 10002 has been holding by 147 records in the database.

Re: How to group a field in *.geodatabase using `AGSQuery`?

NimeshJarecha — Wed, 06 Mar 2019 22:59:58 GMT

Can you please post your code here?

Regards,

Nimesh