order_bu="meta_key"

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 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • 02/14/2019 at 1:10 am #484581
    Trevor Wilcox
    Participant

    Hi Steve

    I took note of one of your comments in another thread about using order_by=”meta_key” and having to allocate all entries with a value accordingly, or else they won’t show. But would it not work in conjunction with other sort parameters, so that it sorts by meta_key and then something else?

    E.g. [connections page_limit=250 order_by="meta_key:depthod|SORT_ASC, department|SORT_DESC, last_name|SORT_ACS, first_name|SORT_ACS" enable_category_select='TRUE' show_profile_link='FALSE' image="photo" image_width=73 image_height=90 show_phone_numbers='FALSE' show_org='TRUE' show_image='TRUE']

    This would be useful.

    Thanks
    Trevor

    02/14/2019 at 9:34 am #484631
    Steven Zahm
    Keymaster

    @ Trevor

    RE: I took note of one of your comments in another thread about using order_by=”meta_key” and having to allocate all entries with a value accordingly, or else they won’t show. But would it not work in conjunction with other sort parameters, so that it sorts by meta_key and then something else?

    Sure, I think it should work with other sort parameters.

    02/14/2019 at 7:28 pm #484668
    Trevor Wilcox
    Participant

    Not having any luck with that though. It includes for example the one record where the meta_key is set but excludes everything else.

    02/14/2019 at 9:42 pm #484679
    Steven Zahm
    Keymaster

    @ Trevor

    That sounds like it is working … you now need to go add that custom field to the other entries you want to display. You can not order by a field which does not exist. Hope that helps!

    02/14/2019 at 10:40 pm #484681
    Trevor Wilcox
    Participant
    This reply has been marked as private.
    02/14/2019 at 11:19 pm #484682
    Trevor Wilcox
    Participant

    Have been digging through the forum since I posted my last question above, and found your responses regarding how the order is determined by database weighting. But I still find after several tests that the ascending order of ID holds true also.

    02/15/2019 at 8:55 am #484721
    Steven Zahm
    Keymaster

    @ Trevor

    Install the Query Monitor plugin. It will allow you to view all database queries made.

    Scroll thru them and find the ones made by Connections on the page. It should be logged from the cnRetrieve->entries() caller. You’ll know if it’s the right one because you’ll see the meta parts of the query which match the values you supplied in the shortcode.

    What is the full query?

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

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