# Difference between reply and response in user\_actions

**URL:** https://meta.discourse.org/t/difference-between-reply-and-response-in-user-actions/266531
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [May 29, 2023, 2:25pm UTC](https://meta.discourse.org/t/difference-between-reply-and-response-in-user-actions/266531 "2023-05-29T14:25:39Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![gassim](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/gassim/32/220910_2.png) [@gassim](https://meta.discourse.org/u/gassim)
#### Post date: [May 29, 2023, 2:25pm UTC](https://meta.discourse.org/t/difference-between-reply-and-response-in-user-actions/266531/1 "2023-05-29T14:25:39Z")

</div>

In the user\_actions table, two of the action\_types are ‘reply’ and ‘response.’ Does anyone know the exact difference?

You can find these by running a SQL query in the [Data Explorer](https://meta.discourse.org/t/32566?silent=true):

> SELECT \* FROM user\_actions  
> WHERE ((action\_type = 5) OR (action\_type = 6 ))  
> `/*AND target_topic_id = if-you-want-to-make-it-easier*/`

Thanks!

---

<div class="post-metadata">

### Author: ![gassim](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/gassim/32/220910_2.png) [@gassim](https://meta.discourse.org/u/gassim)
#### Post date: [May 29, 2023, 2:40pm UTC](https://meta.discourse.org/t/difference-between-reply-and-response-in-user-actions/266531/2 "2023-05-29T14:40:07Z")

</div>

I continued to do some testing and found that every post in a topic thread by a user other than the OP is considered a ‘response’ whereas a reply could be by the same OP! In other words, ‘response’ can be used to differentiate between posts that are by the same user who posted the topic and replies by other users.

It’s clear now, thanks!

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [June 28, 2023, 2:40pm UTC](https://meta.discourse.org/t/difference-between-reply-and-response-in-user-actions/266531/3 "2023-06-28T14:40:45Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
