diff options
Diffstat (limited to 'lib/material')
| -rw-r--r-- | lib/material/material-group-service.ts | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/lib/material/material-group-service.ts b/lib/material/material-group-service.ts index 216cd0e6..50ab5164 100644 --- a/lib/material/material-group-service.ts +++ b/lib/material/material-group-service.ts @@ -6,7 +6,7 @@ import { materialSearchView } from "@/db/schema/items"; export interface MaterialSearchItem { materialGroupCode: string; - materialName: string; + materialGroupDesc: string; displayText: string; } @@ -40,7 +40,7 @@ export async function searchMaterialsForSelector( const searchPattern = `%${query.trim()}%`; searchWhere = sql`( ${materialSearchView.materialGroupCode} ILIKE ${searchPattern} OR - ${materialSearchView.materialName} ILIKE ${searchPattern} OR + ${materialSearchView.materialGroupDesc} ILIKE ${searchPattern} OR ${materialSearchView.displayText} ILIKE ${searchPattern} )`; } @@ -51,7 +51,7 @@ export async function searchMaterialsForSelector( .select() .from(materialSearchView) .where(searchWhere) - .orderBy(materialSearchView.materialGroupCode, materialSearchView.materialName) + .orderBy(materialSearchView.materialGroupCode, materialSearchView.materialGroupDesc) .limit(perPage) .offset(offset); @@ -66,7 +66,7 @@ export async function searchMaterialsForSelector( return { data: data.map((row) => ({ materialGroupCode: row.materialGroupCode, - materialName: row.materialName, + materialGroupDesc: row.materialGroupDesc, displayText: row.displayText, })), total, |