Merge pull request 'Fix case-insensitive search query on order page' (#7) from fix/dg1-order-search-behavior into master

Reviewed-on: #7

.gitignore

@@ -8,3 +8,4 @@ bun.lock
 *.sqlite-wal
 dist
 coverage
+pi-session*

AGENTS.md

@@ -1,5 +1,9 @@
 # Typescript Full Stack App Agent
 
+## Coding Conventions
+- Before planning any code plan, check the `CONTRIBUTING.md` file in the root directory of the project to understand and apply coding conventions for this project
+- Instead of reading and parsing the `CONTRIBUTING.md` every time, cache the findings of `CONTRIBUTING.md` and refer to this cache'd file whenever checking the conventions is required
+
 ## Output Rules
 
 ### Response Style
@@ -176,4 +180,3 @@ Skip `discover_context` for narrow tasks with explicit file targets.
 ### Boundaries
 - Recon is read-only unless user requested implementation.
 - Do not treat scout output as complete when evidence suggests missing files.
-

apps/api/src/orders/order-repository.ts

@@ -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;