From b66f1643396b524eb7c3ca1a654d8d1e22e0249f Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期一, 07 十一月 2022 18:50:45 +0800 Subject: [PATCH] 2022-11-07 --- 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