When using order_by=organization it duplicates the results

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 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • 02/25/2016 at 6:26 pm #366895
    Scott Race
    Participant

    Hello,
    I’m using this shortcode. It started happening recently.

    I upgraded to the latest version today, 8.5.11, but it didn’t fix.

    [connections order_by='organization|SORT_ACS']

    If I remove the order_by, it does not display duplicates.

    I checked my backend and don’t see duplicates there either.

    Let me know what I can try to troubleshoot.
    Thanks!

    Scott

    02/26/2016 at 8:25 am #366940
    Steven Zahm
    Keymaster

    @ Scott

    Can you share a link of the page showing the issue so I can take a look?

    02/26/2016 at 10:04 am #366955
    Scott
    Guest

    Thanks!

    http://cal-smacna.org/member-directory/

    I need to unprotect the page though – currently member only content.

    Thanks for looking into it, I will unprotect in a minute.

    02/26/2016 at 10:16 am #366958
    Steven Zahm
    Keymaster

    @ Scott

    re: I will unprotect in a minute.

    Or, you could give me a login. If you do, you can post it here as a private reply.

    02/26/2016 at 11:04 am #366964
    Scott
    Guest

    You should be able to access the site now. Thanks!

    02/26/2016 at 11:19 am #366965
    Steven Zahm
    Keymaster

    @ Scott

    It seems that you do have duplicates. You have an entry added once as an Individual and then another time as a Family. You will be able to confirm this by filtering by entry type on the Connections : Manage admin page. If you change the filter to Show All Entries you should see the duplicates.

    03/09/2016 at 3:35 pm #368426
    Scott Race
    Guest

    Thanks for checking it out.

    So I don’t see the duplicates when filtering by “Show All Categories” and “Show All Entries” and “Show All”.

    When I do “Show Families” I see my list of companies.

    When I do “Show Individuals” I see my list of people.

    When I do “Show Organizations” I see nothing.

    My shortcode I was using was:
    [connections order_by='organization|SORT_ACS']

    which I realized shows Families and Individuals (who are linked to Families).

    So I changed my shortcode to:
    [connections list_type='family' order_by='organization|SORT_ACS']

    And now it’s displaying just what I need it to.

    Thanks for the great support! You are one of the most respectful and responsive developers I know.

    Scott

    03/10/2016 at 12:27 pm #368571
    Steven Zahm
    Keymaster

    @ Scott

    re: And now it’s displaying just what I need it to.

    Great to hear!

    re: You are one of the most respectful and responsive developers I know.

    Thanks! I appreciate that.

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

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