[$75] Enable SORTING by: Most recent Highest views Highest responses

[jmgasper]

Reported by testers:

In the new forum, I wasn't able to find an option sort by(Most Popular,Most recent,Date Posted) to see the questions posted in the forum.
Sorting will help the user to filter better

TC Requirement:

Enable SORTING by:

• Most recent
• Highest views
• Highest responses

[jmgasper]

Challenge https://www.topcoder.com/challenges/2fbcaf9b-953f-4dfa-8697-b652821a745c has been created for this ticket.

This is an automated message for ghostar via Topcoder X

[jmgasper]

Challenge https://www.topcoder.com/challenges/2fbcaf9b-953f-4dfa-8697-b652821a745c has been assigned to obog.

This is an automated message for ghostar via Topcoder X

[atelomycterus]

@jmgasper A few questions:

The category with discussions

1. Most recent
   Now sort options are New and Old. 'New' will be renamed to 'Most Recent'. Should I remove 'Old'?
   

2. Highest views - sorting by Count of Views

3. Highest responses - sorting by Count of Comments

The nested categories

We don't show sort options for nested categories. Let me know if it should be displayed:

[jmgasper]

@atelomycterus - Not sure where my comment went, but I'll post it again. Sorry for the delay:

1. Yes, we can remove Old and replace the options with the options in the requirements
2. Correct
3. Correct

[atelomycterus]

@jmgasper UPDATED: Sorting options have been added for discussions (Public Forums and Challenge Forums). At first I was confused by the updated Challenge Forums page screen.
A few questions. Please let me know if sorting options should be only changed for Public forums.

UPDATED (No changes, match MarvelApp): Sorting options for Challenges Forums page

Recently we've added sorting options (New/Old) for Challenges Forums page (#554). At least we should rename a sorting option for consistency (New to Most recent).
Should we remove Old options?

Challenges Forums page - https://marvelapp.com/prototype/c06bg41/screen/77911785.

If you want to add new sorting options for Challenge Forums:

• Highest responses - sorting by Count of Comments - We can add this sorting option quickly for Challenge forums page because each category has a calculated DB field/ cached value of CountAllComments.

• Highest views - sorting by Count of Views. This is more complicated for Challenge forums page, need to write a sql query to aggregate count of Discussion Views for each category and add/update this value in category cache and Category table. Otherwise it will work slowly if we recalculate everything at runtime. Public forums page works with a discussion table, this problem will not be here because the CountViews column is in the Discussion table . ~~

[atelomycterus]

@jmgasper Please apply PRs:

#588
topcoder-platform/forums-plugins#94

Thanks!

Public forums:

Challenge forums: