From ba138a0acb597e1420d1041e7d8e89ad810c57a5 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期五, 11 十一月 2022 10:19:20 +0800 Subject: [PATCH] 2022-11-11 --- 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