Comma separated filter value would not hand over from dashboard to question

[mskako]

Describe the bug
Comma separated filter value would not hand over from dashboard to question

Logs

To Reproduce
Steps to reproduce the behavior:

1. Create Dashboard with default value of comma separated multiple values
2. Open dashboard
3. Click question title which uses 1's default value
4. Only top 1 value will be taken over. Rest of them will be omitted.

Expected behavior
All of separated values will be taken over.

Screenshots

Information about your Metabase Installation:
Docker image metabase/metabase:v0.44.2

You can get this information by going to Admin -> Troubleshooting.

• Your browser and the version: Chrome 105.0.5195.102, Firefox 104.0.2
• Your operating system: Windows 10 Enterprise 21H2(Client)
• Your databases: MySQL
• Metabase version: v.0.44.2
• Metabase hosting environment: Docker
• Metabase internal database: MySQL

Severity
Customers' use case always starts with this dashboard and they move to each questions and export CSVs. Unless values taken over properly, their business flow will be stopped.

Additional context
On v.0.41.5, it doesn't happen.

[flamber]

Regression since 0.44.0

A possible workaround is to change the variable to Text and turn it into an array #4728, or use a Field Filter. But both options might be difficult to implement depending on dashboard count, database type or how the query is created.

Reproduce:

1. Native > Sample > select count(*) from orders where id in ({{number}}) - change variable to Number - save question
2. Add question to dashboard, add filter Number equal and connect to card, save dashboard
3. Input 1,2,3 in filter, which gives expected results
   
4. Click question title goes to the question, and the URL quickly flashes from =1,2,3 to =1 and give unexpected results
   

[wincelau]

I also noticed this bug on version 0.43.4

[nemanjaglumac]

Refreshing the dashboard also removes all values except the first one.
Which is also the equivalent of visiting the dashboard while trying to pass parameters through URL:
/dashboard/:id?equal_to=1%2C2%2C3

[mskako]

I just have checked on v.0.45.2, it works properly. Thanks!!