Improve sorting and filtering user experience
Created by: malomarrec
Context
A key benefit of Batch Changes is to replace using manual work and spreadsheets to keep track of changesets. The Batch Changes UI allows getting automatically up-to-date information about changesets. Coming from spreadsheets though, users expect a spreadsheet-like experience for managing their changesets, including advanced filtering and sorting.
User problem
Sorting and filtering changesets in a spreadhseet-like way, such as:
- status not in (Open, Closed)
- sort by Review status, then changeset status, then name
- status in (Open, Closed) and Review status and NOT check passed
Impacted customers
This is going to impact all users. Those customers reported this problem:
Inspiration
A good long term solution here is to add a UI that supports arbitrary filtering and sorting. The best examples are probably google sheet's filter:
- I can sort AND filter
- I can combo select any value in any column

Proposal
- Change the select to a combo box
- Allow for filtering by several values in several columns
- Open a separate ticket for sorting