topic Re: Automation Exception while using the order by clause with the query filter in ArcObjects SDK Questions

Automation Exception while using the order by clause with the query filter

pavan_kumarmuttigi — Tue, 11 Jun 2013 10:03:53 GMT

Hi,

Can any one please help me in resolving the issue with the query filter which I am getting when trying the query with order by clause.
BTW, I am working using the ArcObjects API for Java.

I am getting the following Automation Exception: Item Not Found in this Collection.

I am using the query to the queryfilter like as follows.

String query = ST_ID in (234,456) order by ST_ID asc

IQueryFilter queryFilter = new QueryFilter();
queryFilter.setWhereClause(query);

I am getting the above mentioned AutomationException.Can anyone please help me in resolving the issue?
Actually I do have a doubt like does the order by clause is supported in ArcObjects?

Thanks in Advance

Re: Automation Exception while using the order by clause with the query filter

nicogis — Sat, 11 Dec 2021 16:35:46 GMT

'Order by' you need use PostfixClause


IQueryFilter queryFilter = new QueryFilterClass();
queryFilter.SubFields = "NAME, ADDRESS";
queryFilter.WhereClause = "TYPE = 'Restaurant'";
IQueryFilterDefinition queryFilterDef = (IQueryFilterDefinition)queryFilter;
queryFilterDef.PostfixClause = "ORDER BY NAME";

Re: Automation Exception while using the order by clause with the query filter

pavan_kumarmuttigi — Wed, 12 Jun 2013 06:56:17 GMT

Hi Domenico Ciavarella,

I actually tried with code snippet you posted for the case of using order by clause for querfilter.
It didn't worked for me. I am getting the same automation exception as: Item not found in this collection. in 'DAO.Fields'.
I am wondering that is order by clause supported with file geodatabase?.Especially with ArcGIS 10.0 version.

Thanks in Advance.

Re: Automation Exception while using the order by clause with the query filter

NeilClemmons — Wed, 12 Jun 2013 13:58:48 GMT

The documentation for the PostfixClause property states that the property is not supported for file geodatabases.

Re: Automation Exception while using the order by clause with the query filter

pavan_kumarmuttigi — Thu, 13 Jun 2013 06:36:45 GMT

Hi Neil Clemmons,

Thank You for your information on postfix clause. Is there a way like to implement the order by clause in the file geodatabase approach.Please let me know.

Thanks in Advance.

Re: Automation Exception while using the order by clause with the query filter

NeilClemmons — Thu, 13 Jun 2013 12:04:53 GMT

Yes, use the ITableSort interface to get a cursor sorted on the field you specify.

Re: Automation Exception while using the order by clause with the query filter

pavan_kumarmuttigi — Thu, 13 Jun 2013 14:50:42 GMT

Hi Neil Clemmons,

Can you Please send me the snippet on how to use the ItableSort interface to get work the Order By clause over the File GeoDatabase approach?

Thanks in Advance.

Re: Automation Exception while using the order by clause with the query filter

NeilClemmons — Thu, 13 Jun 2013 14:52:33 GMT

It's in the developer help topic for the ITableSort interface. All you have to do is look it up.

Re: Automation Exception while using the order by clause with the query filter

pavan_kumarmuttigi — Mon, 17 Jun 2013 07:07:00 GMT

Hi Neil Clemmons,

Thanks for your help and support.

It helps me a lot 🙂

Thanks once again.