Query with Order By Field Online

This sample demonstrates performing a query, sorting the results based on a specified field, and adding the results to the map and a FeatureDataGrid. To use the sample, perform a search for an owner name in the upper right corner of the application.

In the sample's code-behind, a QueryTask is used to query a MontgomeryQuarters map service layer based on the name entered in the search box. The Query.OrderByFields property is set to an OrderByField object that specifies results should be sorted with SortOrder.Ascending based on the OWNER_NAME field. The features found are then added to a graphics layer and are displayed on the map and in the FeatureDataGrid.

XAML

<UserControl x:Class="ArcGISWPFSDK.OrderByFieldQuery"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    xmlns:esri="http://schemas.esri.com/arcgis/client/2009">
    <Grid x:Name="LayoutRoot" Background="White">
        <Grid.Resources>
            <esri:SimpleRenderer x:Key="SelectRenderer">
                <esri:SimpleRenderer.Symbol>
                    <esri:SimpleFillSymbol>
                        <esri:SimpleFillSymbol.ControlTemplate>
                            <ControlTemplate>
                                <Path x:Name="Element" Fill="Transparent" Stroke="Black" StrokeThickness="1.5"
							  Cursor="Hand">
                                    <VisualStateManager.VisualStateGroups>
                                        <VisualStateGroup x:Name="SelectionStates">
                                            <VisualState x:Name="Unselected" />
                                            <VisualState x:Name="Selected">
                                                <Storyboard>
                                                    <ColorAnimation Storyboard.TargetName="Element"
															Storyboard.TargetProperty="(Path.Fill).(SolidColorBrush.Color)" 
															To="Yellow" Duration="0:0:.25" />
                                                    <ColorAnimation Storyboard.TargetName="Element"
															Storyboard.TargetProperty="(Path.Stroke).(SolidColorBrush.Color)" 
															To="Cyan" Duration="0:0:.25" />
                                                    <DoubleAnimation Storyboard.TargetName="Element" 
															 Storyboard.TargetProperty="StrokeThickness"
															 To="3" Duration="00:00:.25" />
                                                </Storyboard>
                                            </VisualState>
                                        </VisualStateGroup>
                                    </VisualStateManager.VisualStateGroups>
                                </Path>
                            </ControlTemplate>
                        </esri:SimpleFillSymbol.ControlTemplate>
                    </esri:SimpleFillSymbol>
                </esri:SimpleRenderer.Symbol>
            </esri:SimpleRenderer>
        </Grid.Resources>
        <Grid.ColumnDefinitions>
            <ColumnDefinition />
            <ColumnDefinition Width="5" />
            <ColumnDefinition />
        </Grid.ColumnDefinitions>
        <esri:Map x:Name="MyMap" WrapAround="True" Grid.Column="0"
                  Background="WhiteSmoke" PropertyChanged="MyMap_PropertyChanged">
            <esri:ArcGISDynamicMapServiceLayer 
                    Url="http://sampleserver6.arcgisonline.com/arcgis/rest/services/MontgomeryQuarters/MapServer"/>
            <esri:GraphicsLayer ID="MontgomeryParcels" Renderer="{StaticResource SelectRenderer}" 
                           />
        </esri:Map>
        <GridSplitter Grid.Column="1" HorizontalAlignment="Stretch" />
        <Grid Margin="5" Grid.Column="2" Background="White" VerticalAlignment="Stretch">
            <Grid.RowDefinitions>
                <RowDefinition Height="40" />
                <RowDefinition />
            </Grid.RowDefinitions>
            <StackPanel Grid.Row="0" Margin="2" Orientation="Horizontal">
                <TextBox Name="SearchTextBox" Text="JOHN" VerticalAlignment="Center" Width="100"
                         HorizontalAlignment="Left" Margin="2,2,5,2" />
                <Button Content="Search by owner name" Click="Button_Click" 
                        Margin="2" VerticalAlignment="Center" HorizontalAlignment="Right" />
            </StackPanel>
            <ScrollViewer Grid.Row="1">
                <esri:FeatureDataGrid x:Name="MyDataGrid"
				Map="{Binding ElementName=MyMap}" 
				GraphicsLayer="{Binding ElementName=MyMap, Path=Layers.[MontgomeryParcels]}" />
            </ScrollViewer>
        </Grid>
    </Grid>
</UserControl>

C#

using System.Collections.Generic;
using System.Windows;
using System.Windows.Controls;
using ESRI.ArcGIS.Client;
using ESRI.ArcGIS.Client.Tasks;

