# Hot **URL:** https://meta.discourse.org/hot.md?page=1644 [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) **Page:** 1645 --- ## [Users (In Specific Group) Last Seen Since N Days Ago](https://meta.discourse.org/t/users-in-specific-group-last-seen-since-n-days-ago/275158)
**Author:** [@SvenC56](https://meta.discourse.org/u/SvenC56)\ **Replies:** 0\ **Last updated:** [May 14, 2019, 2:50pm UTC](https://meta.discourse.org/t/users-in-specific-group-last-seen-since-n-days-ago/275158 "2019-05-14T14:50:00Z")
Users (In Specific Group) Last Seen Since N Days Ago -- \[params\] -- int :member\_group -- int :days\_since\_last\_activity SELECT u.id AS user\_id, Age(u.last\_seen\_at) AS last\_seen, g.id … --- ## [Users In Specific Group(s) BUT NOT In Other Group(s)](https://meta.discourse.org/t/users-in-specific-group-s-but-not-in-other-group-s/275159)
**Author:** [@SvenC56](https://meta.discourse.org/u/SvenC56)\ **Replies:** 0\ **Last updated:** [May 14, 2019, 2:50pm UTC](https://meta.discourse.org/t/users-in-specific-group-s-but-not-in-other-group-s/275159 "2019-05-14T14:50:11Z")
Users In Specific Group(s) BUT NOT In Other Group(s) Info: The Parameters have to be written as arrays. For example: {1,2,3} -- \[params\] -- string :opt\_in\_groups -- string :opt\_out\_groups SELECT u.id AS user\_id, … --- ## [Users who posted the most X months ago & how many users in total have posted within that time period](https://meta.discourse.org/t/users-who-posted-the-most-x-months-ago-how-many-users-in-total-have-posted-within-that-time-period/275160)
**Author:** [@alexs](https://meta.discourse.org/u/alexs)\ **Replies:** 0\ **Last updated:** [July 8, 2019, 11:59am UTC](https://meta.discourse.org/t/users-who-posted-the-most-x-months-ago-how-many-users-in-total-have-posted-within-that-time-period/275160 "2019-07-08T11:59:18Z")
I’ve adapted a report to create this query to see which users have posted the most X months ago & how many users in total have posted within that time period. -- \[params\] -- int :months\_ago = 1 WITH query\_period AS ( S… --- ## [Users who’ve become active](https://meta.discourse.org/t/users-who-ve-become-active/275161)
**Author:** [@alexs](https://meta.discourse.org/u/alexs)\ **Replies:** 0\ **Last updated:** [July 12, 2019, 9:43am UTC](https://meta.discourse.org/t/users-who-ve-become-active/275161 "2019-07-12T09:43:59Z")
With a bit of help from a developer (@aluxian), I’ve adapted one to calculate what % of users, who joined within a certain timeframe, have posted X times, within a certain timeframe. You could use this to see whether yo… --- ## [Group Visit Activity](https://meta.discourse.org/t/group-visit-activity/275162)
**Author:** [@dstodgel](https://meta.discourse.org/u/dstodgel)\ **Replies:** 3\ **Last updated:** [October 22, 2019, 11:05pm UTC](https://meta.discourse.org/t/group-visit-activity/275162 "2019-10-22T23:05:08Z")
Group Visit Activity I have been working on queries that look at activity by groups. Unique visitors Total Visits Mobile versus Desktop Visits Percent of Group Membership Visiting Avg Read Time per Visit Avg Posts Read… --- ## [Return all non-PM topics that have not received a staff reply](https://meta.discourse.org/t/return-all-non-pm-topics-that-have-not-received-a-staff-reply/275165)
**Author:** [@tshenry](https://meta.discourse.org/u/tshenry)\ **Replies:** 0\ **Last updated:** [August 17, 2019, 12:14am UTC](https://meta.discourse.org/t/return-all-non-pm-topics-that-have-not-received-a-staff-reply/275165 "2019-08-17T00:14:29Z")
Here’s one that should return all non-PM topics that have not received a staff reply: SELECT t.id topic\_id, category\_id FROM topics t WHERE t.deleted\_at IS NULL AND t.category\_id IS NOT NULL AND t.id NOT IN ( SE… --- ## [Category lurkers](https://meta.discourse.org/t/category-lurkers/275166)
**Author:** [@xav](https://meta.discourse.org/u/xav)\ **Replies:** 0\ **Last updated:** [February 28, 2020, 1:25pm UTC](https://meta.discourse.org/t/category-lurkers/275166 "2020-02-28T13:25:47Z")
Category lurkers: See for a category (or all categories by default) the users’ notification level. rationale: we use categories for “working groups” that everyone can “join” (track or watch). Therefore, a working group… --- ## [Daily, weekly, or total stats by user over a specified time range](https://meta.discourse.org/t/daily-weekly-or-total-stats-by-user-over-a-specified-time-range/275167)
**Author:** [@Grayden\_Shand](https://meta.discourse.org/u/Grayden_Shand)\ **Replies:** 0\ **Last updated:** [December 31, 2019, 8:08pm UTC](https://meta.discourse.org/t/daily-weekly-or-total-stats-by-user-over-a-specified-time-range/275167 "2019-12-31T20:08:57Z")
\-- coverage: 'week', 'all', or 'date' -- \[params\] -- date :start\_date = 2019-08-27 -- date :end\_date = 2019-09-30 -- text :coverage = week WITH date\_range AS ( SELECT date\_trunc('day', dd):: date AS "date", EXTRACT(week… --- ## [Absence of Staff Notes in a particular category](https://meta.discourse.org/t/absence-of-staff-notes-in-a-particular-category/275168)
**Author:** [@meglio](https://meta.discourse.org/u/meglio)\ **Replies:** 0\ **Last updated:** [August 30, 2016, 5:57pm UTC](https://meta.discourse.org/t/absence-of-staff-notes-in-a-particular-category/275168 "2016-08-30T17:57:30Z")
Here is a use-case I solved with the query you’ll find below. I have a special category where users create their “personal pages” (for their goat farms). Now we’re creating a map with all these farms placed on it. Once… --- ## [Replicated dashboard stats](https://meta.discourse.org/t/replicated-dashboard-stats/275169)
**Author:** [@mbauman](https://meta.discourse.org/u/mbauman)\ **Replies:** 0\ **Last updated:** [May 11, 2020, 4:15pm UTC](https://meta.discourse.org/t/replicated-dashboard-stats/275169 "2020-05-11T16:15:18Z")
These aren’t very “cool” — they’re just replications of some of stats from the admin report dashboard — but I’ve found them helpful to provide access to non-admin users: SELECT a.date, a.users, b.posts, … --- ## [Number of posts by top-level category and user](https://meta.discourse.org/t/number-of-posts-by-top-level-category-and-user/275170)
**Author:** [@tanius](https://meta.discourse.org/u/tanius)\ **Replies:** 0\ **Last updated:** [March 27, 2020, 4:35pm UTC](https://meta.discourse.org/t/number-of-posts-by-top-level-category-and-user/275170 "2020-03-27T16:35:00Z")
Number of posts by top-level category and user For each top-level category, a list of the users who contributed to it and the number of posts they contributed. Posts include both the topic-starter posts and the comments … --- ## [Views by top-level category](https://meta.discourse.org/t/views-by-top-level-category/275172)
**Author:** [@tanius](https://meta.discourse.org/u/tanius)\ **Replies:** 0\ **Last updated:** [March 27, 2020, 4:45pm UTC](https://meta.discourse.org/t/views-by-top-level-category/275172 "2020-03-27T16:45:00Z")
Views by top-level category Including grand total of all topic views on your forum since the very beginning. /\* Outer SELECT to hide the artificial sort order column, and sort by it. \*/ SELECT "Category", "Views" FROM … --- ## [Views by sub-level category](https://meta.discourse.org/t/views-by-sub-level-category/275173)
**Author:** [@tanius](https://meta.discourse.org/u/tanius)\ **Replies:** 0\ **Last updated:** [March 27, 2020, 4:35pm UTC](https://meta.discourse.org/t/views-by-sub-level-category/275173 "2020-03-27T16:35:30Z")
Views by sub-level category A more granular analysis of topic views, but without summing them up. Entries with sub-category “(none)” relate to topics placed directly into the top-level categories. SELECT topcat AS … --- ## [User Statistics for a particular group](https://meta.discourse.org/t/user-statistics-for-a-particular-group/275174)
**Author:** [@DNSTARS](https://meta.discourse.org/u/DNSTARS)\ **Replies:** 0\ **Last updated:** [April 18, 2019, 11:33am UTC](https://meta.discourse.org/t/user-statistics-for-a-particular-group/275174 "2019-04-18T11:33:44Z")
Got this sorted promptly with the professional talent of @pfaffman, our thanks to him. The script I’ll turn over for the community. They way we will be using it is by letting in 100 registrants or so, locking public acce… --- ## [Install discourse doc plugin from Git is failed](https://meta.discourse.org/t/install-discourse-doc-plugin-from-git-is-failed/275195)
**Author:** [@roamerlnn](https://meta.discourse.org/u/roamerlnn)\ **Replies:** 2\ **Last updated:** [August 15, 2023, 7:15am UTC](https://meta.discourse.org/t/install-discourse-doc-plugin-from-git-is-failed/275195 "2023-08-15T07:15:39Z")
Hi, I tried to install Discourse Docs plugin from Git.But it was failed with the following promp.Any help will be much appreciated.Thank you --- ## [Endless Loading dots animation on Meta](https://meta.discourse.org/t/endless-loading-dots-animation-on-meta/275200)
**Author:** [@Ed\_S](https://meta.discourse.org/u/Ed_S)\ **Replies:** 3\ **Last updated:** [August 15, 2023, 5:54pm UTC](https://meta.discourse.org/t/endless-loading-dots-animation-on-meta/275200 "2023-08-15T17:54:43Z")
The meta front page failed to load for me just now - first visit today - was stuck on the animated dots. I opened a second tab which did load OK. But just in case it’s an important case, here’s what I saw in the console… --- ## [How can I hide the "all categories" selection bar on the front page?](https://meta.discourse.org/t/how-can-i-hide-the-all-categories-selection-bar-on-the-front-page/275202)
**Author:** [@Ellery](https://meta.discourse.org/u/Ellery)\ **Replies:** 4\ **Last updated:** [August 16, 2023, 6:32am UTC](https://meta.discourse.org/t/how-can-i-hide-the-all-categories-selection-bar-on-the-front-page/275202 "2023-08-16T06:32:24Z")
I understand that by adjusting the “tagging enabled” option, I can hide the “all tags” section shown in the image below. However, I’m also looking for a solution to hide the “all categories” section. Is there a way t… --- ## [Discourse AI - AI Bot - a glimpse of capabilities](https://meta.discourse.org/t/discourse-ai-ai-bot-a-glimpse-of-capabilities/275206)
**Author:** [@EricGT](https://meta.discourse.org/u/EricGT)\ **Replies:** 4\ **Last updated:** [November 22, 2023, 11:11pm UTC](https://meta.discourse.org/t/discourse-ai-ai-bot-a-glimpse-of-capabilities/275206 "2023-11-22T23:11:52Z")
This is an extremely basic example, glimpse, of using the Discourse AI - AI Bot for those who have not seen it; this answered and resolved a few key questions I did not know about the AI Bot. Start a chat with the Disc… --- ## [How to remove the "Getting Started" button on header](https://meta.discourse.org/t/how-to-remove-the-getting-started-button-on-header/275214)
**Author:** [@tggm](https://meta.discourse.org/u/tggm)\ **Replies:** 13\ **Last updated:** [August 23, 2023, 3:51pm UTC](https://meta.discourse.org/t/how-to-remove-the-getting-started-button-on-header/275214 "2023-08-23T15:51:21Z")
Hello, After some update I now got a “Getting Started” button on the top header, which was surprising since the site is more than a year old: How do I get rid of this? It points to an article with generic instructio… --- ## [Migration from discourse v2.8.13 (on Ubuntu 20.04.6 LTS) to latest](https://meta.discourse.org/t/migration-from-discourse-v2-8-13-on-ubuntu-20-04-6-lts-to-latest/275217)
**Author:** [@CamilleRoux](https://meta.discourse.org/u/CamilleRoux)\ **Replies:** 3\ **Last updated:** [August 15, 2023, 1:13pm UTC](https://meta.discourse.org/t/migration-from-discourse-v2-8-13-on-ubuntu-20-04-6-lts-to-latest/275217 "2023-08-15T13:13:01Z")
Hi, I’ve currently discourse v2.8.13 running on Ubuntu 20.04.6 LTS (on Digital Ocean). It’s an install with a web\_only and data containers. What’s the simplest strategy for this upgrade? Context Update via Admin or la… --- ## [How to see exact link of ‘top referred topics’](https://meta.discourse.org/t/how-to-see-exact-link-of-top-referred-topics/275250)
**Author:** [@kynic](https://meta.discourse.org/u/kynic)\ **Replies:** 5\ **Last updated:** [September 29, 2023, 2:59pm UTC](https://meta.discourse.org/t/how-to-see-exact-link-of-top-referred-topics/275250 "2023-09-29T14:59:48Z")
Hi, I want to see the exact link of the topic post that has been shared which appears in "‘top referred topics’ "Can anyone guide me on how to see this data in the data explorer? --- ## [Moving up the translator icon](https://meta.discourse.org/t/moving-up-the-translator-icon/275274)
**Author:** [@satonotdead](https://meta.discourse.org/u/satonotdead)\ **Replies:** 0\ **Last updated:** [August 15, 2023, 7:24pm UTC](https://meta.discourse.org/t/moving-up-the-translator-icon/275274 "2023-08-15T19:24:48Z")
Discourse Translator give us the possibility to translate messages and posts on-the-go and that’s awesome for multilingual communities! I think that usage of the plugin could be really improved with a minor UX adjustmen… --- ## [Discourse in the Public Sector?](https://meta.discourse.org/t/discourse-in-the-public-sector/275301)
**Author:** [@maiki](https://meta.discourse.org/u/maiki)\ **Replies:** 18\ **Last updated:** [August 21, 2023, 6:32pm UTC](https://meta.discourse.org/t/discourse-in-the-public-sector/275301 "2023-08-21T18:32:52Z")
Heya folks! :wave: I’ve been digging around to see how Discourse is being used across different sectors and I’ve hit a bit of a roadblock. I’m really curious to know if Discourse is being used in the public sector, like… --- ## [Embedding of post is not being properly truncated in discourse-ai plugin](https://meta.discourse.org/t/embedding-of-post-is-not-being-properly-truncated-in-discourse-ai-plugin/275344)
**Author:** [@redrum](https://meta.discourse.org/u/redrum)\ **Replies:** 4\ **Last updated:** [August 17, 2023, 1:14am UTC](https://meta.discourse.org/t/embedding-of-post-is-not-being-properly-truncated-in-discourse-ai-plugin/275344 "2023-08-17T01:14:54Z")
When I use the OpenAI ADA text embedding model for related posts matching, I get the following error: OpenAI Embeddings failed with status: 400 body: { "error": { "message": "This model's maximum context length is 8191 … --- ## [FYI "Using GPT-4 for content moderation" - An OpenAI blog entry](https://meta.discourse.org/t/fyi-using-gpt-4-for-content-moderation-an-openai-blog-entry/275349)
**Author:** [@EricGT](https://meta.discourse.org/u/EricGT)\ **Replies:** 15\ **Last updated:** [August 30, 2023, 12:05pm UTC](https://meta.discourse.org/t/fyi-using-gpt-4-for-content-moderation-an-openai-blog-entry/275349 "2023-08-30T12:05:02Z")
https://openai.com/blog/using-gpt-4-for-content-moderation From reply below The blog talks about how GPT4 is being trained to act as a moderator for internet content based on policies. This applies directly to Disco… --- ## [Handling CORS Issues in Fetch API](https://meta.discourse.org/t/handling-cors-issues-in-fetch-api/275350)
**Author:** [@vish234](https://meta.discourse.org/u/vish234)\ **Replies:** 0\ **Last updated:** [August 16, 2023, 8:18am UTC](https://meta.discourse.org/t/handling-cors-issues-in-fetch-api/275350 "2023-08-16T08:18:52Z")
I’m working on a web development project where I’m using the Fetch API to make cross-origin requests to a different domain. However, I’m running into CORS (Cross-Origin Resource Sharing) issues, and my requests are being… --- ## [How can I enable the "Invite" function for all posts?](https://meta.discourse.org/t/how-can-i-enable-the-invite-function-for-all-posts/275358)
**Author:** [@Ellery](https://meta.discourse.org/u/Ellery)\ **Replies:** 1\ **Last updated:** [October 4, 2023, 12:42pm UTC](https://meta.discourse.org/t/how-can-i-enable-the-invite-function-for-all-posts/275358 "2023-10-04T12:42:37Z")
At the bottom of each post, there is a “Share” button: I have two questions regarding this feature: Why do certain posts in my forum have an “Invite” button when clicking this “Share” button, while others do not? … --- ## [Integration of https://signal.org/ chat](https://meta.discourse.org/t/integration-of-https-signal-org-chat/275363)
**Author:** [@Thomas\_Rother](https://meta.discourse.org/u/Thomas_Rother)\ **Replies:** 8\ **Last updated:** [November 23, 2023, 10:55pm UTC](https://meta.discourse.org/t/integration-of-https-signal-org-chat/275363 "2023-11-23T22:55:09Z")
Concerning the chat integration plugin at https://github.com/discourse/discourse-chat-integration Are there any plans to add notifications from signal chats? I have a number of smaller communities who currently work w… --- ## [Question about Community Health Statistics](https://meta.discourse.org/t/question-about-community-health-statistics/275377)
**Author:** [@LxmasWasntHere](https://meta.discourse.org/u/LxmasWasntHere)\ **Replies:** 1\ **Last updated:** [August 16, 2023, 12:48pm UTC](https://meta.discourse.org/t/question-about-community-health-statistics/275377 "2023-08-16T12:48:31Z")
I’ve been a admin lately on a forum and i got into the admin pages. I saw these “Anonymous Users” and “Crawlers” on our community health statics. I don’t know what these “Anonymous users” and “Crawlers” mean. Anyone kn… --- ## [Do I need to install on a subdomain?](https://meta.discourse.org/t/do-i-need-to-install-on-a-subdomain/275378)
**Author:** [@TDJS95](https://meta.discourse.org/u/TDJS95)\ **Replies:** 3\ **Last updated:** [August 16, 2023, 5:17pm UTC](https://meta.discourse.org/t/do-i-need-to-install-on-a-subdomain/275378 "2023-08-16T17:17:57Z")
Sorry if this question sounds stupid but I am new to this forum. Do I have to install it as a subdomain (discourse.domain.com) [Previous page](https://meta.discourse.org/hot.md?page=1643) [Next page](https://meta.discourse.org/hot.md?page=1645)