diff options
| author | shizhendong <[email protected]> | 2024-04-27 16:51:09 +0630 |
|---|---|---|
| committer | shizhendong <[email protected]> | 2024-04-27 16:51:09 +0630 |
| commit | bad12a157d75a4e482b9f40986b52703396c5229 (patch) | |
| tree | a7ed2077ab282b7311419f7af152d9bb5f9fca6c | |
| parent | 4e2b41eb074d918e85ad0a9a7b75d5e2433e22a6 (diff) | |
fix: 修复因关联表存在重复数据导致 asset total 有误问题rel-24.01.14
| -rw-r--r-- | nz-admin/src/main/resources/mapper/asset/AssetAssetDao.xml | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/nz-admin/src/main/resources/mapper/asset/AssetAssetDao.xml b/nz-admin/src/main/resources/mapper/asset/AssetAssetDao.xml index 66ad16e1..46944655 100644 --- a/nz-admin/src/main/resources/mapper/asset/AssetAssetDao.xml +++ b/nz-admin/src/main/resources/mapper/asset/AssetAssetDao.xml @@ -301,6 +301,9 @@ </if> </where> + + GROUP BY asset.id + <if test="params.orderBy == null or params.orderBy == ''"> ORDER BY asset.id </if> |