topic Re: Editor Widget (how do I limit records in the data grid?) in ArcGIS API for Silverlight Questions

Editor Widget (how do I limit records in the data grid?)

JerryBiedenbender — Wed, 16 Nov 2011 16:41:14 GMT

I was wondering if there was a way to limit the records that show up in the data grid. Right now everything in the layer shows up in the grid. Is it possible to not show a record in the grid that has a status as "complete" in one of the fields. Or only populate the data grid by a date range, (only records that have a date no older than a week or something?)

Thanks,
Jerry

Re: Editor Widget (how do I limit records in the data grid?)

JenniferNery — Sun, 12 Dec 2021 02:13:28 GMT

Are you using FeatureDataGrid? http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#FeatureDataGrid. If yes, you can set FilterSource property with Linq query.

 MyDataGrid.FilterSouce = (from g in l.Graphics
      where g.Attributes.ContainsKey("status") && (string)g.Attributes["status"] == "completed"
      select g).ToList();

Re: Editor Widget (how do I limit records in the data grid?)

JerryBiedenbender — Fri, 18 Nov 2011 15:48:28 GMT

Is this where I'm suppose to add the code?

private void FeatureLayer_MouseLeftButtonUp(object sender, GraphicMouseButtonEventArgs args)
{
FeatureLayer featureLayer = sender as FeatureLayer;
args.Graphic.Select();

args.Graphic.Selected = !args.Graphic.Selected;
if (args.Graphic.Selected)
MyDataGrid.ScrollIntoView(args.Graphic, null);

MyDataGrid. FilterSouce = (from g in l.Graphics
where g.Attributes.ContainsKey("status") && (string)g.Attributes["status"] == "completed"
select g).ToList();

}

When I add it here I get two errors....

1. 'ESRI.ArcGIS.Client.Toolkit.FeatureDataGrid' does not contain a definition for 'FilterSouce' and no extension method 'FilterSouce' accepting a first argument of type 'ESRI.ArcGIS.Client.Toolkit.FeatureDataGrid' could be found (are you missing a using directive or an assembly reference?)

2. The name 'l' does not exist in the current context

Re: Editor Widget (how do I limit records in the data grid?)

JerryBiedenbender — Fri, 18 Nov 2011 15:49:15 GMT

Modified to be blank2

Re: Editor Widget (how do I limit records in the data grid?)

JenniferNery — Sat, 19 Nov 2011 18:27:01 GMT

http://help.arcgis.com/en/webapi/silverlight/apiref/ESRI.ArcGIS.Client.Toolkit~ESRI.ArcGIS.Client.Toolkit.FeatureDataGrid~FilterSource.html

Where you place the code-snippet is really an application logic. Maybe on a button-click? Whenever you want the filter to be applied to your current FeatureDataGrid.Items. "l" is the FeatureLayer, assuming you have already set this variable. (i.e. var l = MyMap.Layers["MyFeatureLayerId"] as FeatureLayer, or var l = MyDataGrid.GraphicsLayer). Also make sure you have "using System.Linq". The code-snippet also assumes FeatureLayer.OutFields include "status" and your service field type defined this as string where "completed" could be a possible value. You can read up on how to use linq queries here: http://code.msdn.microsoft.com/101-LINQ-Samples-3fb9811b

Re: Editor Widget (how do I limit records in the data grid?)

JerryBiedenbender — Sun, 12 Dec 2021 02:13:31 GMT

I almost have this figured out, Just one last hang up.

private void FeatureLayer_MouseLeftButtonUp(object sender, GraphicMouseButtonEventArgs args)
        {
            FeatureLayer featureLayer = sender as FeatureLayer;
            args.Graphic.Select();


            var l = MyMap.Layers["Dispatch"] as FeatureLayer;

            args.Graphic.Selected = !args.Graphic.Selected;
            if (args.Graphic.Selected)
                MyDataGrid.ScrollIntoView(args.Graphic, null);

            MyDataGrid.FilterSouce = (from g in l.Graphics
                                      where g.Attributes.ContainsKey("status") && (string)g.Attributes["status"] == "completed"
                                      select g).ToList();
   


        }

I am getting an error on this piece of code... See below

'ESRI.ArcGIS.Client.Toolkit.FeatureDataGrid' does not contain a definition for 'FilterSouce' and no extension method 'FilterSouce' accepting a first argument of type 'ESRI.ArcGIS.Client.Toolkit.FeatureDataGrid' could be found (are you missing a using directive or an assembly reference?)

Is there a specific reference that I need to add?

Thanks,
Jerry

Re: Editor Widget (how do I limit records in the data grid?)

DominiqueBroux — Thu, 01 Dec 2011 06:58:00 GMT

Strange.

Which SL API version are you using? (FilterSource is there for a while, but...)

Re: Editor Widget (how do I limit records in the data grid?)

JerryBiedenbender — Thu, 01 Dec 2011 10:20:16 GMT

Silverlight 2.2

Re: Editor Widget (how do I limit records in the data grid?)

JerryBiedenbender — Wed, 07 Dec 2011 15:58:42 GMT

I was able to get the (FilterSource) to stop having an error. After reading back into this post I realized we are putting this on a button click. I really would rather it just happen and not be on a button click. I just want the grid to show every record that does not have a status of "complete"

Thanks,
Jerry

Re: Editor Widget (how do I limit records in the data grid?)

JerryBiedenbender — Wed, 07 Dec 2011 17:57:34 GMT

Is it possible for me to add a filter source code on my MainPage.xaml to exclude the grid results that have the status of complete? Below is where I think it would be added but im not sure how to write it.

<esri:FeatureDataGrid Grid.Row="2" x:Name="MyDataGrid"
                              HorizontalAlignment="Stretch"
                              VerticalAlignment="Stretch"
                              Map="{Binding ElementName=MyMap}"
                              GraphicsLayer="{Binding ElementName=MyMap, Path=Layers.[Dispatch]}"
                              Width="Auto" />

Re: Editor Widget (how do I limit records in the data grid?)

MichaelKohler — Thu, 08 Dec 2011 12:42:21 GMT

If all you want to see are the features that are not completed, set the Where clause in the XAML definition of your FeatureLayer....

<esri:FeatureLayer ID="Dispatch" Where="status <> complete"/>

Something like that will "filter" your data. You could also do this in code behind somewhere.

Re: Editor Widget (how do I limit records in the data grid?)

JerryBiedenbender — Fri, 09 Dec 2011 14:07:28 GMT

This seems like what I'm looking for but the code is not quite working. I get an error message when I use the (<>) code. If I take that out and try something else the feature layer does not display anything. Is there another way of writing the code?

Jerry

Re: Editor Widget (how do I limit records in the data grid?)

JerryBiedenbender — Sun, 12 Dec 2021 02:13:33 GMT

I figured it out. I ended up using...

FeatureLayer siteLayer = MyMap.Layers["Dispatch"] as FeatureLayer;
            siteLayer.Where = "Status <> '4'";
            siteLayer.Update();