topic Re: GUID in queryfilter where clause in Data Management Questions

GUID in queryfilter where clause

RickCote — Tue, 21 Jun 2011 01:49:36 GMT

I'm sure that there's a simple answer to this but I'm missing it.

I want to query a feature class that has a column named PARENT_ID. The type is GUID.
My where clause is:

PARENT_ID = '6c1d6f56-b4d9-43ba-ac0a-038699229b6b'

I have records with this guid, but the featureClass.Search isn't returning features. Is there some trick to querying for a guid?

Thanks,
Rick

Re: GUID in queryfilter where clause

VinceAngelo — Tue, 21 Jun 2011 09:52:01 GMT

ArcSDE requires the left and right curly braces ('{6c1d6f56-b4d9-43ba-ac0a-038699229b6b}').
Without knowing what version of ArcGIS you're using, and what kind of data source, it's difficult
to give any other guidance.

- V

Re: GUID in queryfilter where clause

RickCote — Tue, 21 Jun 2011 13:05:03 GMT

I've also tried:

"PARENT_ID = '{9dba6278-347d-4148-9e38-f4681fc88c29}'

I'm using the ArcEngine v. 9.3.1, and the data source is a file geodatabase.

Thanks,
Rick

Re: GUID in queryfilter where clause

NickHarrison — Tue, 21 Jun 2011 14:37:36 GMT

Try this:

LOWER("SYNC_ID") = '{6e6bca4b-fd5c-4de0-a97e-52ae96a9dfe7}'

Re: GUID in queryfilter where clause

LanceShipman — Tue, 21 Jun 2011 16:31:56 GMT

"SYNC_ID" = UPPER('{6e6bca4b-fd5c-4de0-a97e-52ae96a9dfe7}')

Will also work. This will be faster as it can use the index. LOWER("SYNC_ID") can't use the index.