[CaptainJack] Collection Tracker sorting issues - wrong direction or unclear
George Jabbour
## Problem Statement
The Collection Tracker has sorting issues where:
- Sorting sometimes works in the wrong direction (ascending vs descending confusion)
- The current sort state is not clearly communicated to the user
## Area
Collection Tracker
## Current Behavior
- Clicking sort options sometimes sorts in unexpected direction
- Users cannot easily tell which column is being sorted
- Users cannot easily tell if sort is ascending or descending
- Sort behavior may be inconsistent across different columns
## Expected Behavior
- Clear visual indicator showing which column is currently sorted
- Clear visual indicator showing sort direction (arrow up/down icons)
- Consistent toggle behavior: click once for ascending, click again for descending
- Sort direction should match user expectations (A-Z, lowest-highest, etc.)
## Steps to Reproduce
- Navigate to Collection Tracker
- Click on a column header to sort
- Observe that sort direction may not match expectations
- Note lack of clear visual feedback on current sort state
## Technical Investigation Needed
- Audit all sortable columns in Collection Tracker
- Verify sort direction logic for each data type (text, numbers, dates)
- Check for state management issues with sort direction
- Review sort indicator UI components
## Acceptance Criteria
- [ ] All sortable columns have visible sort indicators
- [ ] Sort direction (asc/desc) is clearly shown with arrow icons
- [ ] Clicking a sorted column toggles the direction
- [ ] Clicking a new column sorts ascending by default
- [ ] Text columns sort A-Z (asc) and Z-A (desc)
- [ ] Numeric columns sort lowest-highest (asc) and highest-lowest (desc)
- [ ] Date columns sort oldest-newest (asc) and newest-oldest (desc)
- [ ] Sort state persists appropriately during session
- [ ] Add visual hover state to indicate columns are sortable
## Reporter
CaptainJack (user feedback)