The table listing transactions is empty in the transactions view. Even after selecting a "From date" extremely early and logged in as a customer who has transactions in the database
The table listing transactions is empty in the transactions view. Even after selecting a "From date" extremely early and logged in as a customer who has transactions in the database
jakob
added the bug label 2026-04-10 18:50:19 +02:00
Check what transactions exist for customer 1846 (id=1) in DB
Verify the transaction_date format in DB (DATETIME vs string)
Debug the transactions query to see if results are returned
Check customer_id linkage in transactions table
The query uses:
WHERE customer_id = ? with the customer ID from customers table
transaction_date BETWEEN ? AND ? for date filtering
Potential issues:
Customer ID mismatch (transactions linked to different customer_id)
Date format comparison (string vs DATETIME)
Using direct sqlx query vs repository method
**Investigation Plan:**
1. Check what transactions exist for customer 1846 (id=1) in DB
2. Verify the transaction_date format in DB (DATETIME vs string)
3. Debug the transactions query to see if results are returned
4. Check customer_id linkage in transactions table
The query uses:
- `WHERE customer_id = ?` with the customer ID from customers table
- `transaction_date BETWEEN ? AND ?` for date filtering
Potential issues:
- Customer ID mismatch (transactions linked to different customer_id)
- Date format comparison (string vs DATETIME)
- Using direct sqlx query vs repository method
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
The table listing transactions is empty in the transactions view. Even after selecting a "From date" extremely early and logged in as a customer who has transactions in the database
Investigation Plan:
The query uses:
WHERE customer_id = ?with the customer ID from customers tabletransaction_date BETWEEN ? AND ?for date filteringPotential issues: