OrderByFields Case Sensitivity

Chris Roberts

October 01, 2019 00:17

Hi All

 

 

I have inherited a rather large and complex workflow from a retired colleague.  Part of the workflow has an expression that sorts a dropdown list of available species:

 

 

 New System.Collections.Generic.List(Of ESRI.ArcGIS.Client.Tasks.OrderByField)({ New ESRI.ArcGIS.Client.Tasks.OrderByField("SPECIES", ESRI.ArcGIS.Client.Tasks.SortOrder.Ascending) })

 

 

However it would seem that this list expression is case sensitive.  Upper case records are sorted first and are at the top of the list, and proper case records follow.

 

 

Is there a way to ignore case and sort regardless?

0

• 

  Berend Veldkamp

  October 01, 2019 13:01

  It would seem that you can use UPPER(SPECIES) for the fieldname. That would give you, in a slightly less verbose format:

   

   

  { New OrderByField ("UPPER(SPECIES)", SortOrder.Ascending) }

   

   

  You would typically use this in a Query Task, I don't really see how to do this for the QueryValueOutputField (which is a string, not a collection), are you sure it's used there?

  0

Please sign in to leave a comment.