fix case-insensitive order search

2026-09-17 17:26:11 -07:00
1 changed files with 3 additions and 3 deletions
@@ -39,9 +39,9 @@ export async function listOrderSummaries(context: DatabaseContext, query?: strin
  const filters = search
    ? or(
-        sql`instr(lower(${orders.orderNumber}), ${search}) > 0`,
+       sql`instr(lower(${orders.orderNumber}), ${search}) > 0`,
-        sql`instr(lower(${users.name}), ${search}) > 0`,
+       sql`instr(lower(${users.name}), ${search}) > 0`,
-        sql`instr(lower(${users.email}), ${search}) > 0`
+       sql`instr(lower(${users.email}), ${search}) > 0`
      )
    : undefined;