From 0bff15b120b3e3ff1f1c3d2ce4d9aa8d3ad3917e Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期五, 06 十一月 2020 13:49:44 +0800 Subject: [PATCH] 2020-11-06 --- 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