From d0e8c7cb64d7d219f7cfec8bc87cf699b9cfe7b2 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期二, 08 十一月 2022 12:35:25 +0800 Subject: [PATCH] 2022-11-08 --- 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