Order by post__in

Este hilo está resuelto. Aquí tiene una descripción del problema y la solución.

Problem:
Add post__in to Query / order

Solution:
It is not simple to add a sorting option for `post__id` since we use that `post__in` query argument in several places, not just the filter by post IDs, so there is no actual way of setting the posts that this sorting option would apply as order list.
The same for `post_name__in` and `post_parent__in`, we cannot offer the posts to include in that sorting option.

This support ticket is created hace 6 años, 7 meses. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Hoy no hay técnicos de soporte disponibles en el foro Juego de herramientas. Siéntase libre de enviar sus tiques y les daremos trámite tan pronto como estemos disponibles en línea. Gracias por su comprensión.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	-	14:00 – 20:00	14:00 – 20:00	14:00 – 20:00	14:00 – 20:00	14:00 – 20:00
-	-	-	-	-	-	-

Supporter timezone: Asia/Ho_Chi_Minh (GMT+07:00)

Etiquetado: Views plugin

Este tema contiene 6 respuestas, tiene 2 mensajes.

Última actualización por Twig hace 6 años, 7 meses.

Asistido por: Beda.

Autor

Mensajes

abril 15, 2018 at 9:14 pm #668923

Twig

Hi -

I'm looking to pass Post IDs into a View (using the shortcode parameter, as it will vary from page to page) and I want to maintain the order of the posts as passed. I.e. [wpv-name posts="10,5,200"]... should display posts in the order 10, 5, 200 - not in the SQL-native order of 5, 10, 200.

Here is a thread from a few years ago:
https://toolset.com/forums/topic/order-the-items-in-a-view-by-ids-order-not-ascending-or-descending/

I can see & use the fix - but I was wondering why you guys can't just add an "Order by Post__In" option to the UI for the Views page? This has been supported in WP core since (I think) v3.5.

Thanks

abril 16, 2018 at 3:47 pm #674434

Twig

I think perhaps the filter priority needs to be > 99. It doesn't work for me when priority is 99, but does work when set to 999.

abril 17, 2018 at 9:53 am #678309

Beda

As our document outlines, every filter must be above 100.
https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query

abril 17, 2018 at 12:06 pm #679036

Twig

Ok thanks @Beda - I guess the ticket from 3 years back just used the wrong priority.

Any ETA on when you guys might add "Order by post__in" to the native View options? Seems like it would be an easy addition to the dropdown & $query_args logic, no? In fact, it actually seems to already work when you set it in the Views shortcode manually like:

`{!{wpv-view name='...' postids='355,370,372...' orderby='post__in'}!}`

Thanks!

abril 18, 2018 at 9:16 am #683814

Beda

Well, we use that in several places yes.
https://toolset.com/forums/topic/add-post__in-as-order-by-option/#post-515214

But ordering by it won't be implemented.

abril 18, 2018 at 10:55 am #684430

Twig

Thanks Beda. That's funny that you referenced my request from a year ago 🙂

I still don't quite understand the limitation you mention, but since that filter is easy enough to add, it's not a big deal.

abril 23, 2018 at 2:52 pm #717417

Twig

In case this helps anyone else looking for a programmatic way to order by post__in, I've found that you can't pass 'post__in' directly into the shortcode because Views strips the string "post" out of any value.

However you can pass a custom value (like orderby='ids') then have the filter function catch any shortcode with that param value, and update it to be 'post__in'. That way, you don't need to hard-code View IDs into your filter.