topic Re: Linq Sort in ArcGIS API for Silverlight Questions

Linq Sort

JayKappy — Fri, 11 Mar 2011 20:15:17 GMT

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")))}

Re: Linq Sort

JayKappy — Mon, 14 Mar 2011 12:43:47 GMT

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

Re: Linq Sort

JenniferNery — Mon, 14 Mar 2011 15:56:52 GMT

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.

Re: Linq Sort

JayKappy — Mon, 14 Mar 2011 16:53:47 GMT

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...

Re: Linq Sort

JenniferNery — Mon, 14 Mar 2011 16:58:27 GMT

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

Re: Linq Sort

JayKappy — Mon, 14 Mar 2011 17:05:25 GMT

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?

Re: Linq Sort

JayKappy — Thu, 17 Mar 2011 18:51:20 GMT

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....

Re: Linq Sort

JenniferNery — Thu, 17 Mar 2011 19:47:56 GMT

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

Re: Linq Sort

JayKappy — Sun, 12 Dec 2021 03:56:01 GMT

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

Re: Linq Sort

JenniferNery — Fri, 18 Mar 2011 16:14:32 GMT

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?

Re: Linq Sort

JayKappy — Sun, 12 Dec 2021 16:44:39 GMT

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

Re: Linq Sort

JenniferNery — Sun, 12 Dec 2021 03:56:04 GMT

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.

Re: Linq Sort

JayKappy — Sun, 12 Dec 2021 16:44:41 GMT

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