# User actions - action types
**URL:** https://meta.discourse.org/t/user-actions-action-types/322267
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [August 19, 2024, 2:04pm UTC](https://meta.discourse.org/t/user-actions-action-types/322267 "2024-08-19T14:04:33Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@SStrong](https://meta.discourse.org/u/SStrong)
#### Post date: [August 19, 2024, 2:04pm UTC](https://meta.discourse.org/t/user-actions-action-types/322267/1 "2024-08-19T14:04:33Z")
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
---
### Author:  [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [August 19, 2024, 2:11pm UTC](https://meta.discourse.org/t/user-actions-action-types/322267/2 "2024-08-19T14:11:19Z")
You can use one of these techniques to make them a more friendly read:
> [@Using VALUES or CASE to make your results more readable](https://meta.discourse.org/t/using-values-or-case-to-make-your-results-more-readable/276153):
>
> Sometimes when building a query with the [data explorer](https://meta.discourse.org/t/32566?silent=true) you’ll find codes are used in the results rather than their textual equivalents. The field often has a key in the [data explorer](https://meta.discourse.org/t/32566?silent=true) tree, but these don’t tend to be as useful when it comes to the results (unless you’ve managed to memorise them all slight_smile) There are a couple of things you can use to make these easier on the eye, and much more widely shareable with others. First up… VALUES This first query was created to pull up all the…
For reference:
---
### Author:  [@SStrong](https://meta.discourse.org/u/SStrong)
#### Post date: [August 20, 2024, 7:03am UTC](https://meta.discourse.org/t/user-actions-action-types/322267/3 "2024-08-20T07:03:58Z")
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 order to have some semblance of an idea behind the numbers which isn’t ideal or automated.
---
### Author:  [@RGJ](https://meta.discourse.org/u/RGJ)
#### Post date: [August 20, 2024, 7:09am UTC](https://meta.discourse.org/t/user-actions-action-types/322267/4 "2024-08-20T07:09:13Z")
Did you read the topic that JammyDodger linked to? It explains how to do it.
---
### Author:  [@SStrong](https://meta.discourse.org/u/SStrong)
#### Post date: [August 22, 2024, 7:26am UTC](https://meta.discourse.org/t/user-actions-action-types/322267/5 "2024-08-22T07:26:10Z")
I’d been clicking in the [data explorer](https://meta.discourse.org/t/32566?silent=true) 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
---
### Author:  [@SStrong](https://meta.discourse.org/u/SStrong)
#### Post date: [August 22, 2024, 7:28am UTC](https://meta.discourse.org/t/user-actions-action-types/322267/6 "2024-08-22T07:28:05Z")
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
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [September 21, 2024, 7:28am UTC](https://meta.discourse.org/t/user-actions-action-types/322267/7 "2024-09-21T07:28:10Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.