Column Header filter types

[paddymul]

Checks

• I have checked that this enhancement has not already been requested

How would you categorize this request. You can select multiple if not sure

Other (please describe in Issue Description)

Enhancement Description

There are a number of useful column specific filters, especially for numeric colums. These should map to the lowcode UI, probably through quick_command_args.

1. Only Outliers, only show < q(.01) || > q(.99)
2. Remove Outliers, only show >q(.01) && < q(.99)
3. Drop Nulls
4. Only Nulls
5. Greater, less than

Pseudo Code Implementation

  const filterParams: INumberFilterParams = {
        filterOptions: [
          "empty",
          {
            displayKey: "evenNumbers",
            displayName: "Even Numbers",
//            predicate: (_, cellValue) => cellValue != null && cellValue % 2 === 0,
            numberOfInputs: 0,
          },
          {
            displayKey: "oddNumbers",
            displayName: "Odd Numbers",
            predicate: (_, cellValue) => cellValue != null && cellValue % 2 !== 0,
            numberOfInputs: 0,
          },
          {
            displayKey: "blanks",
            displayName: "Blanks",
            predicate: (_, cellValue) => cellValue == null,
            numberOfInputs: 0,
          },

https://www.ag-grid.com/react-data-grid/component-filter/

Prior Art

This requires the infinite branch