Own sorting relationship fields

  • Resolved wilbert schaapman

    (@wilbertschaapmancom)


    5 months, 2 weeks ago

    I have created a pod called ‘Projecten’ and a pod called ‘Medewerkers.’ They are related, so in ‘Projecten,’ I can select which ‘Medewerkers’ are involved. Currently, the list of ‘Medewerkers’ is sorted in descending order by title. However, I would like to choose a custom order for displaying them in the project list. How can I set my own selection and sorting order

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Paul Clark

    (@pdclark)

    In the relationship field under the Relationship Options tab, see the Custom ORDER BY option, which takes a MySQL ORDER BY query.

    By time, present to past:

    CAST( t.post_date as DATETIME ) DESC

    For a custom order, lowest to highest:

    t.menu_order ASC

    Menu Order can be enabled as a number when editing the pod under Advanced Options tab > Supports > Page Attributes, or using drag-and-drop on the post listing screen with Simple Custom Post Order.

    Thread Starter wilbert schaapman

    (@wilbertschaapmancom)

    Thank you for your help. When I enter a value in the custom order by field called ‘achternaam’ for ordering, it’s not working. I’ve set the order to t.achternaam ASC, but it doesn’t seem to have any effect, only i cannot select any medewerker anymore

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.