diff options
| -rw-r--r-- | lib/tbe-last/service.ts | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/lib/tbe-last/service.ts b/lib/tbe-last/service.ts index 346576e5..3b70ef52 100644 --- a/lib/tbe-last/service.ts +++ b/lib/tbe-last/service.ts @@ -44,7 +44,9 @@ export async function getAllTBELast(input: GetTBELastSchema) { sql`${tbeLastView.projectCode} ILIKE ${s}`, sql`${tbeLastView.projectName} ILIKE ${s}`, sql`${tbeLastView.packageNo} ILIKE ${s}`, - sql`${tbeLastView.packageName} ILIKE ${s}` + sql`${tbeLastView.packageName} ILIKE ${s}`, + sql`${tbeLastView.picName} ILIKE ${s}`, + sql`${tbeLastView.EngPicName} ILIKE ${s}` ); } |