Discourse Reactions

[Shauny (Shaun Robinson)]

Is there a way, perhaps using Data Explorer, to find things like:

• Post with the most “” reactions this year
• User who received the most “” reactions across all posts this year
• User who used the most “” reactions this year

Doing an end-of-year roundup and would love to surface some of the funniest posts of the year!

[Lilly]

FYI there is a dashboard report in your forum admin dashboard - reports:

you could work with the data explorer version too

Dashboard Report - Reactions

This is an SQL version of the Dashboard Report for Reactions. This report provides a daily count of all likes and reactions to posts across a site over a specified date range. This report helps provide a snapshot of user engagement within a Discourse community by measuring the frequency of various reaction emojis and likes on posts. By analyzing the usage of different reaction emojis, administrators can gain insights into how often users interact with content, users’ emotional responses to pos…

if you search through the Data & reporting category, you might get some ideas to work with or start from.

Usage of emojis

I’m planning to replace retort with discourse reactions. To find out which emojis to use, I wanted to know how their usage in my forum is. As I couldn’t find a query for this I share mine: Count emojis added with the retort plugin SELECT count(*), REGEXP_MATCHES(key, '([a-z_+]+)|retort') emoji FROM post_details WHERE extra = 'retort' GROUP BY key ORDER BY 1 DESC Count emojis in posts (without the system user) SELECT count(*), REGEXP_MATCHES(raw, ' :([a-z_]+): ', 'g') emoji …

[tobiaseigen]

There is also the Discourse Yearly Review plugin which you may like to try out.

[wrapper]

I installed the plugin but when I hover over the heart on my forum it doesn’t bring up the picker. However it works when long pressing on mobile. Any idea what’s going on there?

Just to add, I checked the discourse-reactions.js file and it is loading correctly into page

Thanks!

[Graemef (Graeme)]

This is the same for me on discourse 3.4.1.
If I inspect the buttons in the browser console, I can see some of the popover, but it never becomes active when hovering the like button:

The whole thing does work - if I use the API to react to any of the reaction options, it is recorded correctly, and shows the count on the post with the emoji

Seems like an issue with the UI hover. I am new to discourse plugins, so haven’t looked into it beyond this. I also tried with a different theme, and didn’t work either.

No error in js console, so I have left it for now

[nat (<b>Natalie T)]

Is your reactions plugin up to date? Also which browser? We do use reactions (always latest version) here on meta and not seeing other reports of this.

[pushrbx]

Hi @nat,

I’m experiencing the same issue in my discourse instance what @wrapper and @Graemef described. I tried both chrome and firefox latest version with no luck. I tried to compare the version here on meta with my instance’s version, and there is no difference. My discourse instance has the latest version of the plugin.
The only difference I can see that here the <div class="discourse-reactions-picker"></div> element gets the popperjs attributes (data-popper-placement), where on my instance it doesn’t get it. One more crucial detail: I’m using bitnami’s container image to run discourse. Discourse version is v3.4.2.

[nat (<b>Natalie T)]

Great thanks. I’ll let the relevant team know.

[Graemef (Graeme)]

@nat Thanks for your comment. I’m using the github url to install directly the latest version, using the steps here (actually here you can see the reaciton buttons on my site, I’m still setting up the forum)

Like @pushrbx, I too am using a Bitnami container image (on 3.4.1 though). I don’t know how it makes a difference, but maybe there is something there

I’m mainly using the api request for reactions from my main site, and that’s working fine – it shows the reactions used correctly, and the heart button is available and working at least