問(wèn)題分類說(shuō)明：

MAJOR?MINOR? INFO? CRITICAL?BLOCKER 問(wèn)題分為以上五中，分別是主要，次要，提示，嚴(yán)重，阻斷

這幾個(gè)字段對(duì)應(yīng)issues數(shù)據(jù)表中的severity字段

——————————————————————————————————————

首先根據(jù)sonar 中projectkey 也就是關(guān)鍵字

通過(guò)語(yǔ)句：??

SELECT project_uuid FROM??projects WHERE kee= 'com.suning.spcs:spctxs-pom:1.5.14'?如圖：

當(dāng)然也可以根據(jù)接口，獲取project_uuid，如下

<a data-cke-saved-href="http://10.37.124.178:9000/api/ce/task?id=AWMF_byVw6x9hRrwyOth" href="http://10.37.124.178:9000/api/ce/task?id=AWMF_byVw6x9hRrwyOth">http://10.37.124.178:9000/api/ce/task?id=AWMF_byVw6x9hRrwyOth</a>

這個(gè)請(qǐng)求獲取的結(jié)果：

[plain]?view plain?copy

{"task":{"id":"AWMF_byVw6x9hRrwyOth","type":"REPORT","componentId":"AWKoGAC77Uto1y5a2U8f","componentKey":"com.suning.plppss:plppss-pom:1.1.1","componentName":"plppss-pom?1.1.1","componentQualifier":"TRK","analysisId":"AWMF_cKp1R9XW-B8x9JM","status":"SUCCESS","submittedAt":"2018-04-27T15:25:05+0800","submitterLogin":"admin","startedAt":"2018-04-27T15:25:05+0800","executedAt":"2018-04-27T15:25:41+0800","executionTimeMs":35857,"logs":false,"hasScannerContext":true}}??

查詢projects數(shù)據(jù)表，查對(duì)應(yīng)的project_uuid

然后根據(jù)project_uuid查詢issues數(shù)據(jù)表

SELECT?count(*) FROM?issues WHERE project_uuid= 'AWMA4IVow6x9hRrwyNsE' AND severity = 'INFO'

這里severity 數(shù)值分別可以為MAJOR? MINOR? INFO?CRITICAL? BLOCKER

創(chuàng)作挑戰(zhàn)賽新人創(chuàng)作獎(jiǎng)勵(lì)來(lái)咯，堅(jiān)持創(chuàng)作打卡瓜分現(xiàn)金大獎(jiǎng)

總結(jié)

以上是生活随笔為你收集整理的对于sonar展示的问题数的研究的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。