How do you set the Order By property of the Query Task?

Sean McClurkan

25 Maj 2016 15:28

Essentials 4.5.1 HTML5 2.6.1

 

Well, it's been over a year, but maybe someone will repsond this time.  My question from March 2015:

 

Does anyone know how to get a list of fields into the Order By argument of the Query Task activity?  ESRI documentation says it should be a string, but the workflow activity has it as a Generic.IList<OrderByField> object.  I can't find a syntax that will work.  It will not accept a string argument with a comma deimited list of columns.

 

Any help would be appreciated.

0

• 

  Tom Neer

  25 Maj 2016 18:49

  Sean, you want to use:

   

    New System.Collections.Generic.List(Of ESRI.ArcGIS.Client.Tasks.OrderByField)({ New ESRI.ArcGIS.Client.Tasks.OrderByField([INSERTCOLUMNNAME], ESRI.ArcGIS.Client.Tasks.SortOrder.Ascending) })

   

   

  0
• 

  Sean McClurkan

  25 Maj 2016 18:51

  Thanks, Tom.  My co-worker just spotted that, too!

  0
• 

  Permanently deleted user

  16 Juni 2016 18:42

  Do you know the proper syntax to use in the expression manager in Workflow Designer for the order by fields property of the query task? Nothing I enter is working. I want to have it sort in ascending order on the ID field.

   

  

   

   

  0
• 

  Nico Burgerhart

  16 Juni 2016 21:02

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

   

  Your ArcGIS Server should be 10.1 or higher.

  0
• 

  Permanently deleted user

  20 Juni 2016 16:08

  I assumed that was referring to the code in the xaml. Thanks Nico!  Worked perfectly. That's a good way to start a Monday :)

  0
• 

  Permanently deleted user

  04 April 2017 15:51

  what would be the syntax to order by two fields

  0
• 

  Kevin Penner

  04 April 2017 16:29

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

   

   

  0
• 

  Andrew Kan

  05 Januari 2022 17:13

  Hmm... this is not working for me. I'm able to sort by one field but not two. When I try the above to sort by two fields but I get an error - "Overload resolution failed because no accessible 'New' accepts this number of arguments".

   

  Thanks in advance.

  0
• 

  Nico Burgerhart

  05 Januari 2022 23:18

  There is a syntax error in the example of Kevin Penner.

  Try the following (Field en Field2 are the fieldnames)

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

   

  0
• 

  Andrew Kan

  05 Januari 2022 23:31

  Thanks Nico! Problems solved now. Cheers

  0

Du måste logga in om du vill lämna en kommentar.