I run discourse in a corporate environment as an order and documentation system. I use tags to choose whether an order (topic) is ongoing or completed. But I would need a way to identify orders that are completed in Mars, for example. Don’t feel like I want to use a tag for every month, eg tag: Mar…

[صورة] user2: Are there any other plugins or ways to do this? If you have admin privileges you could use the data explorer plugin. [صورة] Discourse Data Explorer Plugin plugin discourse2 Summary Discourse Data Explorer allows you to make SQL queries against your li…

Thanks, good suggestion but I am not so familiar with database inquiries so do not know if I even know where to start with it. Can anyone use / view the results of a request through data explorer in any way? Would be good if everyone could sort out examples delivered things in March easily and not j…

[صورة] user2: if I even know where to start Here is a starting point. -- [params] -- int :months_ago = 1 WITH query_period AS (SELECT date_trunc('month', CURRENT_DATE) - INTERVAL ':months_ago months' AS period_start, date_trunc('month', CU…

[صورة] user2: Would be good if everyone could sort out examples delivered things in March easily and not just administrators. You could run a cron job at the start of each month to get the results and then create a new topic … ‘Orders Completed in March 2019’ with links to each result in the …

ابحث عن المنشورات "المحلولّة" في شهر محدد

مجتمع البيانات والتقارير

csmu (Keith John Hutchison - Ceiteach Seán Mac Úistin) 28 مارس 2019، 10:44ص 2

If you have admin privileges you could use the data explorer plugin.

إعجابَين (2)

الموضوع		الردود	مرات العرض
Selecting the Quarter results in custom way Support	5	695	1 أكتوبر 2022
Topics solved by staff (lists topics) Data & reporting sql-query , solved	0	171	12 فبراير 2018
Accepted Solutions Query Data & reporting sql-query , reporting	2	114	3 يوليو 2025
Topics solved by regular users (lists topics) Data & reporting sql-query , solved	0	175	12 فبراير 2018
Calculate total participation moments by month using Data Explorer Data & reporting sql-query	13	1368	27 مارس 2021

ابحث عن المنشورات "المحلولّة" في شهر محدد

الموضوعات ذات الصلة