diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-11 00:19:38 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-11 00:19:38 +0000 |
| commit | a383fd2a30f60360ebc0c1b897b3d43cbae178fa (patch) | |
| tree | 98adaae908465697ad627391e66113dc0694abb3 /lib/docu-list-rule/combo-box-settings/service.ts | |
| parent | 71f4e15800b0cf771d1dddab6cc46fc7c2a17c51 (diff) | |
| parent | f30678aa2956620177e61cbcc0fb57e9ce6872f1 (diff) | |
Merge branch 'dujinkim' of https://github.com/DTS-Development/SHI_EVCP into dujinkim
Diffstat (limited to 'lib/docu-list-rule/combo-box-settings/service.ts')
| -rw-r--r-- | lib/docu-list-rule/combo-box-settings/service.ts | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/lib/docu-list-rule/combo-box-settings/service.ts b/lib/docu-list-rule/combo-box-settings/service.ts index 7a003327..c733f978 100644 --- a/lib/docu-list-rule/combo-box-settings/service.ts +++ b/lib/docu-list-rule/combo-box-settings/service.ts @@ -26,13 +26,13 @@ export async function getComboBoxCodeGroups(input: { const { page, perPage, sort, search, filters, joinOperator } = input const offset = (page - 1) * perPage - // Control Type이 combobox인 조건 - let whereConditions = sql`${codeGroups.controlType} = 'combobox'` + // Control Type이 combobox이고 plant 타입 프로젝트인 조건 + let whereConditions = sql`${codeGroups.controlType} = 'combobox' AND ${projects.type} = 'plant'` // 검색 조건 if (search) { const searchTerm = `%${search}%` - whereConditions = sql`${whereConditions} AND ( + whereConditions = sql`${codeGroups.controlType} = 'combobox' AND ${projects.type} = 'plant' AND ( ${codeGroups.groupId} ILIKE ${searchTerm} OR ${codeGroups.description} ILIKE ${searchTerm} OR ${codeGroups.codeFormat} ILIKE ${searchTerm} OR |