Oder by ascending does not work

Support has been upgraded!



The Support Forum is closed. Not to worry!  Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.

Premium Support

Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?

Please open a Support Ticket in your user account.

Click here to open a support ticket.

Free Support

Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.

Please open a new support topic in the WordPress support forums for Connections.

Click here to open a support topic.

This topic is: resolved

Tagged: , , , , , ,

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • 07/31/2014 at 11:18 am #299171
    Marco Eisenack
    Participant

    Hey there,

    I’m facing the problem that order_by with ASC does not work. Descending seems to work though.

    I’m using [connections order_by='department|SORT_DESC'] and everything works, but descending. order_by=”SORT_ASC” makes everything a mess.

    I’ve tried order_by="first_name|SORT_ASC" but that didn’t work either.

    Perhaps my full could gives any hint?

    [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']

    Thanks!

    07/31/2014 at 1:21 pm #299194
    Steven Zahm
    Keymaster

    @ Marco

    I just tested and the query that is built is correct and so are the results I would expect. Could you define what you mean by “a mess”? Can you share a link of the page that shows the issue? If you can’t, can you attached a screenshot showing the first full page of results and then list the order you expect the results to be in?

    08/01/2014 at 5:28 am #299292
    Marco Eisenack
    Participant

    Hey,

    I attached screenshots:

    – Department Descending: I added the names in the Department field and turned them off in the cMap template. This works fine but is not the way I need it.

    – Department Ascending: this looks messy, there seems not be any given order (?)

    – Without order_by: the cards are ordered by name, but unfortunately I need them to be ordered by the names of the owner.

    I hope this helps a bit?

    Attachments:
    You must be logged in to view attached files.
    08/01/2014 at 8:25 am #299298
    Steven Zahm
    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?

    08/04/2014 at 6:43 am #299476
    Marco Eisenack
    Participant

    @Steve

    Thank you for taking a look!

    I did not know that ascending would leave to {empty}, A, B, …, I just wanted to test it with two entries.

    I will enter all the other information and try it again, I think that should work!

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)

You cannot reply to this support topic. Please open your own support topic.