Query Builder - Query Post by Pro 'Format' and Exclude current

[MintCondition]

Got a few questions around building a custom layout for post pages:

1. I want to only pull a loop of posts that are formatted as “Video”. I don’t see anyway to do that. I suppose if I need to I can use ACF and CPT to make a Video Post Type, but I’d rather do it with the built-in if possible.

2. This loop is for an “Other videos” section of a page, and I’m pulling 3 random videos like the current. However, I want to be sure that the list doesn’t include the current. (Why show them a link to the video they are already watching?) Is there a way to do that in the query? Or is there another way to pull it off? Maybe using the conditions?

[tristup]

Hi @MintCondition,

Please find the answer to your queries below.

1. You need to use the tax query using the Query String option to get the posts based on the post formats, please check this article to build your query

WP_Query | Class | WordPress Developer Resources

2. To exclude current post, you need to add the ‘post__not_in’=> array( ‘{{dc:post:id}}’ ) to the above query.

Hope it helps.
Thanks

[MintCondition]

Drilling into point 1, can you explain how the WP_Query translates to the Query String in the looper? Specifically, I think the WP_Query would be something like :
‘post_type’ => ‘post’,
‘tax_query’ =>
array(
‘taxonomy’ => ‘post_format’,
‘field’ => ‘slug’,
‘terms’ => array( 'video '),
)
Maybe… I might have dorked that up.

But how do I convert that to the syntax the QS is looking for? I’ve tried a few guesses but none seem to return anything, so I’m doing something wrong.

[tristup]

Hi @MintCondition,

I would like to refer to my colleague Kory’s comment in the following thread, which may be helpful to you to create the Query String based on your argument array and tax query.

Looper Query String: Featured Products

Hey, @bobbybosler! Thanks for writing in…longterm we definitely are wanting to get in either some new Provider Types for Loopers or add a way for WooCommerce-specific queries in the Query Builder to access certain features like Featured Products, Cross sells, Upsells, et cetera. That being said, we do not have an exact timeline on when we will get this in, so I wanted to take a moment to see if I could get a query string together for you, and I believe I’ve got something working! Check out the f…

Hope it helps.
Thanks

[MintCondition]

Ok, so that was more complicated than I felt like it needed to be, but for anyone that finds this thread later, here’s the query I came up with that is working:

tax_query[0][taxonomy]=post_format&tax_query[0][field]=slug&tax_query[0][terms]=post-format-video&tax_query[0][operator]=IN

The hard bit was digging into the tables to figure out that 1) the actual term is “post-format-video” and 2) realizing that while “post_format” uses an underscore as a separator, “post-format-video” uses a dash. Anyway, I got it working now. =)

[MintCondition]

@tristup

To exclude current post, you need to add the ‘post__not_in’=> array( ‘{{dc:post:id}}’ ) to the above query.

Ok, so how to add that to the above query, because it’s not working as I expect:

posts_per_page=4&tax_query[0][taxonomy]=post_format&tax_query[0][field]=slug&tax_query[0][terms]=post-format-video&tax_query[0][operator]=IN

How do I attach the post__not_in bit?

[ruenel]

Hello @MintCondition,

Please use it like this:

posts_per_page=4&post__not_in[0]={{dc:post:id}}&tax_query[0][taxonomy]=post_format&tax_query[0][field]=slug&tax_query[0][terms]=post-format-video&tax_query[0][operator]=IN

Hope this helps.