I have a few ideas for badges but I’m unsure how to write the queries (I don’t know the table structure well enough). The numbers are just to use as a base. I’ll be extending them for additional badges. Someone got 10 votes on a single topic they wrote Someone got 20 votes total between all topi…

[صورة] Marc_Montecalvo: Someone voted 20 times The second query in this topic might do the trick: Badge ideas for Topic Voting . The query grants the badge to users who have cast a single vote, but there is a suggestion at the bottom of the query for how to require more votes to grant the badg…

Thanks @simon . I actually read over that post already but the query didn’t return the results I was expecting. It was the Limit 1 at the end messing me up. After removing that it works perfect for the “Someone voted x times”. Any idea how to see how many votes a person got on a topic they wrote?…

[صورة] Marc_Montecalvo: Any idea how to see how many votes a person got on a topic they wrote? Or how many likes they got total? You might find some Data Explorer queries that you can modify to create badge queries. Have a look at the data explorer queries for topic voting and other sql-query …

[صورة] Marc_Montecalvo: Anyone already have some badges like this and want to share? Aren’t these rather similar to badges that already exist in Discourse?

That got me quite a ways towards my target: select t.user_id, ucf.value, count(*) from topics t join user_custom_fields ucf on t.id = cast(ucf.value as int) where ucf.name = 'votes' group by ucf.value, t.user_id order by t.user_id, count(*) desc That returns: [image] The…

I think I got it! This will give the topic with the most votes per person that has at least 5 votes on it: WITH query as ( select t.user_id, ucf.value, count(*) as num, t.created_at, row_number() OVER (PARTITION BY t.user_id order by count(*) desc) as rank from topics t…

أبحث عن شارات جيدة تتعلق بالتصويت

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

simon 26 أبريل 2019، 6:55م 4

قد تجد بعض استعلامات Data Explorer التي يمكنك تعديلها لإنشاء استعلامات للشارات. اطلع على استعلامات Data Explorer للتصويت على المواضيع والمواضيع الأخرى sql-query و sql-triggered-badge.

الموضوع		الردود	مرات العرض
Badge ideas for Topic Voting Feature badges , topic-voting , sql-triggered-badge	0	1851	24 يونيو 2016
Make a badge for the answer with the most likes in a topic! Data & reporting sql-triggered-badge	4	3352	29 مارس 2016
Badge query for topic views Data & reporting sql-triggered-badge	4	589	25 يونيو 2022
Badges for reading [ :warning: intensive] Data & reporting sql-triggered-badge	5	276	7 أغسطس 2015
Badge for poll vote + topic post with min post likes? Data & reporting polls , sql-triggered-badge	0	182	13 أغسطس 2019

أبحث عن شارات جيدة تتعلق بالتصويت

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