topic Re: Read table values from offline goedatabase in .NET Maps SDK Questions

Read table values from offline goedatabase

MoyerSolutions — Tue, 05 Dec 2023 23:07:25 GMT

Hello! This is a follow up to a previous question.

I am trying to read the values in a table. I guess their called attributes in this context. How do I enumerate the rows in the table and read the actual values of the fields?

Its an offline geodatabase, its is correctly download via the GeodatabaseSyncTask.GenerateGeodatabase()

Now I am trying to enumerate the values in the fields. The fields are loaded via table.LoadAsync(), and the field object contains the Field Name and other properties, but not the value.

I think I need ArcGISFeature.GetAttributeValue(field)? But how do I get the feature object from the table?

foreach (GeodatabaseFeatureTable table in geodatabase.GeodatabaseFeatureTables) { await table.LoadAsync(); string message = ""; foreach (Field field in table.Fields) { ArcGISFeature feature = ????? object value = feature.GetAttributeValue(field); message += "\n" + field.Name + ": " + value; } await Application.Current.MainPage.DisplayAlert(table.TableName, message, "OK"); }

Re: Read table values from offline goedatabase

AndyWeis — Wed, 06 Dec 2023 00:34:31 GMT

Hi @MoyerSolutions , a quick way to get the values you're looking for is as follows:

Add a call to `QueryFeaturesAsync` on the table in question with an empty `WhereClause` (this will grab every feature available)
Assign the result of this to a new `FeatureQueryResult` object.
Iterate through the fields in the table and each feature from this result. This will give you each feature in default order.

foreach (GeodatabaseFeatureTable table in geodatabase.GeodatabaseFeatureTables) { await table.LoadAsync(); string message = ""; QueryParameters queryParams = new QueryParameters() { WhereClause = "" }; FeatureQueryResult result = await table.QueryFeaturesAsync(queryParams); foreach (Field field in table.Fields) { foreach (ArcGISFeature feature in result) { object value = feature.GetAttributeValue(field); message += "\n" + field.Name + ": " + value; } await Application.Current.MainPage.DisplayAlert(table.TableName, message, "OK"); } }

Re: Read table values from offline goedatabase

MoyerSolutions — Wed, 06 Dec 2023 18:28:46 GMT

Aha! I was knew I was close... Thank you!