shawn/canteen-asset-tracker
1
0
Fork 0
Code Issues 8 Pull Requests Actions Packages Projects Releases Wiki Activity

Add serial_number to barcode search #51

New Issue
Closed
opened 2026-05-29 11:59:44 +00:00 by shawn · 0 comments
shawn commented 2026-05-29 11:59:44 +00:00
Owner
Copy Link
Copy Source

What: Barcode scanner should also find assets by serial number, not just machine_id and connect_id.

Change: Updated GET /api/assets/search to also match serial_number column.

Before: WHERE machine_id = ? OR connect_id = ?
After: WHERE machine_id = ? OR connect_id = ? OR serial_number = ?

All 7,488 assets have serial_number populated from the MSFS import. Most are placeholder values (**, 00000) but real serial numbers like 100065983 now resolve to their asset.

Commit: e10e226

**What:** Barcode scanner should also find assets by serial number, not just machine_id and connect_id. **Change:** Updated `GET /api/assets/search` to also match `serial_number` column. **Before:** `WHERE machine_id = ? OR connect_id = ?` **After:** `WHERE machine_id = ? OR connect_id = ? OR serial_number = ?` All 7,488 assets have serial_number populated from the MSFS import. Most are placeholder values (`**`, `00000`) but real serial numbers like `100065983` now resolve to their asset. Commit: `e10e226`
shawn closed this issue 2026-05-29 11:59:45 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
blocked
Kanban task is blocked
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
shawn
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: shawn/canteen-asset-tracker#51
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?