[UX] Add list of sites to dashboard

VERIFIED FIXED

Status

P2
normal
VERIFIED FIXED
8 years ago
7 years ago

People

(Reporter: wenzel, Assigned: wenzel)

Tracking

Details

(URL)

(Assignee)

Description

8 years ago
The list of sites is currently commented out. Needs to be pulled out of the website_issues DB and shown in the right sidebar.
(Assignee)

Updated

8 years ago
Depends on: 582101
(Assignee)

Comment 1

8 years ago
Michael, can you either do this or give me a code snippet I can use to squeeze this information out of the DB? We need the most mentioned URLs for the last day, along with the count.
This does not strictly require clusters/the website_issues db if I understand correctly. But sorting by an aggregate criteria is always expensive. And probably sites for the past day will also be needed on the sites page or somewhere else. So I added clusters per day to the generate-command, in addition to the clusters per week and per latest beta that we already have.


How to query this: should look similar to the _fetch_summaries function. As data is pre-aggregated and grouped, it is important that the "version" and "positive" fields are specified in every query (otherwise there are duplicates).

Example: Get the top ten sites for the last day, with any feedback:
SiteSummary.objects.filter(version__exact='<day>').filter(positive__exact=None)[:10]

Get the top ten sites with positive feedback for the beta 3:
SiteSummary.objects.filter(version__exact='4.0b3').filter(positive__exact=1)[:10]
(Assignee)

Comment 3

8 years ago
Thanks. I'll kick this out of the milestone for now, though.
Target Milestone: 1.7 → ---
Okay, the "<day>" version is in the stage database (exported it manually), and the code above should work as advertised.

Commit: http://github.com/michaelku/reporter/commit/aeddd3a6dc1b2d8e8df93c9c15487f583eeae2e9
(That commit URL might be confusing: I already pushed it to fwenzel/master)
(Assignee)

Comment 6

8 years ago
Thanks to your code, that was pretty simple, thanks:
http://github.com/fwenzel/reporter/commit/61c51fc
Assignee: nobody → fwenzel
Status: NEW → RESOLVED
Last Resolved: 8 years ago
Priority: -- → P2
Resolution: --- → FIXED
This is the "While Visiting" block on the right, correct?
(Assignee)

Comment 8

8 years ago
Yup!
Component: Input → General
Product: Webtools → Input
You need to log in before you can comment on or make changes to this bug.