summaryrefslogtreecommitdiff
path: root/lib/items/service.ts
diff options
context:
space:
mode:
Diffstat (limited to 'lib/items/service.ts')
-rw-r--r--lib/items/service.ts3
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)
);
}