junkes

That was awesome. You guys helped me so much. Thank you!

I installed 2.8.2 but I guess it didn’t resolve my issue. At least, not with old code that was working before 2.8.

Wow, that was an amazing help, thank you, it worked perfectly!

If I would like to add more custom macros, for other fields, should I just add more tags like $pods_field_slug / $value / %%pods_relationship_id%% (obviously, changing the names of it for each new macro) or is there a better way to it?

Yes, taxonomy name is “ano” and it’s associated with the CD (“disco”) CPT with Pods. Yes, all the CDs are set as published.

Hey, @wpmudevsupport12. Yes, I’m using Pods – Custom Content Types and Fields.

I guess this is it. Just FYI, in this case, it’s an artist page (“artista” post type, in portuguese) that displays artist’s CDs (“disco” post type) by Year (“ano” tax).

SELECT

DISTINCT
t.*
FROM wp_posts AS t

LEFT JOIN wp_podsrel AS rel_artista ON
rel_artista.field_id = 2263
AND rel_artista.item_id = t.ID

LEFT JOIN wp_posts AS artista ON
artista.ID = rel_artista.related_item_id

LEFT JOIN wp_postmeta AS artista_ID ON
artista_ID.meta_key = ‘ID’
AND artista_ID.post_id = artista.ID

LEFT JOIN wp_term_relationships AS rel_ano ON
rel_ano.object_id = t.ID

LEFT JOIN wp_term_taxonomy AS rel_tt_ano ON
rel_tt_ano.taxonomy = ‘ano’
AND rel_tt_ano.term_taxonomy_id = rel_ano.term_taxonomy_id

LEFT JOIN wp_terms AS ano ON
ano.term_id = rel_tt_ano.term_id

LEFT JOIN wp_termmeta AS ano_name ON
ano_name.meta_key = ‘name’
AND ano_name.term_id = ano.term_id

WHERE ( ( artista.ID = ‘2513’ ) AND ( t.post_type = ‘disco’ ) AND ( t.post_status IN ( ‘publish’ ) ) )

ORDER BY ano.name ASC, t.menu_order, t.post_title, t.post_date

Thank you, @sc0ttkclark, I’ll try that. And, btw, that’s an awesome ideia for the future!

Hey, @pdclark, that worked as a charm, thank you very much. I wonder if it’s possible to do that not with post_title but another field in CD…

Actually, I don’t mind to get the first one because it’s getting a link to a CD that contains that song, so it would be ok, even preferable.

I did everything about “Using Shortcodes in Pods Templates” and I use them a lot. My problem here is that it seems I can’t use them inside an href=”[pods]”, is that so? And if it is, would there be another way to do that?

I thought about using a function to limit the outcome of {@CDs} to just one (preferable the first one ordered by a tax field called year), like {@CDs,my_function}, would that be possible?

I also think that, @keraweb. Even more because it only happens with the @post_content tag. But how could I easily test that? If I disable auto templates, than the Artist single page won’t load with that template and I wouldn’t be able to test it, right?

Anyway, if that’s the case, is there a way to bypass that? Or maybe I shouldn’t be using @post_content in auto templates templates that are using the_content hook?

And if that’s the case, I have a Pods/Wordpress question about it: why it works using [each] and it doesn’t when I use a shortcode to get another template?

Sorry, @keraweb, but I didn’t get that. Do you mean like [pods name=”cd” where=”artist.ID = ‘{@artist.ID}’” orderby=”year.name ASC” template=”List of Cds”] ??

Anyway, the thing is, I’m being able to display the CDs info correctly if I don’t use the field {@post_content} in the “List of CDs” template (also, when I use the @post_content field, the page loads for a long time and display nothing but the header).

All fields are being displayed correctly when I don’t use the {@post_content}, so I think the where param is working fine there.

Is it possible that the where param affects only the {@post_content} field?

• This reply was modified 3 years, 10 months ago by junkes.
• This reply was modified 3 years, 10 months ago by junkes.

About the first topic, sorry, I couldn’t reply any sooner. My bad.

And, yes, I was using the wrong {@}. It worked now. Thank you!

Yes, that was it. It’s weird because I was doing exactly that. What I saw in the video that may help other people is that after creating the bi-directional relationship in one field you go back to the other one to give it an update as well; I don’t know, but I think that was the charm.

Anyway, thanks for the reply and for the video. They really help.