From 98ee5d4c76d2802c552851e46bd4bb43505b4416 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期三, 11 十一月 2020 13:28:05 +0800 Subject: [PATCH] 2020-11-11 --- src/utils/utils.js | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/src/utils/utils.js b/src/utils/utils.js index 7e970f3..8df4de7 100644 --- a/src/utils/utils.js +++ b/src/utils/utils.js @@ -697,7 +697,7 @@ if (item.orderBy) { sql = `select ${item.type === 'checkcard' ? 'top 20' : ''} ${arrfield} from (select distinct ${arrfield},${item.orderBy} as orderfield from ${_datasource} ) a order by orderfield ${item.orderType}` } else { - sql = `select ${item.type === 'checkcard' ? 'top 20' : ''} ${arrfield} from (select distinct ${arrfield} from ${_datasource})` + sql = `select ${item.type === 'checkcard' ? 'top 20' : ''} ${arrfield} from (select distinct ${arrfield} from ${_datasource}) a` } return { -- Gitblit v1.8.0