# Mysql User Details dashboard does not show query when filtering in QAN **URL:** \ **Category:** PMM 2.x\ **Created:** [December 9, 2024, 9:02pm UTC](https://forums.percona.com/t/mysql-user-details-dashboard-does-not-show-query-when-filtering-in-qan/35561 "2024-12-09T21:02:02Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Duygu](https://avatars.discourse-cdn.com/v4/letter/d/2acd7d/32.png) [@Duygu](https://forums.percona.com/u/Duygu)\ **Post date:** [December 9, 2024, 9:02pm UTC](https://forums.percona.com/t/mysql-user-details-dashboard-does-not-show-query-when-filtering-in-qan/35561/1 "2024-12-09T21:02:02Z")
Mysql User Details dashboard does not show queries when filtering QAN When I click on a user’s filter, QAN dashboard opens. but it does not filter. “No queries available for this combination of filters in the selected time frame” error occurs. ![filter-qan](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/8/2/820e08df6e23ec3c2b5020e90fa0cebdf3383d8d.png) The opened Link is like this in QAN: https:///graph/d/pmm-qan/pmm-query-analytics?var-service\_name=$%7B\_\_field.labels.service\_name%7D&var-username=$%7B\_\_field.labels.user%7D&var-environment=All&var-cluster=All&var-replication\_set=All&var-database=All&var-schema=All&var-node\_name=All&var-client\_host=All&var-service\_type=All&var-node\_type=All&var-city=All&var-az=All&var-interval=auto&columns=%5B%22load%22,%22num\_queries%22,%22query\_time%22%5D&group\_by=queryid&order\_by=-load&from=now-12h&to=now&page\_number=1&page\_size=25&totals=false&details\_tab=details Can this bug be resolved? ## Version: Pmm server and pmm agent v2.43.2 , used in mysql source:slowlog ## Additional Information: [Include any additional information that could be helpful to diagnose the issue, such as browser or device information] ---
**Author:** ![lalit.choudhary](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lalit.choudhary/32/51_2.png) [@lalit.choudhary](https://forums.percona.com/u/lalit.choudhary)\ **Post date:** [December 10, 2024, 5:21am UTC](https://forums.percona.com/t/mysql-user-details-dashboard-does-not-show-query-when-filtering-in-qan/35561/2 "2024-12-10T05:21:08Z")
Hello @Duygu These graphs are available only for [Percona Server](https://per.co.na/8_0_diagnostics_user_stat) and [MariaDB](https://mariadb.com/kb/en/mariadb/user-statistics/) and require userstat variable turned on. Here is the doc for ref: [MySQL User Details - Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/details/dashboards/dashboard-mysql-user-details.html) > This dashboard requires Percona Server for MySQL 5.1+ or MariaDB 10.1/10.2 with XtraDB. Also `userstat` should be enabled, for example with the `SET GLOBAL userstat=1` statement. See [Setting up MySQL](https://docs.percona.com/percona-monitoring-and-management/setting-up/client/mysql.html). See if this condition meets your setup. ---
**Author:** ![Duygu](https://avatars.discourse-cdn.com/v4/letter/d/2acd7d/32.png) [@Duygu](https://forums.percona.com/u/Duygu)\ **Post date:** [December 10, 2024, 7:20am UTC](https://forums.percona.com/t/mysql-user-details-dashboard-does-not-show-query-when-filtering-in-qan/35561/3 "2024-12-10T07:20:28Z")
> [@lalit.choudhary](#): > > SET GLOBAL userstat=1 Yes there is userstat=1 parameter in mysql config. still the same problem persists. ![Screenshot 2024-12-10 at 10.17.59](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/d/3/d3cb57a6c51ece9b9bfadb641292d6f60934fdaf.png) ---
**Author:** ![lalit.choudhary](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lalit.choudhary/32/51_2.png) [@lalit.choudhary](https://forums.percona.com/u/lalit.choudhary)\ **Post date:** [December 10, 2024, 7:46am UTC](https://forums.percona.com/t/mysql-user-details-dashboard-does-not-show-query-when-filtering-in-qan/35561/4 "2024-12-10T07:46:37Z")
> [@Duygu](#): > > Yes there is userstat=1 parameter in mysql config. still the same problem persists. What is the version of MySQL you are using? and You should look into pmm-agent logs on the pmm-client server to check if it is showing any error for this. `journalctl -u pmm-agent.service -f` ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [December 10, 2024, 12:45pm UTC](https://forums.percona.com/t/mysql-user-details-dashboard-does-not-show-query-when-filtering-in-qan/35561/5 "2024-12-10T12:45:44Z")
Hello @Duygu, The “MySQL User Details” dashboard, which you show a screenshot above, does not interact with the QAN dashboard. Those are 2 independent dashboards. Filtering inside the QAN does not affect other dashboards. Please confirm which dashboard you are having issues with.