diff options
| author | Sébastien Lesaint <sebastien.lesaint@sonarsource.com> | 2019-07-02 13:44:49 +0200 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2019-07-10 08:36:54 +0200 |
| commit | d959cb81e02abbcf8a1201bd5ece9e50bc4ffa2e (patch) | |
| tree | 7294a21cf4de4a58fe63c8799ce842e9af9120b4 | |
| parent | 421174b8456db3bd16471e636a79a0cf997c02ad (diff) | |
| download | sonarqube-d959cb81e02abbcf8a1201bd5ece9e50bc4ffa2e.tar.gz sonarqube-d959cb81e02abbcf8a1201bd5ece9e50bc4ffa2e.zip | |
SONAR-12261 fix project QG search on MsSQL
| -rw-r--r-- | server/sonar-db-dao/src/main/resources/org/sonar/db/qualitygate/ProjectQgateAssociationMapper.xml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/server/sonar-db-dao/src/main/resources/org/sonar/db/qualitygate/ProjectQgateAssociationMapper.xml b/server/sonar-db-dao/src/main/resources/org/sonar/db/qualitygate/ProjectQgateAssociationMapper.xml index 547eeeacc09..5d9239182ed 100644 --- a/server/sonar-db-dao/src/main/resources/org/sonar/db/qualitygate/ProjectQgateAssociationMapper.xml +++ b/server/sonar-db-dao/src/main/resources/org/sonar/db/qualitygate/ProjectQgateAssociationMapper.xml @@ -4,7 +4,7 @@ <mapper namespace="org.sonar.db.qualitygate.ProjectQgateAssociationMapper"> <select id="selectProjects" parameterType="map" resultType="ProjectQgateAssociation"> - SELECT proj.id as id, proj.kee as key, proj.name as name, prop.text_value as gateId + SELECT proj.id as id, proj.kee as "key", proj.name as name, prop.text_value as gateId FROM projects proj LEFT JOIN properties prop ON prop.resource_id=proj.id AND prop.prop_key='sonar.qualitygate' AND prop.text_value = #{query.gateId} where |