Frontend display of all linked posts in multiple relationships

This topic has 7 replies, 3 voices, and was last updated 6 years ago by Max Elman.

Viewing 8 posts - 1 through 8 (of 8 total)

Author

Posts
December 12, 2018 at 11:51 AM #12611

Max Elman
Participant

This site has CPT "attorney" with multiple linked CPTs "legal news", "events", "alerts", "articles". I currently have them all displaying in separate lists here: https://cooperwhitecooper.kinsta.com/attorney/sarah-j-banola/

I'd like to combine the lists for "alerts", "articles", and "legal news" and have them display together in chronological order. How can I combine multiple relationship queries like that?

Thanks!

Add New Note to this Reply

December 12, 2018 at 4:55 PM #12616

Farheen
Participant

Hello Max

Can you please share your code here.

you want to be able to add “alerts”, “articles”, and “legal news” separately and display them together, is that what you want?

Thanks

Add New Note to this Reply

December 12, 2018 at 11:30 PM #12630

Max Elman
Participant

Correct. Current registration code:

https://ghostbin.com/paste/9x8jp

Add New Note to this Reply

December 19, 2018 at 3:51 AM #12730

Max Elman
Participant

Hi there - Any chance someone can help resolve this? Thanks!

Add New Note to this Reply

December 19, 2018 at 8:43 AM #12731

Anh Tran
Keymaster

Hi Max,

The current version doesn't support query from multiple relationships at once. However, there's a workaround. You can make a raw query to get all your connected posts like this:

https://ghostbin.com/paste/9gfhe

Add New Note to this Reply

December 20, 2018 at 8:31 AM #12744

Max Elman
Participant

Thanks! This looks close, but breaks the page and throws errors:
2018/12/20 01:25:39 [error] 61905#61905: *18816 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught ArgumentCountError: Too few arguments to function wpdb::prepare(), 1 passed in /www/cooperwhitecooper_161/public/wp-content/themes/cooper-white-cooper/functions.php on line 186 and exactly 2 expected in /www/cooperwhitecooper_161/public/wp-includes/wp-db.php:1222

Guessing that the << code >> elements shouldn't be within that wpdb->prepare statement? Can you check that?

Add New Note to this Reply

December 20, 2018 at 9:35 AM #12747

Anh Tran
Keymaster

I've updated the snippet, can you try again?

Add New Note to this Reply

December 20, 2018 at 9:40 AM #12748

Max Elman
Participant

That worked, thank you!

Add New Note to this Reply
Author

Posts

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic.