Connections

08/01/2014 at 8:25 am #299298

Keymaster

@ Marco

Since I now have access … I took a look at the page itself. The best I can tell it is working exactly as it should.

Without order_by, the sort is by name (last name if individual, org name if organization) in ascending order. A, B,C…

The problem you are facing sorting with the you seem to only have a name in the department field for two entries:

ORG:  Kunsthandel S. Mehringer OHG
DEPT: Beate

ORG:  Möller & Cie KG
DEPT: Andreas

ORG:  Galerie Thomas
DEPT: {empty}

ORG:  Gordian Weber Kunsthandel GmbH
DEPT: {empty}

ORG:  Galerie von Vertes
DEPT: {empty}

and so on …

Every other entry I (randomly) checked after that seems to have nothing entered in the department field so there would be nothing to sort by…

I would expect in ascending order the results to be {empty}, A, B. And in descending I would expect B, A, {empty}. Which seems to be exactly what you’re getting.

The empty fields, there nothing to sort by, so the result would be whatever the DB returns. So if you need to be sorted by owner using the department field, you’re going have to enter an owner for each org so it is properly sorted OR provide a secondary sort order for the results that are {empty} to be sorted by. Maybe this:

[connections enable_search='true' exclude_category='1,27,28,47,57' addr_format='%line1% %line2% %line3% %zipcode% %city% %state% %country%' order_by='department|SORT_DESC,sort_column|SORT_DESC']

Does this help?

Reply To: Oder by ascending does not work