# قائمة الرغبات: SQL للتقارير الجاهزة

**URL:** https://meta.discourse.org/t/wish-list-sql-for-canned-reports/245938
**Category:** Data & reporting
**Tags:** sql-query, dashboard-reports
**Created:** [17 نوفمبر 2022، 5:23م UTC](https://meta.discourse.org/t/wish-list-sql-for-canned-reports/245938 "2022-11-17T17:23:12Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![merefield](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/merefield/32/176214_2.png) [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [17 نوفمبر 2022، 7:32م UTC](https://meta.discourse.org/t/wish-list-sql-for-canned-reports/245938/4 "2022-11-17T19:32:48Z")

</div>

لم يتم بناؤه باستخدام SQL، ولكن لا بأس، يمكننا استخلاصه…

إليك الدليل العام على 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…

على وجه التحديد: [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)

تم بناؤه باستخدام [نموذج Rails، `ApplicationRequest`](https://github.com/discourse/discourse/blob/main/app/models/application_request.rb)، على سبيل المثال:

```plaintext
[3] pry(main)> ApplicationRequest.last(10)
=> [#<ApplicationRequest:0x000055c8edcf99f8 id: 4798, date: Thu, 17 Nov 2022, req_type: "http_total", count: 3080>,
 #<ApplicationRequest:0x000055c8edcf9ac0 id: 4799, date: Thu, 17 Nov 2022, req_type: "http_background", count: 1014>,
 #<ApplicationRequest:0x000055c8edcf9bb0 id: 4800, date: Thu, 17 Nov 2022, req_type: "page_view_crawler", count: 539>,
 #<ApplicationRequest:0x000055c8edcf9c78 id: 4801, date: Thu, 17 Nov 2022, req_type: "http_2xx", count: 1929>,
 #<ApplicationRequest:0x000055c8edcf9d68 id: 4802, date: Thu, 17 Nov 2022, req_type: "http_4xx", count: 52>,
 #<ApplicationRequest:0x000055c8edcf9e30 id: 4803, date: Thu, 17 Nov 2022, req_type: "http_3xx", count: 85>,
 #<ApplicationRequest:0x000055c8edcf9f20 id: 4804, date: Thu, 17 Nov 2022, req_type: "page_view_anon", count: 40>,
 #<ApplicationRequest:0x000055c8edcf9fe8 id: 4805, date: Thu, 17 Nov 2022, req_type: "page_view_logged_in", count: 148>,
 #<ApplicationRequest:0x000055c8edcfa0d8 id: 4806, date: Thu, 17 Nov 2022, req_type: "page_view_logged_in_mobile", count: 134>,
 #<ApplicationRequest:0x000055c8edd00a00 id: 4807, date: Thu, 17 Nov 2022, req_type: "page_view_anon_mobile", count: 2>]

```

الجدول المقابل الذي تحتاجه هو `application_requests` (ولكنني لا أرى هذا معروضًا في [Data Explorer](https://meta.discourse.org/t/32566?silent=true)، ربما فاتني؟)

أنواع `req_type` في هذا التقرير هي:

```plaintext
  page_view_logged_in
  page_view_anon
  page_view_crawler

```

إنها عملية جمع وتجميع منتظمة، لذا ربما يمكنك البدء بوحدة تحكم Rails:

```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')

```

على سبيل المثال

أو ما يعادلها في SQL:

```plaintext
SELECT * FROM application_requests WHERE req_type IN (7, 8, 6) AND (date BETWEEN '11/14/2022' AND '11/17/2022')

```

تم بالفعل إجراء بعض التجميع لك لأن البيانات موجودة في عمود العد.

---

_[View the full topic](https://meta.discourse.org/t/wish-list-sql-for-canned-reports/245938)._