Sonar analysis overview shows less number of Majors,blockers,criticals

[TechTalks]

Hello Community, My sonar analysis overview shows less number of Majors,blockers,criticals but when I scroll to issues it shows different count

[Colin]

In the first screenshot you’ve filtered to Bugs, and the numbers have adjusted to only relate to bugs. In the second screenshot, you’ve made no filter, so the numbers represent the overall count (including bugs, vulnerabilities, code smells…)

[TechTalks]

@colin: Thank you for help. Is there any way we can export analysis report in excel/csv containing list of blocker/major like that using web api in community edition

[Colin]

Take a look at this guide:

How to reverse engineer the Sonar Web API

Every action that is taken in the SonarQube / SonarCloud UI is driven by the Web API. There is nothing you can do in SonarQube / SonarCloud that you cannot do using the Web API. We put a great deal of effort into the UI and UX of our products and sincerely think that most actions should be completed there. Especially when it comes to viewing analysis results, the UI is the best place to view up-to-date information with the right context. We think it is much better that you give access…

[TechTalks]

Hi Colin looks like its has limit of 500 can we increase that or how can we fetch values more than 500

[Colin]

Welcome to the world of API Pagination.

You’ll find the documentation for how to set the number of results returned (and how to get the next page) by looking at the Web API documentation (always linked in the footer of your SonarQube instance).

[TechTalks]

I was able to collect data in csv format using powershell script along with Web API.
Thank you