Apply Sort Order to custom query
-
I’m trying to use your plug-in with a custom WP_Query() on a custom posttype. Is that something that should work or be possible?
Here is my query:
$args = array( 'post_type' => 'menu-item', 'posts_per_page' => -1, 'parent' => $cat_id, 'tax_query' => array( array( 'taxonomy' => 'menus', 'field' => 'ID', //can be set to ID 'terms' => $cat_id, //if field is ID you can reference by cat/term number 'include_children' => false ) ) ); $menu_items = new WP_Query( $args );
-
Not sure exactly what I’m looking at, buthere is the full SQL query I’m seeing:
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_reorder_post_rel ON wp_posts.ID = wp_reorder_post_rel.post_id and incl = 1 WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (29) ) AND wp_posts.post_type = 'menu-item' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'private') AND wp_reorder_post_rel.category_id = '29' GROUP BY wp_posts.ID ORDER BY wp_reorder_post_rel.id ASC LIMIT 0, 1There is an
INNER JOIN wp_reorder_post_rel ON wp_posts.ID = wp_reorder_post_rel.post_id, but when the page is rendered the items are not displayed in the custom order.Yes, but as you can see it wouldn’t work because for some odd reason it has a
ASC LIMIT 0, 1on it. Meaning there is nothing to “order” since it’s only one result. That’s why i=I wasn’t sure it was the correct query. If I remove thelimitit does appear to return the correct items.am afraid you don’t understand mysql order by / limit syntax.
The sql statement returns only 1 row from the ordered result, starting from the first (starts at 0) row.
This is exactly what you want when you do a front-end query as you want to loop over the results 1 row at a time (or 1 post at a time). Have you forgotten to loop through your results?
If I remove the limit it does appear to return the correct items.
which means the plugin is working as expected, so I am closing this thread. If you need more help understand custom queries in WordPress, I suggest you post on the general forum or on stackexchange.
Hi there,
I am running into a similar issue with my query on a custom post. I check the request that is being made and the left join is not being added to the query yet I have all the correct settings in the plugin settings and I am currently using it for other custom posts setup in the same way. I have tried deselecting and selecting the manual sort option and that did not make a difference.
I can also see the changes I make being saved in the correct relationship table but on the front end I do not see any changes.
Any assistance would be greatly appreciated.
Thanks!
Yes I have enabled the custom sort on the custom post type. I am using wp_query and passing the custom post type, category, posts_per_page as -1 and suppress filters set to false.
Here is the query:function work_items($categories)
{
$args = array(
‘post_type’ => ‘work_item’,
‘category_name’ => $categories,
‘numberposts’ => -1,
‘posts_per_page’ => -1,
‘suppress_filters’ => false
);$posts = new WP_Query($args);
return $posts;
}I call this function and then loop through the posts in a while loop and output the formatted html.
The topic ‘Apply Sort Order to custom query’ is closed to new replies.
