Filtering Dropdown Selection List Prior To Searching

Nessuno ha ancora preso questa issue.

Hey Mark,

Currently, the filter field seems to primarily function as a search tool, which is useful, but I require pre-typing filtration.

Let's say in the related table, we have columns named 'Company Name' and 'Status'. Ideally, before a user starts typing, the dropdown list should already be filtered to display only items where the status is 'Active'.

For instance, let's consider a scenario with three records in the related table:

Company Name | Status
Amazon | Active
Google | Active
Apple | Inactive

If a user attempts to search for 'Apple', they shouldn't retrieve any results, and it shouldn't appear in the dropdown because it's marked as Inactive.

Deleting inactive items from the related table isn't feasible since we need to preserve historical data in archived records. Thus, when an item becomes 'Inactive', users shouldn't be able to select it in future records, but any archived record retaining that value should remain unchanged.

Do you have any suggestions on how to accomplish this?

With much gratitude,
Paden

Non sono indicati file, test o punti di ingresso. Inizia individuando il componente TypeScript che esegue il rendering del menu a discesa della tabella correlata e tracciando il funzionamento del filtraggio prima e dopo la digitazione; done dovrebbe mantenere selezionabili i record Active, escludere i record Inactive dalle nuove selezioni e preservare i valori archiviati.

Scritto dal modello di indicizzazione a partire dal testo della issue.