topic Re: QueryFilter in ArcGIS PRO SDK in ArcGIS Pro SDK Questions

QueryFilter in ArcGIS PRO SDK

Anonymous User — Wed, 09 Mar 2022 12:36:21 GMT

Hi,

I'm connecting to FGDB and then firing the queryFilter in ArcGIS Pro SDK, which is where I'm having trouble because it's not going inside the while loop.

queryFilter which i'm using is:

-----------------------------------------------------------------------------------

QueryFilter routesQueryFilter = new QueryFilter();
routesQueryFilter.WhereClause = templateDesignerProperties.PipelineRouteID + "='" + selectedLineId + "'";

----------------------------------------------------------------------------

and the rowCursor:

----------------------------------------------------------------------------

QueuedTask.Run(() =>
{

using (RowCursor rowCursor = featureClassOpenedAsTableRoute.Search(queryFilter, false))
{
while (rowCursor.MoveNext())
{
//code here

}
}
});

-------------------------------------------------------------------------------------------

Could anyone please tell me the issue that is preventing it from entering the while loop?

Thanks in advance!!

Re: QueryFilter in ArcGIS PRO SDK

GKmieliauskas — Wed, 09 Mar 2022 13:54:08 GMT

Hi,

The answer could be: no records matching to your query filter. You can check it by adding code line before calling Search method.

var count = featureClassOpenedAsTableRoute.GetCount(queryFilter);

Count must be equal 0 in your case.

Re: QueryFilter in ArcGIS PRO SDK

Anonymous User — Wed, 09 Mar 2022 14:18:34 GMT

Hi @GKmieliauskas Yes you are right, but when I'm connecting it to SDE Database its pretty much happening but the problem is when I connect to FGDB , I also checked the whereClause the, value is coming but why the count is still 0 ??

Re: QueryFilter in ArcGIS PRO SDK

tempStephenRhea_NV5 — Wed, 09 Mar 2022 14:33:12 GMT

What data type is templateDesignerProperties.PipelineRouteID? If it's a number, it may be thrown off by the quotes around selectedLineId. If it's a GUID, you'll need to add braces around it by calling

selectedLineId.ToString("B", CultureInfo.CurrentCulture).ToUpper(CultureInfo.CurrentCulture);

Re: QueryFilter in ArcGIS PRO SDK

GKmieliauskas — Wed, 09 Mar 2022 14:41:44 GMT

Stop debugger before calling Search.

Copy routesQueryFilter.WhereClause value from Watch window to clipboard. Finish your tool work.

Open the featureClassOpenedAsTableRoute table in ArcGIS Pro table view and try Select by Attribute with whereclause string from clipboard. Check before that SQL query type is on.

If result still 0, try create query with query builder and check for differences

Re: QueryFilter in ArcGIS PRO SDK

Anonymous User — Thu, 10 Mar 2022 05:45:25 GMT

Thanks, the same way I debugged the code and then tried using the same whereClause in my ArcGIS Pro application, where I discovered a mistake in the query because the application was not retrieving any records. I fixed it, and now its working as expected 🙂

Thanks again!!