From a961ba274a997a73fffea5bd6b707a64134adfab Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期日, 06 十一月 2022 08:38:47 +0800 Subject: [PATCH] 2022-11-06 --- src/utils/utils.js | 2 -- 1 files changed, 0 insertions(+), 2 deletions(-) diff --git a/src/utils/utils.js b/src/utils/utils.js index a829fa6..15dfac7 100644 --- a/src/utils/utils.js +++ b/src/utils/utils.js @@ -789,10 +789,8 @@ arrfield = arrfield.join(',') 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}` sql = `select distinct ${arrfield},${item.orderBy} as orderfield from ${_datasource} order by orderfield ${item.orderType}` } else { - // sql = `select ${item.type === 'checkcard' ? 'top 20' : ''} ${arrfield} from (select distinct ${arrfield} from ${_datasource}) a` sql = `select distinct ${arrfield} from ${_datasource}` } -- Gitblit v1.8.0