1 files changed, 16 insertions, 6 deletions
diff --git a/lib/pq/helper.ts b/lib/pq/helper.ts
index 81ee5db2..d3970fd7 100644
--- a/lib/pq/helper.ts
+++ b/lib/pq/helper.ts
@@ -1,11 +1,12 @@
-import { 
-  vendorPQSubmissions, 
-  vendors, 
-  projects, 
-  users, 
-  vendorInvestigations 
+import {
+  vendorPQSubmissions,
+  vendors,
+  projects,
+  users,
+  vendorInvestigations
 } from "@/db/schema"
 import { CustomColumnMapping } from "../filter-columns"
+import { sql } from "drizzle-orm"
 
 /**
  * Helper function to create custom column mapping for PQ submissions
@@ -41,6 +42,12 @@ export function createPQFilterMapping(): CustomColumnMapping {
     investigationStatus: { table: vendorInvestigations, column: "investigationStatus" },
     investigationAddress: { table: vendorInvestigations, column: "investigationAddress" },
     qmManagerId: { table: vendorInvestigations, column: "qmManagerId" },
+
+    // pqItems JSON 검색 (첫 번째 아이템의 itemCode 또는 itemName)
+    pqItems: {
+      table: vendorPQSubmissions,
+      column: "pqItems"
+    },
   }
 }
 
@@ -90,5 +97,8 @@ export function createPQDirectColumnMapping(): CustomColumnMapping {
     investigationStatus: vendorInvestigations.investigationStatus,
     investigationAddress: vendorInvestigations.investigationAddress,
     qmManagerId: vendorInvestigations.qmManagerId,
+
+    // pqItems JSON 검색 (첫 번째 아이템의 itemCode 또는 itemName)
+    pqItems: vendorPQSubmissions.pqItems,
   }
 }
 \ No newline at end of file