# Where is Solved data stored in the database?

**URL:** https://meta.discourse.org/t/where-is-solved-data-stored-in-the-database/294683
**Category:** Support
**Tags:** solved
**Created:** [February 8, 2024, 1:10pm UTC](https://meta.discourse.org/t/where-is-solved-data-stored-in-the-database/294683 "2024-02-08T13:10:01Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Naveenkumar](https://avatars.discourse-cdn.com/v4/letter/n/bbce88/32.png) [@Naveenkumar](https://meta.discourse.org/u/Naveenkumar)
#### Post date: [February 8, 2024, 1:10pm UTC](https://meta.discourse.org/t/where-is-solved-data-stored-in-the-database/294683/1 "2024-02-08T13:10:01Z")

</div>

If i install any plugins in my discourse, will the Database columns get updated?  
I don’t find any answered/resolved column in the topics table.  
If I want to mark a Topic as answered I need to install a plugin.

---

<div class="post-metadata">

### Author: ![merefield](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/merefield/32/176214_2.png) [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [February 8, 2024, 1:11pm UTC](https://meta.discourse.org/t/where-is-solved-data-stored-in-the-database/294683/2 "2024-02-08T13:11:04Z")

</div>

It depends on the plugin.

Some plugins change the schema and add tables, others might use “Custom Fields” to persist data.

---

<div class="post-metadata">

### Author: ![Heliosurge](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/heliosurge/32/571810_2.png) [@Heliosurge](https://meta.discourse.org/u/Heliosurge)
#### Post date: [February 9, 2024, 2:18am UTC](https://meta.discourse.org/t/where-is-solved-data-stored-in-the-database/294683/3 "2024-02-09T02:18:31Z")

</div>

Can you give a use case? Your request is too vague.

> [@Unanswered Filter](https://meta.discourse.org/t/unanswered-filter/126257):
>
> discourse2Summary Unanswered Filter adds a breadcrumb dropdown that filters a topic list by unanswered and answered topics.eyeglassesPreview [Preview on Discourse Theme Creator](https://discourse.theme-creator.io/theme/Discourse/unanswered-filter)hammer_and_wrenchRepository Link [https://github.com/discourse/discourse-unanswered-filter](https://github.com/discourse/discourse-unanswered-filter)open_bookNew to Discourse Themes? [Beginner’s guide to using Discourse Themes](https://meta.discourse.org/t/beginners-guide-to-using-discourse-themes/91966) Install this theme component Features Unanswered Filter adds a new breadcrumb dropdown that allows users to filter a t…

This theme component gives some options that maybe of use.

There are also components that compliment plugins like Solved Plugin and Docs plugin .

There are a variety of #Customization > Theme component that change what is listed by adding or removing columns.

What are you looking to have discourse do?

---

<div class="post-metadata">

### Author: ![Naveenkumar](https://avatars.discourse-cdn.com/v4/letter/n/bbce88/32.png) [@Naveenkumar](https://meta.discourse.org/u/Naveenkumar)
#### Post date: [February 9, 2024, 10:13am UTC](https://meta.discourse.org/t/where-is-solved-data-stored-in-the-database/294683/4 "2024-02-09T10:13:13Z")

</div>

Hi @Heliosurge  
I tried to upload an .png image explain my situation, but i can’t upload it. I’ll try to explain it.

In each Topics conversation you can see an option to mark a post as “Solution”, this is not a default feature of Discourse it seems. Need to install an plugin to enable it.  
My Question is, I didn’t saw any Database column related to mark a post as Solution. Any new table will be created in DB, if I add a plugin?

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [February 9, 2024, 1:20pm UTC](https://meta.discourse.org/t/where-is-solved-data-stored-in-the-database/294683/5 "2024-02-09T13:20:19Z")

</div>

That feature is supplied by the [Discourse Solved](https://meta.discourse.org/t/discourse-solved/30155) plugin.

It stores data in a few places, like the `topic_custom_field`, `post_custom_field` and `user_actions` tables (and likely others).

---

<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: [March 10, 2024, 1:20pm UTC](https://meta.discourse.org/t/where-is-solved-data-stored-in-the-database/294683/6 "2024-03-10T13:20:25Z")

</div>

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