# Add badge for adding profile picture

**URL:** https://meta.discourse.org/t/add-badge-for-adding-profile-picture/386741
**Category:** Support
**Tags:** badges, sql-triggered-badge
**Created:** [October 25, 2025, 9:13pm UTC](https://meta.discourse.org/t/add-badge-for-adding-profile-picture/386741 "2025-10-25T21:13:57Z")
**Posts on this page:** 1
**Showing post:** 6

<div class="post-metadata">

### Author: ![Moin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/moin/32/554653_2.png) [@Moin](https://meta.discourse.org/u/Moin)
#### Post date: [October 25, 2025, 11:43pm UTC](https://meta.discourse.org/t/add-badge-for-adding-profile-picture/386741/6 "2025-10-25T23:43:11Z")

</div>

Firstly, it was a hint that there is already a badge that can be triggered when uploading an avatar. So if you want to add your own [SQL-triggered badge](https://meta.discourse.org/t/creating-triggered-custom-badge-queries/19336), you might want to disable it so that the user doesn’t receive two at once. Secondly, you can use the query for the badge as an example to create a badge just for saving the avatar.

> [@The default badge queries](https://meta.discourse.org/t/the-default-badge-queries/276812/1):
>
> ### 🥉 Autobiographer
> 
> ```plaintext
> SELECT u.id user_id, CURRENT_TIMESTAMP granted_at
> FROM users u
> JOIN user_profiles up on u.id = up.user_id
> WHERE bio_raw IS NOT NULL AND LENGTH(TRIM(bio_raw)) > 10 AND
> uploaded_avatar_id IS NOT NULL AND
> (:backfill OR u.id IN (:user_ids) )
> 
> ```
> 
> | | |
> | --- | --- |
> | Run revocation query daily | ✅ |
> | Query targets posts | |
> | Trigger | When a user is edited or created |

---

_[View the full topic](https://meta.discourse.org/t/add-badge-for-adding-profile-picture/386741)._
