Rich9 gaming ph.Claim Your Free 999 Pesos Bonus Today

Resolved rscarter1
(@rscarter1)

2 years, 7 months ago

I have one main custom post type with two taxonomies created using pods.

The post type is called “artworks” for which I’ve created a template and use this shortcode to call it:

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

It lists each artwork and info according to the template, including the artist and bidders, the two taxonomies.

Clickin on either the artist or any of the bidders takes you to that taxonomy term which lists all of the artworks by that artist, or all of the artworks bid on by that bidder (whichever term you click on) and to show those, I use this example shortcode:

[pods field="artworks" template="Artist List of Works"][/pods]

The custom taxonomy has the artworks field attached and so this shortcode works well, but I can’t order it, or limit it to create a paginated view. Both the orderby and limit terms will not work and say that a pod needs to be named.

ANy hints on this or should I be going about this in a different way?

Viewing 5 replies - 1 through 5 (of 5 total)

Thread Starter rscarter1
(@rscarter1)

2 years, 7 months ago

I’ve tried this function but it didn’t work:
https://docs.pods.io/code-snippets/ordering-cpt-archive-by-custom-fields/

Plugin Author Jory Hogeveen
(@keraweb)

2 years, 6 months ago

Hi @rscarter1

For ordering (and filtering) in shortcodes you’ll need to use the correct field notation for custom fields.

See: https://docs.pods.io/code/pods/find/find-reference-table/#Field_Syntax_Reference

Cheers, Jory
Thread Starter rscarter1
(@rscarter1)

2 years, 6 months ago
Thanks @keraweb

I did try this already to no avail. There are no examples of what I am trying to do and am unable to figure it out.
- This reply was modified 2 years, 6 months ago by rscarter1.
Thread Starter rscarter1
(@rscarter1)

2 years, 6 months ago
I’ve tried several variations. Now I’ve been trying something like this on a taxonomy term URL:

[pods name="artwork" where="artistname.meta_value = t.name" template="Artist List of Works"]

Still a no-go
- This reply was modified 2 years, 6 months ago by rscarter1.
Plugin Support Paul Clark
(@pdclark)

2 years, 6 months ago

@rscarter1

Generally speaking, the WHERE queries are limited by the architecture of MySQL… I wouldn’t expect it to be able to match a meta value to a taxonomy term so simply without some sort of pre-parsing.

As a specific example, calculating one of the values with a Magic Tag like where="t.name IN( '{@pods.artistname}' )" may work, but one may also be able to query by taxonomy alone without the meta field, depending on how things are organized. See https://docs.pods.io/displaying-pods/magic-tags/special-magic-tags/ and the important link at top regarding PODS_SHORTCODE_ALLOW_EVALUATE_TAGS constant depending on where the shortcode is being used.

It’s difficult to debug your custom code and architecture in pieces. If you need further support, please join the #support channel on https://support.pods.io/chat/ and share a Pods package export from Pods Admin > Components > Import/Export Packages. The file generated by that page will contain your complete templates and relationships for suggestions or debug.