using order by

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 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • 03/12/2015 at 7:14 pm #322631
    Myles Kelly
    Participant

    Hi Steve,
    have so far had no trouble getting everything to work, but am trying to put a bit of order in “homemade” results pages. At the moment the results for a page on which results are pulled from a certain state could be made more useful if they were ordered by the city. So I tried this:

    [connections state='X' order_by='city|SORT_ACS' image_width=225 image=siteshot enable_category_select='false' enable_search='false']

    But it does not seem to make any difference to how the results are displayed.
    Can you help, please?
    Cheers,
    Myles

    03/13/2015 at 11:54 am #322706
    Steven Zahm
    Keymaster

    @ Myles

    The shortcode seems to be in order… can you share link to the directory page so I can take a look? I’ll also need to install Query Monitor so I can see the queries be created and run for that I’ll need an admin account. PLease send the login details using the contact link at the bottom of the screen. PLease paste a link of this forum thread in the message so I can relate the two. Thanks!

    03/13/2015 at 6:11 pm #322774
    Steven Zahm
    Keymaster

    @ Myles

    Looks like it working fine… it is the data that’s the issue… I’ll try to explain…

    Many of the entries seems to have two addresses, the latter of the two containing only the state while the first has not state.

    First, when you have multiple address per entry, things can appear to be really weird because which of the two addresses should be used when doing the ordering … it pretty random but more often of not, it be the second.

    The second address contains only the state and an empty city. The “empties” will become before the “none-empties” when sorting ASC.

    Now, not all the entries have two address… the second page on this page on your site:

    http://pescareinirlanda.info/tackle-shops/pg/2/

    They all have a single address with both the state and city filling in, you’ll notice that they are being ordered as expected.

    That said, the solution is to edit the other entries so you have a single address that contain at least a city and state.

    Hope that helps!

    03/18/2015 at 10:35 am #323385
    Myles
    Guest

    Thanks Steve,
    I noticed how many were in an “other” box, didn’t realise it would make such a problem. I think I’ll import all those records again.

    All the best,

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

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