namespace ArcGISWPFSDK
{
    public partial class OrderByFieldQuery : UserControl
    {
        GraphicsLayer parcelsGraphicsLayer;

        public OrderByFieldQuery()
        {
            InitializeComponent();

            parcelsGraphicsLayer = MyMap.Layers["MontgomeryParcels"] as GraphicsLayer;
        }

        private void MyMap_PropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e)
        {
            if (MyMap.SpatialReference != null)
            {
                MyMap.PropertyChanged -= MyMap_PropertyChanged;

                RunQuery();
            }
        }

        private void GraphicsLayer_MouseLeftButtonUp(object sender, GraphicMouseButtonEventArgs e)
        {
            (sender as GraphicsLayer).ClearSelection();
            e.Graphic.Select();
        }
            
        private void RunQuery()
        {
            parcelsGraphicsLayer.Graphics.Clear();

            ESRI.ArcGIS.Client.Tasks.Query query = new ESRI.ArcGIS.Client.Tasks.Query()
            {
                ReturnGeometry = true,
                OutSpatialReference = MyMap.SpatialReference,
                Where = string.Format("OWNER_NAME LIKE '%{0}%'", SearchTextBox.Text),
                OrderByFields = new List<OrderByField>() { new OrderByField("OWNER_NAME", SortOrder.Ascending) }
            };

            query.OutFields.Add("OWNER_NAME,PARCEL_ID,ZONING,DEED_DATE");

            QueryTask queryTask = new QueryTask("http://sampleserver6.arcgisonline.com/arcgis/rest/services/MontgomeryQuarters/MapServer/1");
            queryTask.ExecuteCompleted += (s, a) =>
            {
                foreach (Graphic g in a.FeatureSet.Features)
                    parcelsGraphicsLayer.Graphics.Add(g);
            };
            queryTask.ExecuteAsync(query);
        }

        private void Button_Click(object sender, RoutedEventArgs e)
        {
            RunQuery();
        }   

    }
}

VB.NET

Imports System.Collections.Generic
Imports System.Windows.Controls
Imports System.Windows
Imports ESRI.ArcGIS.Client.Tasks
Imports ESRI.ArcGIS.Client

Namespace ArcGISWPFSDK
    Partial Public Class OrderByFieldQuery
        Inherits UserControl
        Private parcelsGraphicsLayer As GraphicsLayer

        Public Sub New()
            InitializeComponent()
            parcelsGraphicsLayer = TryCast(MyMap.Layers("MontgomeryParcels"), GraphicsLayer)
        End Sub

        Private Sub MyMap_PropertyChanged(ByVal sender As Object, ByVal e As System.ComponentModel.PropertyChangedEventArgs)
            If Not MyMap.SpatialReference Is Nothing Then
                RemoveHandler MyMap.PropertyChanged, AddressOf MyMap_PropertyChanged

                RunQuery()
            End If
        End Sub

        Private Sub GraphicsLayer_MouseLeftButtonUp(ByVal sender As Object, ByVal e As GraphicMouseButtonEventArgs)
            TryCast(sender, GraphicsLayer).ClearSelection()
            e.Graphic.Select()
        End Sub

        Private Sub Button_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
            RunQuery()
        End Sub

        Private Sub RunQuery()
            parcelsGraphicsLayer.Graphics.Clear()

            Dim query As New ESRI.ArcGIS.Client.Tasks.Query() With
                {
                    .ReturnGeometry = True,
                    .OutSpatialReference = MyMap.SpatialReference,
                    .Where = String.Format("OWNER_NAME LIKE '%{0}%'", SearchTextBox.Text),
                    .OrderByFields = New List(Of OrderByField)() From {New OrderByField("OWNER_NAME", SortOrder.Ascending)}}

            query.OutFields.Add("OWNER_NAME,PARCEL_ID,ZONING,DEED_DATE")


            Dim queryTask As New QueryTask("http://sampleserver6.arcgisonline.com/arcgis/rest/services/MontgomeryQuarters/MapServer/1")
            AddHandler queryTask.ExecuteCompleted, Sub(s, a)
                                                       For Each g As Graphic In a.FeatureSet.Features
                                                           parcelsGraphicsLayer.Graphics.Add(g)
                                                       Next g
                                                   End Sub
            queryTask.ExecuteAsync(query)
        End Sub
    End Class
End Namespace