Cannot Paste Comma-Separated Values in Filter

[rdg0]

Bug description

When pasting a comma-separated list of values into a filter, the entire selection fails if any value in the list is outside the first 1000 entries of the dataset, when Dynamically search all filter values and Can select multiple values is enabled.

Key Observations:

• ✅ Works: Pasting a list where all values are within the first 1000 entries.
  

• ❌ Fails: Pasting a list where at least one value is outside the first 1000 entries.
  

• No error messages are shown, and the filter ignores the entire input.
  

Affected Feature: Dashboard Filters (Multi-Select + Dynamic Search).

Steps to Reproduce

1. Configure a filter with:

• Can select multiple values = True
• Dynamically search all filter values = True.

2. Identify values where:

• Value A: Exists within the first 1000 entries.
• Value B: Exists in the dataset but outside the first 1000 entries.

3. Copy a comma-separated list containing both values.
4. Paste the list into the filter input field.

Actual Result:

• No values are selected. The filter behaves as if the input is invalid.
  

• Values outside the first 1000 are ignored, and even valid entries are discarded.
  

Expected Result:

• Valid values should be selected immediately.
  

• Values outside the first 1000 should trigger a dynamic search and be added to the selection once confirmed.
  

Screenshots/recordings

No response

Superset version

4.1.1

Python version

3.10

Node version

16

Browser

Chrome

Additional context

No response

Checklist

• I have searched Superset docs and Slack and didn't find a solution to my problem.
• I have searched the GitHub issue tracker and didn't find a similar bug report.
• I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

[dosubot]

Hey @rdg0! I'm here to help you with any bugs, questions, or contributions you have in mind. Let's tackle this together!

The issue you're experiencing with pasting comma-separated values in a filter seems to be related to how Superset handles asynchronous data fetching for filter values that are not initially loaded due to the 1000 entry limit. Superset uses the AsyncSelect component to handle this, which supports lazy loading and pagination to fetch additional data as needed. However, it appears that when pasting a list with values outside the initial 1000 entries, the dynamic search might not be triggered correctly, leading to the entire input being ignored ^[1].

This behavior might be due to the way the AsyncSelect component processes the pasted input, potentially not triggering the necessary fetch operations for values outside the initial dataset. It could be beneficial to investigate the fetchPage function within the AsyncSelect component to ensure it handles pasted inputs correctly and triggers dynamic searches for values not initially loaded.

If this is a bug, it might require a code change to ensure that pasted values trigger the dynamic search functionality as expected.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other}

[rusackas]

That's a tricky one, from the sound of it. @geido @michael-s-molina @kgabryje worked on the Select component and its use in filters, quite some time ago. I'm doubtful they will have the time to go deep on this right now, but they may be able to provide some quick insights if we're lucky, or review a PR if you're willing to investigate a fix on your end.

[geido]

Yeah, can't think of anything right now but thanks for catching this! I'll try to repro.