Page MenuHomePhabricator

Ability to discriminate between file types in Special:ListFiles
Open, LowPublic

Description

I'm looking at a page like https://commons.wikimedia.org/wiki/Special:ListFiles/ZMcCune_(WMF) .
Say I don't care about the pictures: I only want to see the videos this person made. Or the PDFs they uploaded.

Event Timeline

Elitre created this task.Sep 28 2016, 6:29 PM
Restricted Application added subscribers: Matanya, Aklapper. · View Herald TranscriptSep 28 2016, 6:29 PM
matmarex added a subscriber: matmarex.

This would require adding a database index on image (img_user_text,img_media_type,img_timestamp) (or something along these lines) to make these queries efficient. (Otherwise they could take minutes or more for users who have uploaded hundreds of thousands of files, resulting in a DOS vector.) It can be done, but we'd need to steal some DBA time to okay the change, and the database migration would have to be planned in advance (I'm not sure how long it would take, but presumably on the order of multiple days).

I'm not sure if it's really worth it, to be honest… If you need such a list, I could easily write you a Quarry query (where it's not a problem if it has to run for a few minutes).

Elitre added a comment.Oct 5 2016, 3:27 PM

I mean, uploaders like to showcase their work, but having to maintain lists on pages manually is a hassle. This would also automagically solve that need for some of them, I guess (obviously not for the cases where they want to differentiate by topic, for example).
.

MarkTraceur triaged this task as Low priority.Nov 28 2016, 6:12 PM
MarkTraceur moved this task from Untriaged to Triaged on the Multimedia board.