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

SQL sort parameter syntax for da.cursors?

ChrisSnyder

Looking for examples of using the "ORDER_BY" SQL syntax that is now suported in the arcpy.da cursor model...

Help system is lacking in examples on this front...

Can any v10.1 pro rewrite this in arcpy.da format?

arcpy.UpdateCursor(oesfHydroDislvFC, "", "", "", "SL_WTRTY_CD A;RIP_COMBO_UID D")

Finde mehr Beiträge mit dem Tag

Accepted answers

ChrisFox3

Thanks Chris

I'm thinking the "fancy" SQL parameter is the 6th one down the line, so it probably should be something like this:

arcpy.da.UpdateCursor(oesfHydroDislvFC, fieldList, None, None, False, (None, 'ORDER_BY SL_WTRTY_CD, RIP_COMBO_UID DESC'))

But that is thowing an error:
Traceback (most recent call last):
File "<interactive input>", line 1, in <module>
TypeError: expected callable function - logger(obj)

Been trying a lot of things for a while - with nothing working out...

If you used a named parameter than you don't have to specify the value for every optional paramater to the function. This makes your code a lot easier to write and read and sometimes resolves errors that may have accidentally been added. So since you are just accepting the defaults for the 3rd 4th and 5th parameter you could change your code to:

arcpy.da.UpdateCursor(oesfHydroDislvFC, fieldList, sql_clause=(None, 'ORDER_BY SL_WTRTY_CD, RIP_COMBO_UID DESC'))

Also make sure the input is a Geodatasbase Feature Class, the sql_clause paramater does not work on shapefiles. I just tested this similar expression on my data and it worked as expected. If you remove the sql_clause paramater is the cursor created succesfully? Did you want to share a small subset of your data?

All comments

oscarespitia

give a look at this

http://forums.arcgis.com/threads/930...656#post330656

ChrisSnyder

I logged a new bug for this issue, NIM083765.

Appreciate that. Thanks Chris.

ChrisFox3

I logged a new bug for this issue, NIM083765.

ChrisSnyder

Okay - I get the 'named parameter' thing... .It's working now... Thanks Chris and Jason!

Correct sytax for a multiple field sort:

arcpy.da.UpdateCursor(oesfHydroDislvFC, fieldList, sql_clause=(None, 'ORDER BY SL_WTRTY_CD, RIP_COMBO_UID DESC'))

Note that the Help system indicates "ORDER_BY" but it is really "ORDER BY" (with no underscore).

VERIFIED:
arcpy.da.UpdateCursor(oesfHydroDislvFC, fieldList, None, None, False, (None,'ORDER BY SL_WTRTY_CD, RIP_COMBO_UID DESC'))

results in an error.... Not sure why...

ChrisFox3

Additional info, I get the same error as you if I attempt to enter all the parameters in the same order as specified in the function's signature.

>>> rows = arcpy.da.UpdateCursor("U.S. Cities", fields, None, None, False, (None, 'Order By STATE_NAME, TYPE DESC'))
Runtime error 
Traceback (most recent call last):
  File "<string>", line 1, in <module>
TypeError: expected callable function - logger(obj)

This seems to be a bug, I will look into this further. Using sql_clause= instead works.

>>> rows = arcpy.da.UpdateCursor("U.S. Cities", fields, None, None, False, sql_clause=(None, 'Order By STATE_NAME, TYPE DESC'))

ChrisFox3

Thanks Chris

I'm thinking the "fancy" SQL parameter is the 6th one down the line, so it probably should be something like this:

arcpy.da.UpdateCursor(oesfHydroDislvFC, fieldList, None, None, False, (None, 'ORDER_BY SL_WTRTY_CD, RIP_COMBO_UID DESC'))

But that is thowing an error:
Traceback (most recent call last):
File "<interactive input>", line 1, in <module>
TypeError: expected callable function - logger(obj)

Been trying a lot of things for a while - with nothing working out...

arcpy.da.UpdateCursor(oesfHydroDislvFC, fieldList, sql_clause=(None, 'ORDER_BY SL_WTRTY_CD, RIP_COMBO_UID DESC'))

ChrisSnyder

Thanks Chris

I'm thinking the "fancy" SQL parameter is the 6th one down the line, so it probably should be something like this:

arcpy.da.UpdateCursor(oesfHydroDislvFC, fieldList, None, None, False, (None, 'ORDER_BY SL_WTRTY_CD, RIP_COMBO_UID DESC'))

But that is thowing an error:
Traceback (most recent call last):
File "<interactive input>", line 1, in <module>
TypeError: expected callable function - logger(obj)

Been trying a lot of things for a while - with nothing working out...

ChrisFox3

it would be something like:

sqlClause = (None, "ORDER BY Field1 ASC, Field2 DESC")
arcpy.da.UpdateCursor(inFC, fields, sql_clause=sqlClause)

Make sure any fields you use in the sql expression are also passed in the field_names parameter.

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.