Is there any convenient way of knowing which action type number means? I know I can do it by hovering over the table but it would be nice to be able to actually report this way instead of having to refer back to Thanks

You can use one of these techniques to make them a more friendly read: [画像] Using VALUES or CASE to make your results more readable Data & reporting Sometimes when building a query with the data explorer you’ll find codes are used in the results rather than th…

OK, so I’m unsure how to get the “like” for 1 to appear in the data as opposed to just “1” which as you said, it’s not that useful. Is there another table other than user actions I need to join to to get this? I took a look myself and it wasn’t clear, plus I’ve already had to snip that tooltip in o…

Did you read the topic that JammyDodger linked to? It explains how to do it.

I’d been clicking in the data explorer links and just being taken to a lot of info, I hadn’t noticed the other link that had been posted so reading it now

Read it, it’s what I’d already done but didn’t know if there was a quicker way (i.e. if there was another table to easily link to instead of creating another with statement) Have marked his comment as the solution

ユーザーアクション - アクションタイプ

コミュニティデータとレポート

JammyDodger 2024 年 8 月 19 日午後 2:11 2

より読みやすくするために、これらのテクニックのいずれかを使用できます。

参考情報：

トピック		返信	表示
Using VALUES or CASE to make your results more readable Data & reporting sql-tutorial	0	441	2023 年 8 月 22 日
Documentation of the entire database Data & reporting	5	940	2023 年 7 月 24 日
Description of fields returned by Discourse API Development rest-api	5	1665	2020 年 11 月 6 日
Thanks for the intuitive UX in data explorer Praise	1	113	2024 年 9 月 13 日
Complex user activity report requirement Data & reporting sql-query	22	1895	2021 年 8 月 5 日

ユーザーアクション - アクションタイプ

関連トピック