aboutsummaryrefslogtreecommitdiffstats
path: root/mso-api-handlers/mso-requests-db-repositories
diff options
context:
space:
mode:
authorYulian Han <elaine.hanyulian@huawei.com>2020-01-06 18:01:20 +0800
committerYulian Han <elaine.hanyulian@huawei.com>2020-01-06 18:01:20 +0800
commit814650a7fe755b5de1d78e25a9e3d4f5846dc962 (patch)
tree6c00fc161b2f24c6580ac984e84c0573a496b1cf /mso-api-handlers/mso-requests-db-repositories
parent04e0f4e870c7e45a3a1f8f2c56a758bf3a635c2e (diff)
Bug fix for Multi-result row data order
Change-Id: Idaa55084f5ecb0dd3636c232cebc14fa5f064419 Issue-ID: SO-2071 Signed-off-by: Yulian Han <elaine.hanyulian@huawei.com>
Diffstat (limited to 'mso-api-handlers/mso-requests-db-repositories')
-rw-r--r--mso-api-handlers/mso-requests-db-repositories/src/main/java/org/onap/so/db/request/data/repository/InfraActiveRequestsRepository.java4
1 files changed, 2 insertions, 2 deletions
diff --git a/mso-api-handlers/mso-requests-db-repositories/src/main/java/org/onap/so/db/request/data/repository/InfraActiveRequestsRepository.java b/mso-api-handlers/mso-requests-db-repositories/src/main/java/org/onap/so/db/request/data/repository/InfraActiveRequestsRepository.java
index 257e319ce5..927477e146 100644
--- a/mso-api-handlers/mso-requests-db-repositories/src/main/java/org/onap/so/db/request/data/repository/InfraActiveRequestsRepository.java
+++ b/mso-api-handlers/mso-requests-db-repositories/src/main/java/org/onap/so/db/request/data/repository/InfraActiveRequestsRepository.java
@@ -41,7 +41,7 @@ public interface InfraActiveRequestsRepository
List<InfraActiveRequests> findByStartTimeLessThanAndEndTime(Date startTime, Date endTime, Pageable request);
- @Query(value = "SELECT * FROM infra_active_requests WHERE request_status = 'IN_PROGRESS' AND (request_scope = 'volumeGroup' OR request_scope = 'vfModule') AND start_time < (NOW() - INTERVAL 2 MINUTE)",
- nativeQuery = true)
+ @Query(value = "SELECT * FROM infra_active_requests WHERE request_status = 'IN_PROGRESS' AND (request_scope = 'volumeGroup' OR request_scope = 'vfModule') AND start_time < (NOW() - INTERVAL 2 MINUTE)"
+ + " ORDER BY start_time DESC", nativeQuery = true)
List<InfraActiveRequests> getInProgressVolumeGroupsAndVfModules();
}