Sorting discussions by votes

tmilovan

This discussion is related to the Voting addon.

It would be really great if we could sort discussions on "Popular" dicussion list by votes. Or is this already possible somehow?

Raize

kind of like digg

helmi

that'll sound good. having such a sort option would be great.

Lincoln

Doesn't clicking on the "Votes" tab before the first comment accomplish this?

tmilovan

No, or yes :)) but only for comments. I was thinking about sorting discussions on discussions list.

scoobeee

I just realized the "popular" tab in the discussions page does not take into account votes like I thought. Kind of makes voting on discussions a bit futile right? Has anyone implemented a sort on votes tab for discussions not comments?

jamesmcintyre

I second @scoobee, shouldn't there be an option to sort discussions by vote and make this the default view?

realrasengan

Find:

DiscussionModel->SQL->OrderBy('d.CountViews', 'desc'); (for me it was line 458)

Comment out and insert: $DiscussionModel->SQL->OrderBy('COALESCE(d.Score,0)', 'desc');

Now you will have it sorted by vote.