diff options
Diffstat (limited to 'lib/items/service.ts')
| -rw-r--r-- | lib/items/service.ts | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/lib/items/service.ts b/lib/items/service.ts index c841efad..1b6d7e09 100644 --- a/lib/items/service.ts +++ b/lib/items/service.ts @@ -42,13 +42,12 @@ export async function getItems(input: GetItemsSchema) { if (input.search) { const s = `%${input.search}%`; globalWhere = or( - ilike(items.itemLevel, s), + ilike(items.ProjectNo, s), ilike(items.itemCode, s), ilike(items.itemName, s), ilike(items.smCode, s), ilike(items.packageCode, s), ilike(items.description, s), - ilike(items.changeDate, s) ); } |
