Thundercloud12 opened a new pull request, #9133:
URL: https://github.com/apache/devlake/pull/9133
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
### ⚠️ Pre-Checklist
> Please complete **ALL** items in this checklist and remove this section
before submitting.
* [x] I have read through the [[Contributing
Documentation](https://devlake.apache.org/community/)](https://devlake.apache.org/community/).
* [x] I have added relevant tests (N/A for Grafana dashboard JSON; validated
JSON syntax and query logic).
* [x] I have added relevant documentation.
* [x] I will add appropriate labels to the PR, such as `pr-type/bug-fix`,
`pr-type/feature-development`, etc.
### Summary
Fix Grafana panels in the GitHub Copilot Adoption dashboard that render
**"No data"** on PostgreSQL deployments due to boolean/integer comparison type
mismatches.
* Replaced `= 1` with the ANSI-standard `IS TRUE` for the `used_agent` and
`used_chat` columns in:
* Panel 12 (*Agent Mode Adopters*)
* Panel 13 (*Chat Adopters*)
* Panel 30 (*Agent Users vs Chat Users Trend*)
* Updated both:
* `grafana/dashboards/postgresql/github-copilot-adoption.json`
* `grafana/dashboards/mysql/github-copilot-adoption.json`
* Kept the PostgreSQL and MySQL dashboard definitions in sync to prevent
regressions when the dashboards are updated or ported between database dialects.
### Does this close any open issues?
Closes #9126
### Screenshots
N/A — This is a query syntax alignment fix. The affected panels will display
user counts instead of **"No data"**.
### Other Information
* Both dashboard JSON files were validated for valid JSON formatting.
* `IS TRUE` is supported natively by PostgreSQL for `BOOLEAN` values and by
MySQL for boolean-like `TINYINT(1)` values.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
