Enhance Table Column Filtering

[joshuadkitenge]

Overview

Currently, the table column filtering feature only uses fuzzy text search and some exact select menu search across the columns. To improve usability, we need to assess and update the filter modes and filter variants for each table column. This enhancement will be implemented gradually, one table per pull request (PR).

Objectives

1. Assess and Implement Appropriate Filter Modes and Variants:

   • Evaluate each table column's data type and user needs to determine the most suitable filter mode and filter variant.
   • Provide clear reasoning for the selection of filter modes and variants for each column in the PR description.

2. Priority Columns for Update:

   • System Column:
     • Users should be able to filter by multiple systems.
     • Users should be able to exclude specific systems (e.g., "System not equal to Storage").
   • Usage Status Column:
     • Users should be able to filter by multiple usage statuses.
     • Users should be able to exclude specific usage statuses (e.g., "Usage status not equal to Scrapped and Used").

Implementation Steps

1. Column Assessment:

   • Review the current filter mode and filter variant for each column.
   • Determine the best fit for each column based on its data type and user requirements.

2. Column Filtering Enhancements:

   • System Column:
     • Implement a filter that allows for multi-selection and exclusion.
     • Example: Users should be able to select multiple systems to include or exclude in their filter criteria.
   • Usage Status Column:
     • Implement a filter that allows for multi-selection and exclusion.
     • Example: Users should be able to select multiple usage statuses to include or exclude in their filter criteria.

3. Pull Request Process:

   • Implement changes one table at a time.
   • In each PR, include a detailed explanation of why specific filter modes and variants were chosen for each column.
   • Ensure thorough testing to confirm the new filter modes and variants work as expected.

Components Requiring Table Column Filtering Enhancements

• catalogueCategoryTableView.component.tsx
• catalogueItemsTable.component.tsx
• itemsTable.component.tsx
• manufacturer.component.tsx (Table is within this component)
• systemsTableView.component.tsx
• systemItemsTable.component.tsx
• units.component.tsx (Table is within this component)
• usageStatuses.component.tsx (Table is within this component)

Tasks

• Enhance Usage Status Table Filtering #979
• Enhance Manufacturer Table Filtering #1037
• Enhance Unit Table Filtering #1038
• Enhance Systems Items Table Filtering #1039
• Enhance Catalogue Items Table Filtering #1040
• Enhance manufacturer name column in Catalogue item table #1133
• Enhance Items Table Filtering #1041
• Enhance catalogue categories card view filtering #1124
• Enhance catalogue categories table view filtering #1125
• Enhance images card view filtering #1126
• Enhance attachments Images table view filtering #1127
• Enhance catalogue item properties table view filtering #1128
• Enhance Systems table view filtering #1129

Reference

• Material React Table Column Filtering Documentation