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; } } }

Linq Sort

JayKappy

I have been trying to find an answer at Silverlight forums and LINQ forums but no luck....

I can sort by "officer" no problem....but I want to sort by the IncidentNumber field which is numberic...Cant seem to get it to sort...

I tried with no success:

Order By CStr(g.Attributes("IncidentNum")) Ascending
Order By CInt(g.Attributes("IncidentNum")) Ascending
Order By CDbl(g.Attributes("IncidentNum")) Ascending

Works for Officer:

Dim results2 = From g In featureSet
        Order By CStr(g.Attributes("Officer")) Ascending
        Group g By GroupKey = CStr(g.Attributes("Officer")) Into r = Group
        Select New With {Key .Officer = GroupKey, Key .IncidentNums = r.Sum(Function(i) Convert.ToInt32(i.Attributes("IncidentNum")))}

Does NOT work for IncidentNumber (Map Service Field Name = IncidentNum)

Dim results2 = From g In featureSet
        Order By CStr(g.Attributes("IncidentNum")) Ascending
        Group g By GroupKey = CStr(g.Attributes("Officer")) Into r = Group
        Select New With {Key .Officer = GroupKey, Key .IncidentNums = r.Sum(Function(i) Convert.ToInt32(i.Attributes("IncidentNum")))}

Find more posts tagged with

Accepted answers

All comments

JayKappy

first off once again I thank you with this issue....driving me nuts...I am trying my best which does nto seem to be enough....

problem is that alone g is undefined...I am defining g from the results of the query (featureset)

    Private Sub QueryTaskPolice_ExecuteCompletedListBox(ByVal sender As Object, ByVal args As ESRI.ArcGIS.Client.Tasks.QueryEventArgs)

        Dim featureSet As FeatureSet = args.FeatureSet
        Dim results2 = From g In featureSet
                Group g By GroupKey = DirectCast(g.Attributes("Officer"), String) Into r = Group
                Select New With {Key .Officer = GroupKey, Key .IncidentNums = r.Sum(Function(i) Convert.ToInt32(i.Attributes("IncidentNum")))}

If I do this, I get the error that g is undefined...

    Private Sub QueryTaskPolice_ExecuteCompletedListBox(ByVal sender As Object, ByVal args As ESRI.ArcGIS.Client.Tasks.QueryEventArgs)

        Dim featureSet As FeatureSet = args.FeatureSet

        Dim integerValue As Integer = Convert.ToInt32(g.Attributes("IncidentNum"))

I then tried..

        Dim integerValue As Integer = Convert.ToInt32(featureSet.Attributes("IncidentNum"))

.Error 1 'Attributes' is not a member of 'ESRI.ArcGIS.Client.Tasks.FeatureSet'.

Then tried this

        Dim results2 = From g In featureSet
        Dim integerValue As Integer = Convert.ToInt32(results2.Attributes("IncidentNum"))

Error 1 'Attributes' is not a member of 'System.Collections.Generic.IEnumerable(Of

uggggggggggggggggg

JenniferNery

Before you apply any sort, test that you can successfully perform the conversion.

Dim integerValue As Integer = Convert.ToInt32(g.Attributes("IncidentNum"))

If you can get the above code to work, I don't see why sorting against this value will not work.

JayKappy

The Field is an Integer.....

Tried using the actual Attribute field name "IncidentNum", NOTHING ..no sorting

        Dim results2 = From g In featureSet
                        Order By Convert.ToInt32(g.Attributes("IncidentNum")) Descending
                        Group g By GroupKey = DirectCast(g.Attributes("Officer"), String) Into r = Group
                        Select New With {Key .Officer = GroupKey, Key .IncidentNums = r.Sum(Function(i) Convert.ToInt32(i.Attributes("IncidentNum")))}

But then thinking...I am trying to sort the "Key .IncidentNums" being created by Sum, NOTHING ...no sortting...

        Dim results2 = From g In featureSet
                        Order By Convert.ToInt32(g.Attributes("IncidentNums")) Descending
                        Group g By GroupKey = DirectCast(g.Attributes("Officer"), String) Into r = Group
                        Select New With {Key .Officer = GroupKey, Key .IncidentNums = r.Sum(Function(i) Convert.ToInt32(i.Attributes("IncidentNum")))}

