...
Query for the entries where Sonar is enabled:
| Code Block | ||
|---|---|---|
| ||
select * from AO_C716BC_REPO_CONFIG001 where SONAR_ENABLED = TRUE |
To get the repository with enabled Sonar configuration:
| Code Block | ||
|---|---|---|
| ||
select PROJ.PROJECT_KEY, REPO.SLUG, * from AO_C716BC_REPO_CONFIG001 as SONAR join REPOSITORY as REPO on REPO.ID = SONAR.REPO_ID join PROJECT as PROJ on PROJ.ID = REPO.PROJECT_ID where SONAR_ENABLED = TRUE |
...