# Wish list: SQL for canned reports
**URL:** https://meta.discourse.org/t/wish-list-sql-for-canned-reports/245938
**Category:** Data & reporting
**Tags:** sql-query, dashboard-reports
**Created:** [November 17, 2022, 5:23pm UTC](https://meta.discourse.org/t/wish-list-sql-for-canned-reports/245938 "2022-11-17T17:23:12Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@ganncamp](https://meta.discourse.org/u/ganncamp)
#### Post date: [November 17, 2022, 5:23pm UTC](https://meta.discourse.org/t/wish-list-sql-for-canned-reports/245938/1 "2022-11-17T17:23:12Z")
I semi-regularly find myself wanting to take one of the standard reports (today it’s Consolidated Pageviews) and go a little farther with it.
Rather than having to start from scratch, it would be an amazing 🎄 🎁 if I could get from the report to its SQL to iterate.
---
### Author:  [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [November 17, 2022, 7:32pm UTC](https://meta.discourse.org/t/wish-list-sql-for-canned-reports/245938/4 "2022-11-17T19:32:48Z")
It’s not built with SQL, but that’s ok, we can derive it …
Here’s the overall guide on Meta:
> [@Admin dashboard report reference guide](https://meta.discourse.org/t/admin-dashboard-report-reference-guide/240233):
>
> bookmark This is a reference guide for describing how the Admin Dashboard Reports function, the data they’re displaying, the corresponding [Data Explorer](https://meta.discourse.org/t/32566?silent=true) SQL queries, and where to find the Ruby code for each report. person_raising_hand Required user level: Staff Discourse contains several built-in admin dashboard Reports that can be useful for exploring stats about a community. To access these reports, you can visit discourse.example.com/admin/dashboard/reports on your site ( or click the…
Specifically: [discourse/app/models/concerns/reports/consolidated\_page\_views.rb at main · discourse/discourse · GitHub](https://github.com/discourse/discourse/blob/main/app/models/concerns/reports/consolidated_page_views.rb)
It’s built using [a Rails Model, `ApplicationRequest `](https://github.com/discourse/discourse/blob/main/app/models/application_request.rb), e.g.
```plaintext
[3] pry(main)> ApplicationRequest.last(10)
=> [#,
#,
#,
#,
#,
#,
#,
#,
#,
#]
```
The corresponding table you need is `application_requests` (but I don’t see this exposed in [Data Explorer](https://meta.discourse.org/t/32566?silent=true), maybe I missed it?)
The req\_type(s) in this report are:
```plaintext
page_view_logged_in
page_view_anon
page_view_crawler
```
It is regular a sum and group by, so probably, you could start off with, on the Rails console:
```plaintext
ApplicationRequest.where(req_type:["page_view_logged_in", "page_view_anon", "page_view_crawler"]).where('date BETWEEN ? AND ?', '11/14/2022', '11/17/2022')
```
for example
or the SQL equivalent:
```plaintext
SELECT * FROM application_requests WHERE req_type IN (7, 8, 6) AND (date BETWEEN '11/14/2022' AND '11/17/2022')
```
Some of the aggregation is already done for you as the data is in a count column.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [December 17, 2022, 7:33pm UTC](https://meta.discourse.org/t/wish-list-sql-for-canned-reports/245938/5 "2022-12-17T19:33:06Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.