# 'Reply by email' badge

**URL:** https://meta.discourse.org/t/reply-by-email-badge/276733
**Category:** Data & reporting
**Tags:** sql-triggered-badge
**Created:** [May 12, 2016, 3:13pm UTC](https://meta.discourse.org/t/reply-by-email-badge/276733 "2016-05-12T15:13:42Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![lrossouw](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/lrossouw/32/121275_2.png) [@lrossouw](https://meta.discourse.org/u/lrossouw)
#### Post date: [May 12, 2016, 3:13pm UTC](https://meta.discourse.org/t/reply-by-email-badge/276733/1 "2016-05-12T15:13:42Z")

</div>

Anyone done a reply by email badge?

---

<div class="post-metadata">

### Author: ![stevenpslade](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/stevenpslade/32/53550_2.png) [@stevenpslade](https://meta.discourse.org/u/stevenpslade)
#### Post date: [May 12, 2016, 6:18pm UTC](https://meta.discourse.org/t/reply-by-email-badge/276733/2 "2016-05-12T18:18:27Z")

</div>

I’m not too sure, but it shouldn’t be too hard considering the `Post` table has `via_email` `boolean`. Find Posts where `via_email` is `true` and get the `user_id` of that post!

---

<div class="post-metadata">

### Author: ![lrossouw](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/lrossouw/32/121275_2.png) [@lrossouw](https://meta.discourse.org/u/lrossouw)
#### Post date: [May 16, 2016, 11:15am UTC](https://meta.discourse.org/t/reply-by-email-badge/276733/3 "2016-05-16T11:15:05Z")

</div>

Here is a **Reply by Email** Badge:

```psql
select
    p.user_id
    ,min(p.created_at) granted_at
    ,min(p.id) post_id
from badge_posts p
where
    (:backfill or p.id IN (:post_ids) ) 
    and p.post_number >1
    and p.via_email=True
group by 
    p.user_id

```

 ![](https://global.discourse-cdn.com/meta/original/3X/9/d/9da5e4da37b8f8e1e8ad380ae19a265e97e7a826.png)

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [May 17, 2016, 8:06am UTC](https://meta.discourse.org/t/reply-by-email-badge/276733/4 "2016-05-17T08:06:37Z")

</div>

That is a great idea for a badge, we should add it for our next release (adding it to the list)

---

<div class="post-metadata">

### Author: ![lrossouw](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/lrossouw/32/121275_2.png) [@lrossouw](https://meta.discourse.org/u/lrossouw)
#### Post date: [May 17, 2016, 8:33am UTC](https://meta.discourse.org/t/reply-by-email-badge/276733/5 "2016-05-17T08:33:46Z")

</div>

Could also do a topic created via email badge (but I haven’t activated that functionality).  
Probably something like:

```psql
select
    p.user_id
    ,min(p.created_at) granted_at
    ,min(p.id) post_id
from badge_posts p
where
    (:backfill or p.id IN (:post_ids) ) 
    and p.post_number =1
    and p.via_email=True
group by 
    p.user_id

```