bbPress.org

I would like to sort the topics by the number of likes column on the admin edit screen.

This is what ive got:

<?php
// make columns sortable -------------------------------------------------
	
// define which columns to be sortable
add_filter( 'manage_edit-topic_sortable_columns', 'topic_likes_table_sorting' );
function topic_likes_table_sorting( $columns ) {
	$columns['likes_count'] = 'likes_count';
	return $columns;
}

// add sortable to meta key
add_action( 'pre_get_posts', 'likes_orderby' );
function likes_orderby( $query ) {
	if ( ! is_admin() ){ return; }

	$orderby = $query->get( 'orderby');

	if ( 'likes_count' == $orderby ) {
		$query->set('meta_key','bbpress_topic_like_button_like');
		$query->set('orderby','meta_value_num');
	}
}

I dont think there is a meta_key for favorites stored in the topic post_meta? I’m setting the number in the column by using the following:

$topic_id = bbp_get_topic_id($id);
$likes_count = bbp_get_topic_favoriters($topic_id);

I think the favorites are stored with the users metadata. So my best guess is that ill need to write a function that stores/updates the number of favorites inside the post meta. Then and only then can I sort the posts by that new metakey. Can anyone point me in the right direction with this?

Thank you!