• Steven's avatar
    fix(store): filter inbox notifications by message type at database level · d1492007
    Steven authored
    Add MessageType filter to FindInbox to exclude legacy VERSION_UPDATE
    notifications from inbox queries. This resolves the issue where users
    saw notification counts but no items displayed, as VERSION_UPDATE
    entries cannot be rendered in the new UserNotification API.
    
    Changes:
    - Add MessageType field to FindInbox struct for database-level filtering
    - Implement JSON extraction filters in SQLite, MySQL, and PostgreSQL drivers
    - Update ListUserNotifications to filter MEMO_COMMENT type at store level
    
    This approach improves performance by filtering at the database rather
    than in application code, reducing unnecessary data transfer for users
    with many legacy inbox entries.
    
    Fixes #5278
    
    🤖 Generated with [Claude Code](https://claude.com/claude-code)
    Co-Authored-By: 's avatarClaude <noreply@anthropic.com>
    d1492007
Name
Last commit
Last update
..
mysql Loading commit data...
postgres Loading commit data...
sqlite Loading commit data...
db.go Loading commit data...