topic Re: QueryFilter to match Guids in ArcGIS for Windows Mobile Questions

QueryFilter to match Guids

AndrewCorcoran — Tue, 11 Oct 2011 13:58:08 GMT

I'm having absolutely no luck trying to get FeatureDataRow or FeatureDataReader instances matched to a single record with a particular Guid. Anyone had any success with this?

Here is what I've tried with no success:

QueryFilter query = new QueryFilter("ID = " + guid);
QueryFilter query = new QueryFilter("ID = '" + guid.ToString() + "'");
QueryFilter query = new QueryFilter("ID = '{" + guid.ToString() + "}'");
QueryFilter query = new QueryFilter("ID = " + "'{" + guid.ToString() + "}'");

I've looped through the contents of my cache and it's definitely in there but I'd rather not have to loop through every time I want to get a single feature row.

Re: QueryFilter to match Guids

StevenSchuldt — Sat, 11 Dec 2021 11:01:12 GMT

I remember at some point I was running into issues with case sensitivity, although I don't recall if this was a mobile version issue, or a SQL issue, or a problem with my code. I know I wrote a function below, however apparently I didn't end up using it. I have filters like this in a lot of places in my code though:

string whereClause = String.Format("GlobalID = '{{{0}}}'", globalID.ToString().ToUpper());



  public static string GetGlobalIDWhereClause(string columnName, GlobalId globalID) {
   return String.Format("({0} = '{{{1}}}' OR {0} = '{{{2}}}')", columnName, globalID.ToString().ToUpper(), globalID.ToString());
  }

Re: QueryFilter to match Guids

AndrewCorcoran — Wed, 12 Oct 2011 06:52:52 GMT

Thank you very much 🙂 That worked a treat!