I want to create a custom badge in which these rules will be added, which simply means that when user accomplish these below things then the particular related badge will be given to them automatically. Users need to accomplish these below things/Rules - User should have created at least 2 posts U…

May it help? [图片] Enable Badge SQL Self-Hosting bookmark This guide explains how to enable Badge SQL in Discourse and discusses the associated security and performance risks. person_raising_hand Required user level: Administrator warning Enabling Badge SQL c…

hey, this is really helpful. I have enabled the SQL queries option, just stuck with a small thing after that I am good to go. How to view the database because my custom badge rule is complex so that is why I need few things - How to view the database, so that I can build my own query How to test…

The easiest way is to install the discourse-data-explorer plugin, which will provide an interface like this. [image] [image]

I have installed the plugin and made the below SQL command which is giving me the users who are fulfilling these 3 rules but I don’t know how to convert it into a trigger when an user acts on the post. SQL command - select users.username, user_stats.user_id from user_stats Inner Join users ON user…

This is a SQL code of “Trigger: Update daily”; SELECT st.user_id user_id, current_timestamp granted_at FROM user_stats st JOIN users u ON st.user_id = u.id WHERE st.post_count >= 2 AND st.likes_given >= 1 AND u.uploaded_avatar_id > 0 The other triggers depend on something specific, and I don’t rec…

Thank you so much for this, just having three basic questions - What is st and u table and what is the use of both this table and why these tables are not visible in the explorer plugin tab When this trigger update daily will run, to be specific I am asking about time. What is the use of Ru…

With regards to 1?, those are table alias names. Do you see the FROM user_stats st line? That’s telling the query that st is short for the user_stats table The same is true in JOIN statement where it says users u. It is saying that in query u is an alias for the users table in that query. Aliases …

Thanks for clarifying my doubts, now just the second point is remaining When this trigger update daily will run, to be specific I am asking about time.

Whoops. Thought I answered that. The query runs every 24 hours based on what time of day you started the container. So I have one instance that runs it around 0:00UTC (roughly) and another instance runs it a little after 6:00 UTC

Can we change the timings at which this query will run or can we modify this query to Trigger: when user acts on a posts or when user edits or creates a post? If possible kindly change the query as I am new to this discourse system if you can help me out once then from next time I can build my own …

创建带有自定义规则的自定义徽章

社区数据与报告

Lhc_fl (Linca) 2023 年3 月 10 日 15:01 2

这有帮助吗？

话题		回复	浏览量
Badge collection examples Community Building sql-triggered-badge	5	2307	2015 年3 月 18 日
How do I make my own badge query? Data & reporting sql-triggered-badge	4	6208	2016 年10 月 1 日
"Trigger" text field not showing up when creating custom badge Support	3	1543	2016 年9 月 19 日
Creating triggered custom badge queries Site Management badges , how-to , sql-triggered-badge	0	12915	2014 年8 月 27 日
Where do I need to enter my Badge Query? Support sql-triggered-badge	1	1059	2019 年11 月 18 日

创建带有自定义规则的自定义徽章

相关话题