Feature Request: Submissions with a numerical rating

[jayyx2]

I am investigating this for our case and am glad to discuss it further.

Problem

• Our readers are used to giving things a 1-5 before forwarding to the next reader
• Our admins and editors are used to sorting submissions in their queue by highest rating

Proposed Solution

• New functionality which provides a user-defined rating scale required field for forward action(s) [default: off]

Potential approaches

• New DB table that keeps track of ratings linked back to the submission_id
• New PHP function for obtaining the average of all ratings for column in submission list
• New PHP function for seeing rating by user on submissions
• If option enables, conditionally add to existing submission list table as 'rating' column

Other uses?

• TBD

[devinemke]

@jayyx2 Question: is this rating a one-to-one thing with submissions, meaning each submission has one and only one rating (that can updated/changed by staff users)? If so then this could be an additional column in the submissions table.

If however (as I suspect by your description) that one submission can have many ratings, by many users, then as you said, this would require a new table that might look something like this:

CREATE TABLE `ratings` (
`rating_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
`submission_id` mediumint unsigned DEFAULT NULL,
`reader_id` mediumint unsigned DEFAULT NULL,
)

What then would the UI of this look like? Here is the main submissions search UI:

Would there be an additional form field (select box) to search based on rating (1-5)?
You mentioned average ratings? Would this then require yet another search form field?

Where/how would users add a ratings? I suppose this could added to the update submission popup:

Again, there would be an additional select box for rating (1-5)?

Then on the submission index/list:

... there would be an additional column, showing the average rating (if any)?

Please let me know what you think.
Thanks -DE

[jayyx2]

Would there be an additional form field (select box) to search based on rating (1-5)?
You mentioned average ratings? Would this then require yet another search form field?

• I don't believe there is a need for this. The list of submissions just needs to be sortable by descending or ascending avg rating.

Where/how would users add a ratings?

• This mostly aligns with what I was thinking. However, I was thinking of tying it to the actions. Each reader should only be able to rate something once, and as part of the rating, pass it on to the new reading group. That is why I believe it should be part of the "action"(forwards?) workflow. Note, only editors + admins should be able to see the ratings given to stories.

Then on the submission index/list:... there would be an additional column, showing the average rating (if any)?

• Yes, a column we can sort by ascending/descending.

The true end goal is editors + admins being able to sort by average story rating, as well as each reader being required to enter a rating 1-5, although this could be user customizable in configuration area. These are the current main requirements, but any additional things would just be nice to have.

I hope this helps, and I'm happy to collaborate on this with you.

[devinemke]

@jayyx2 So if I am understanding this correctly, there is no need for an additional ratings table. Rather, this can simply be an additional column in the actions table. That way, readers can add a rating when a new action is created, and individual submissions can then accrue multiple ratings (via multiple actions) and thus we can divine an average rating per submission?

I would further suggest that we add and additional column to the groups table that allows admins to have granular control over who can rate submissions. Perhaps by default only admin/editors, but you could add the other (regular 1-5) groups to have ratings privileges. In the config UI this could simply be another boolean/checkbox to either allow/disallow group ratings.

Then in the UI for submissions: we currently have a sort by date ascending/descending. We would add sort by average rating ascending/descending? Would there ever be a need to sort by average rating ascending? that is: the lowest rated submission first?

What do you think?

Thanks -DE

[jayyx2]

This sounds perfect.

In speaking with the editor, they use the sorting by lowest to be able to quickly reject (or ban) those that they can. In the current workflow, readers rate stories 1 when they are reporting them for any reason. With that in mind, it may be nice to have a way to "flag" submissions for editors/admins to quickly clean. However, just the rating system should cover the same purpose if the reader follows the same workflow. I'll put in a new feature request for "Ban"