Subversion Repositories SmartDukaan
(root)/ – Rev 35479
Rev 35478 | Rev 35480 | Go to most recent revision | Compare with Previous | Directory listing | View Log | RSS feed
Last modification
- Rev 35479 – 124 d 14 h
- Author: amit
- Log message:
- Optimize Aging.SoldAgingModel query and fix column mapping
- Changed DATEDIFF(NOW(), inv.invoiceDate) > 15 to sargable condition
- Fixed trailing spaces in column names (SLOWMOVING_Billed, RUNNING_Billed, etc.)
- Enables index usage on invoiceDate column
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
