|
Учебник по Data Explorer — Часть 2: Основы SQL в Discourse
|
|
0
|
1292
|
05.09.2023
|
|
Запросы по умолчанию для значков
|
|
1
|
909
|
27.08.2023
|
|
Help modifying a query to return usernames, instead of user ID numbers
|
|
2
|
122
|
25.01.2018
|
|
A badge granted when someone posts a reply in a single specified topic
|
|
7
|
376
|
19.06.2018
|
|
Amount of time spent reading by Discourse groups
|
|
5
|
2377
|
11.09.2020
|
|
Еженедельная/ежемесячная/ежегодная регистрация
|
|
6
|
645
|
21.01.2024
|
|
Adding a date parameter
|
|
2
|
497
|
22.08.2023
|
|
Aggregate dashboard report data by time interval
|
|
4
|
1161
|
24.09.2022
|
|
Recreate the Discourse user’s directory
|
|
3
|
182
|
13.03.2020
|
|
Data Explorer query to show progress towards trust level 3 requirements
|
|
2
|
2963
|
29.04.2023
|
|
Users who like flagged posts
|
|
0
|
156
|
11.02.2018
|
|
Using STRING_AGG for Concise Query Results
|
|
0
|
2706
|
11.09.2023
|
|
How do I make my own badge query?
|
|
5
|
6169
|
10.10.2016
|
|
Handling Null Values with COALESCE
|
|
0
|
4461
|
13.09.2023
|
|
Active users in the last 30 days
|
|
3
|
378
|
05.09.2016
|
|
Lurkers who become members
|
|
0
|
128
|
09.09.2018
|
|
Displaying user custom fields in data explorer query results
|
|
5
|
1603
|
15.03.2020
|
|
Add username to two queries
|
|
3
|
1664
|
15.01.2023
|
|
How to enable Google Analytics
|
|
6
|
5790
|
05.09.2020
|
|
Using DATE_TRUNC for Data Aggregation
|
|
0
|
2404
|
06.09.2023
|
|
User Statistics for a particular group
|
|
0
|
112
|
18.04.2019
|
|
Отчет по панели управления — активность модераторов
|
|
6
|
677
|
27.02.2025
|
|
Creating Network Graphs
|
|
3
|
2417
|
29.04.2021
|
|
Categories and their Subcategories using OR
|
|
0
|
471
|
25.08.2023
|
|
Отчет по панели управления - Регистрация
|
|
1
|
587
|
24.12.2024
|
|
Posts per category (with deleted and without deleted)
|
|
1
|
167
|
17.07.2017
|
|
Return all non-PM topics that have not received a staff reply
|
|
0
|
233
|
17.08.2019
|
|
История заметок пользователя
|
|
0
|
364
|
13.09.2023
|
|
Few improvement ideas - grouping queries, duplicate queries
|
|
0
|
623
|
05.08.2020
|
|
Create a report of users including custom fields
|
|
0
|
1057
|
17.11.2020
|
|
Creating Custom Badges and Triggers
|
|
0
|
1672
|
08.08.2020
|
|
Time to first response for a support group
|
|
0
|
164
|
12.04.2019
|
|
Управление эффективностью модераторов
|
|
4
|
713
|
28.02.2024
|
|
Отчет по панели управления — ежедневные активные пользователи
|
|
1
|
633
|
09.12.2023
|
|
Советы по экспорту данных пользователей
|
|
0
|
271
|
26.06.2024
|
|
Who has been sending the most messages in the last week?
|
|
0
|
153
|
05.06.2017
|
|
Replicated dashboard stats
|
|
0
|
146
|
11.05.2020
|
|
Crawlers in a private forum?
|
|
2
|
815
|
16.11.2019
|
|
Is there any way of telling how popular a Theme is?
|
|
5
|
969
|
01.09.2018
|
|
'Emeritus' Badge for higher Trust Levels
|
|
0
|
125
|
27.02.2015
|
|
Number of topics per tag
|
|
2
|
1242
|
29.01.2020
|
|
How to calculate engagement rate for Discourse?
|
|
7
|
1357
|
21.12.2022
|
|
Users In Specific Group(s) BUT NOT In Other Group(s)
|
|
0
|
122
|
14.05.2019
|
|
Get list of topics pinned globally
|
|
7
|
2367
|
20.01.2022
|
|
Data Explorer averages by year?
|
|
6
|
1355
|
17.05.2020
|
|
Отчет панели управления: популярные поисковые запросы
|
|
0
|
359
|
13.12.2023
|
|
Is it possible to see the topics a user has viewed?
|
|
3
|
1761
|
21.06.2020
|
|
Is there a way to Search by Posts with No Staff replies on it
|
|
4
|
1560
|
17.08.2019
|
|
Data explorer query to return certain post notices?
|
|
5
|
423
|
19.11.2020
|
|
Отчет по когортному анализу: месячная активность пользователей по публикациям и решениям
|
|
0
|
308
|
28.03.2024
|