Relationship Options – Customized ORDER BY

  • Resolved rscarter1

    (@rscarter1)


    2 years, 2 months ago

    Still having trouble with shortcode but maybe this will work.

    In my custom taxonomy, I have one field that is “type: Relationship” – related to the CPT “Artworks” and is a Bi-Directional Field to the field “artistname” in the CPT.

    In the “Relationship Options” tab within this field setting, there is the “Customized ORDER BY” field. What I’m looking to do is to show the items based on the date from each item’s “Auction date” in the CPT. That field is called “auction_date_new”.

    So, I tried adding auction_date_new and artwork.auction_date_new, also tried appending DESC to this, but nothing happens. The order doesn’t change.

    I’ve been trying to display these items (using the field shortcode [pods field="artworks" template="Artist List of Works"][/pods] ) with an orderby and limit, and pagination but can’t get this to work.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter rscarter1

    (@rscarter1)

    I went back to the pods name instead of field and finally figured out how to do what I was trying to do, which is dynamically sort the posts based on the taxonomy term archive page being used.

    This worked:

    <p>[pods name="artwork" limit="20" template="List View" orderby="auction_date_new DESC" pagination="true"]</p>

    Thread Starter rscarter1

    (@rscarter1)

    Oops, I mean:
    [pods name="artwork" where="artist.slug='{@slug}'" template="List View" limit="20" orderby="auction_date_new DESC" pagination="true"]
    I had tried the “where” clause before to no avail. But then, I found that single quotes around the magic tag made it work.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Relationship Options – Customized ORDER BY’ is closed to new replies.

Tags