The title might be a bit cryptic, but the context is to convert a category to “private” but have a way to identify all users that participated in it in the past <timeframe> and add them to a group so that it can be set as having access. Let’s say the group can be created prior to this. What is cur…

[图片] Crius: but that only means adding a further step Yeah, it would be a little more convoluted doing it that way. But if you have a shortish list you can export the explorer results as a CSV, open up in notepad, and copy&paste them into the Add Users box: [results in notepad] [paste int…

[图片] Crius: identify all users that participated in it in the past I’ve used a Data Explorer query to figure out who participated in a topic based on user_actions: -- [params] -- int :topic = 3620561 select user_id, sum(action_type) actions, sum(case action_type when 5 then…

Thank you @jericson , this is exactly what I was looking for. I am guessing that I could feed the results to a query that adds all users to a group then. Is there anyone that have had experience doing that? Maybe it’s better to brutally copy-paste the user ids and run a ruby function if there is so…

[图片] Crius: Maybe it’s better to brutally copy-paste the user ids and run a ruby function That’s usually my preferred solution. But it probably makes more sense to pull a page from the bulk operations examples and apply the where clause on the User object in rails. (Having a test environment …

Depending how many there are, you can paste a comma separated list into the Add Users to the group box, if that’s any use? (There’s also an Automation to add users to a group based on a badge, which you could use this SQL as a base for. That might be a little convoluted if you’re happy with the Rai…

[图片] Jon Ericson: Having a test environment for a time like this helps! Just brought the staging environment app for this reason (and also testing what breaks with ember 5 :stuck_out_tongue: ) I’ll dig into it in the next few days, “real job” allowing me the time :smiley:

Just to leave the query completed in case others need it: select ua.user_id, u.username, sum(action_type) actions, sum(case action_type when 5 then 1 else 0 end) replies from user_actions ua join users u on u.id = ua.user_id join topics t on target_topic_id = t.id where ua.created_at > 'YYYY-MM-DD…

Can you point me to that script @JammyDodger ? I can’t see it in the link pasted by @jericson I can extract a list of users (it will be around 250).

The options I suggested are available in the UI, though the second one needs the Discourse Automation plugin (it’s a good plugin though :slight_smile:)

I am sorry but I don’t understand how that could help me. [image] I have a list of user IDs (or usernames even) and I need to add them to a group. I don’t see in the current automations a use case that could help me. There is only adding to group based on badges or custom field but that only mea…

Worked perfectly, I forgot you could add multiple usernames to the UI :slight_smile: For others, to export the psql query result simply run: psql \o /home/discourse/output.txt <your query here> \o exit Now in /home/discourse/output.txt you will have the result of the query as it would be printed …

将类别设为私有并添加用户至特定访问组

产品支持

Crius (Crius) 2024 年1 月 8 日 16:57 6

我正是为此（以及测试 Ember 5 会破坏什么）才把预演环境应用上线。

在接下来的几天里，我会深入研究一下，前提是我的“正经工作”能给我留出时间

话题		回复	浏览量
Is it possible to export users who were active in certain category? Product Support	1	2094	2019 年4 月 1 日
User-posted code blocks in a category Data & reporting sql-query	3	365	2024 年5 月 13 日
Add users to topic in private category Feature	15	6909	2015 年2 月 24 日
Allow users with access to a restricted category to see who else has access Feature	18	1679	2026 年2 月 16 日
PAID Data explorer challenge: chronological list of user topics started, replied and liked Marketplace sql-query	6	3410	2016 年8 月 4 日

将类别设为私有并添加用户至特定访问组

相关话题