nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

JerryBiedenbender

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

Find more posts tagged with

Accepted answers

All comments

JerryBiedenbender

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

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

JerryBiedenbender

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

pslgisAdmin

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.

JerryBiedenbender

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" />

JerryBiedenbender

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

JerryBiedenbender

Silverlight 2.2

DominiqueBroux

Strange.

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

JerryBiedenbender

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

JenniferNery

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

JerryBiedenbender

Modified to be blank2

JerryBiedenbender

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

JenniferNery

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();

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.