The list of sites is currently commented out. Needs to be pulled out of the website_issues DB and shown in the right sidebar.
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]
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)
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?
Verified FIXED on http://input.stage.mozilla.com/en-US/.
Status: RESOLVED → VERIFIED
Component: Input → General
Product: Webtools → Input
You need to log in before you can comment on or make changes to this bug.