Support › MB Relationships › Filter the orderby of entries retrieved from databaseResolved
- This topic has 2 replies, 2 voices, and was last updated 4 years, 9 months ago by
Content Pilot.
-
AuthorPosts
-
September 1, 2018 at 4:14 AM #11199
Content Pilot
ParticipantIs there a way to filter the orderby parameter once I have retrieved a set of entries?
In the class MB_Relationships_Query, on line 60 sets the orderby parameter, but I need to change it for my use case, sorting all posts by date descending, not by how they were added in the backend. I could change them by hand but the client is updating the site in the future and needs a fool-proof solution.
Thanks for the help.
September 1, 2018 at 3:13 PM #11218Anh Tran
KeymasterHi Juanita,
You can overwrite the orderby parameter with this code:
add_filter( 'posts_clauses', function( $clauses, $query ) { $relationship = $query->get( 'relationship' ); if ( ! $relationship || 'REL_ID' != $relationship['id'] ) ) { return $clauses; } $clauses['orderby'] = 'ORDER BY post_date DESC'; return $clauses; }, 99, 2 );It overwrites the
orderbyin the query. You might change it to fit your needs.September 7, 2018 at 1:39 AM #11270ParticipantThe function needs to be altered a little bit for anyone else looking to do the same thing. Only change was to remove ORDER BY in the new SQL statement.
add_filter( 'posts_clauses', 'mb_sort', 99, 2 ); /** * Sort just the POST relationship by date DESC. * * @param array $clauses Existing clauses. * @param WP_Query $query Main Query. * @return array */ function mb_sort( $clauses, $query ) { $relationship = $query->get( 'relationship' ); if ( ! $relationship || 'REL_ID' !== $relationship['id'] ) { return $clauses; } $clauses['orderby'] = 'post_date DESC'; return $clauses; } -
AuthorPosts
- You must be logged in to reply to this topic.