# Can we display solved count on the /users page?

**URL:** <https://meta.discourse.org/t/can-we-display-solved-count-on-the-users-page/61342>\
**Category:** Feature\
**Tags:** solved, completed\
**Created:** [April 20, 2017, 5:31pm UTC](https://meta.discourse.org/t/can-we-display-solved-count-on-the-users-page/61342 "2017-04-20T17:31:52Z")\
**Posts on this page:** 1\
**Showing post:** 16

<div class="post-metadata">

**Author:** ![awlogan](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/awlogan/32/62208_2.png) [@awlogan](https://meta.discourse.org/u/awlogan)\
**Post date:** [April 26, 2017, 11:43pm UTC](https://meta.discourse.org/t/can-we-display-solved-count-on-the-users-page/61342/16 "2017-04-26T23:43:40Z")

</div>

Following up, I can get the data when there is a solution selected using the following:

```
SELECT value
FROM
    post_custom_fields
WHERE  
    name = 'is_accepted_answer'

```

What I’m getting back is either ‘true’ which I expect from looking through the plugin code. There is one NULL, I am going to assume that this is from someone who checked a solution box then unchecked it. Unfortunately I can’t seem to get it to show other users who have 0 solved solutions when I try to build out the dashboard like you see at [Discourse Meta](http://meta.discourse.com/users).

It’s possible it’s just my rusty SQL skills and maybe I’m missing something obvious in how to display the rest of my user base with 0 matches. I tried matching on NULL (1 match) and an empty string but that didn’t provide any additional output.

I can certainly run it today as there are only 7 of us with solved solutions as most of my users interact via email, but as we get ready to open this up to our user and partner base I’m guessing that will go up. If anyone has any pointers I’d appreciate it.

---

_[View the full topic](https://meta.discourse.org/t/can-we-display-solved-count-on-the-users-page/61342)._