[Bug]: Dropdown doesn't display filtered values

[poweribo]

Describe the bug

I have two dropdowns and I'm recreating the behavior of Dimension Grid. Desired behavior is, depending on what type I've selected, it should also change the value of sub_types dropdown. The sub_types doesnt refresh the list properly. you'll have to click "clear all" for the new values to show up.

Steps to Reproduce

Sample code:

sql type_list
  select type, sub_type
  from pos_table
  group by type, sub_type


sql types
  select distinct type
  from ${type_list}


sql sub_types
  select distinct sub_type
  from ${type_list}
  where type in ${inputs.types.value}    

<Dropdown 
    data={types} 
    name=types
    value=type
    multiple=true     
    selectAllByDefault=true
/>

<Dropdown 
    data={sub_types} 
    name=sub_types
    value=sub_type
    multiple=true     
    selectAllByDefault=true
/>

Logs

System Info

Using versions:
    "@evidence-dev/core-components": "^5.1.0",
    "@evidence-dev/evidence": "^40.0.6",

Severity

serious, but I can work around it

Additional Information, or Workarounds

No response

[tylerdigital]

I'm also seeing this issue as well, following this thread hoping for a fix/workaround