Add filter for 'Most Popular' or 'Most Subscribed' newsletters
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Tinaj1234
	Apr 2 2016, 1:18 PM

Description

Filter on Special:Newsletters could use a category called 'Most Popular' or 'Most Subscribed' newsletters.

Details

	Subject	Repo	Branch	Lines +/-
	Sort by the 'most popular' newsletters	mediawiki/extensions/Newsletter	master	+158 -26
	Add in 'nl_subscribers_count' column to 'nl_newsletters' table	mediawiki/extensions/Newsletter	master	+81 -0

Customize query in gerrit

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Open		None	T159083 Database Query improvements for the Newsletter extension
		Resolved		01tonythomas	T131607 Add filter for 'Most Popular' or 'Most Subscribed' newsletters

Event Timeline

Tinaj1234 created this task.Apr 2 2016, 1:18 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 2 2016, 1:18 PM

Is this really needed when the default list is already sorting by number of subscribers?

http://newsletter-test.wmflabs.org/wiki/Special:Newsletters?filter=unsubscribed

We still might want to highlight this explicitly, but I would not rush to implement this. Let's wait for feedback from real users.

True. I think a much needed feature would be listing of recent issues somewhere on the newsletter main page!

(List of newsletters by most recent issues is a very good idea!)

In T131607#2174288, @Qgil wrote:

Is this really needed when the default list is already sorting by number of subscribers?

The default list orders the current-user-subscribed-newsletters first and then the other newsletters. I don't think it's in accordance with the number of subscribers. Anyways, this feature can wait.

Qgil moved this task from Backlog to Needs discussion on the MediaWiki-extensions-Newsletter board.Apr 3 2016, 8:24 AM

You are right, I thought the second criteria was number of subscribers, but after playing a bit more now I see that this is not the case.

Still, Kaity's idea about sortable columns (T116353#2175737) might be better, because this would allow users to just click the Subscribers column if this is what they want.

Qgil triaged this task as Low priority.May 12 2016, 10:52 AM

Qgil moved this task from Needs discussion to Confirmed on the MediaWiki-extensions-Newsletter board.

Change 354756 had a related patch set uploaded (by 01tonythomas; owner: 01tonythomas):
[mediawiki/extensions/Newsletter@master] Add in 'nl_subscribers_count' column to 'nl_newsletters' table

https://gerrit.wikimedia.org/r/354756

gerritbot added a project: Patch-For-Review.May 20 2017, 7:41 PM

Change 354756 merged by jenkins-bot:
[mediawiki/extensions/Newsletter@master] Add in 'nl_subscribers_count' column to 'nl_newsletters' table

https://gerrit.wikimedia.org/r/354756

Change 354905 had a related patch set uploaded (by 01tonythomas; owner: 01tonythomas):
[mediawiki/extensions/Newsletter@master] [WIP] Sort by the 'most popular' newsletters

https://gerrit.wikimedia.org/r/354905

Change 354905 had a related patch set uploaded (by Brian Wolff; owner: 01tonythomas):
[mediawiki/extensions/Newsletter@master] [WIP] Sort by the 'most popular' newsletters

https://gerrit.wikimedia.org/r/354905

01tonythomas added a parent task: T159083: Database Query improvements for the Newsletter extension.May 21 2017, 4:03 PM

01tonythomas moved this task from Confirmed to Security Review (production blockers) on the MediaWiki-extensions-Newsletter board.May 21 2017, 4:47 PM

Change 354905 merged by jenkins-bot:
[mediawiki/extensions/Newsletter@master] Sort by the 'most popular' newsletters

https://gerrit.wikimedia.org/r/354905