Also...but getting errors

Order By Convert.ToInt32(g.Attributes("IncidentNum"), Integer) Descending
Order By Convert.ToInt32(g.Attributes("IncidentNum"), Double) Descending

Order By Convert.ToInt32(g.Attributes("IncidentNums"), Integer) Descending
Order By Convert.ToInt32(g.Attributes("IncidentNums"), Double) Descending

JenniferNery

Dim results = From g In featureSet
Group g By GroupKey = CStr(g.Attributes("Incident")) Into r = Group
Select New With {Key .Incident = GroupKey, Key .IncidentNums = r.Sum(Function(i) Convert.ToInt32(i.Attributes("IncidentNum")))}

From your last post in the old thread the code above worked for you. Can't you just use Convert.ToInt32() then?

JayKappy

Yea but there was nothing in there about sorting
This is where I am having my problems...I can sort the text but not the integer...I have scoured the internet and cant find anything...I am unfamilar with TypeCast, DirectCast syntax in this instant...

VB example you posted

Dim results = From g In graphicCollection Group g By GroupKey = CStr(g.Attributes("Officer")) Into r = Group Select New With {Key .Officer = GroupKey, Key .Incidents = r.Sum(Function(i) Convert.ToInt32(i.Attributes("Incident")))}
For Each item In results
MessageBox.Show(String.Format("Officer {0} has {1}", item.Officer, item.Incidents))
Next item

This is my appempt at sorting...I assume that I should be grabbing the Actual Field Name (incidentNum) instead of the created attribute (IncidentNums with an s)

Dim results2 = From g In featureSet
        Order By CStr(g.Attributes("IncidentNum")) Ascending
        Group g By GroupKey = CStr(g.Attributes("Officer")) Into r = Group
        Select New With {Key .Officer = GroupKey, Key .IncidentNums = r.Sum(Function(i) Convert.ToInt32(i.Attributes("IncidentNum")))}

Variations tried

Order By CType(g.Attributes("IncidentNum"), Integer) Descending
Order By DirectCast(g.Attributes("IncidentNum"), Integer) Descending
Order By TryCast(g.Attributes("IncidentNum"), String) Descending

JenniferNery

Did you use the attached VB solution that is equivalent to the C# code I posted in your old forum?

JayKappy

Again not sure by what you mean You need to apply type cast on the attribute value from object
I have looked this up for examples and as you can see above this is all I am really coming up with...Not really following here....I have been all over the interenet here tryign to figure this out....

JayKappy

Didnt really want to post there...as the post was to get the LINQ query working....it was working...
Dindnt want to get lost in 5 issues in the same forum...

I was thinking soemthing like this? But no go....

Order By CType(g.Attributes("IncidentNum"), Integer) Descending

AND

Order By DirectCast(g.Attributes("IncidentNum"), Integer) Descending

AND

Order By TryCast(g.Attributes("IncidentNum"), String) Descending

Right Path?

JenniferNery

This was your old thread: http://forums.arcgis.com/threads/23447-Query-BrainStorm

JayKappy

Is this still the same sample from your previous thread? I was able to sort using Linq in C#. You need to apply type cast on the attribute value from object, it should be int or double, whichever matches your field data type. If you cast it to string, then the sort will be 1, 12, 4, instead of 1, 4, 12.

Yea I was trying to find the old entry...I cant find it...I think it was in one that a bunc h of issues were dealt with....Still triyng to find it....Looking up Type Cast right now...

JenniferNery

Is this still the same sample from your previous thread? I was able to sort using Linq in C#. You need to apply type cast on the attribute value from object, it should be int or double, whichever matches your field data type. If you cast it to string, then the sort will be 1, 12, 4, instead of 1, 4, 12.

JayKappy

Anyoen any ideas....The field "IncidentNum" is numeric...I am Creating the "IncidentNums" (with an s) in the LINQ query...but wont sort on the IncidentNums, I can only get it to sort by the text field Officers....
uggggggggggggg

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.