Skip to content

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
Screenshot 2021-11-01 at 18 57 09

Proposal

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