-
Notifications
You must be signed in to change notification settings - Fork 6.3k
type/FK -> column and type/FK -> type/Name field values remapping doesn't work in QB filter widgets when Search box is used #45063
Copy link
Copy link
Closed
Labels
.Team/QueryingPriority:P1Security holes w/o exploit, crashing, setup/upgrade, login, broken common features, correctnessSecurity holes w/o exploit, crashing, setup/upgrade, login, broken common features, correctnessQuerying/GUIQuery builder catch-all, including simple modeQuery builder catch-all, including simple modeQuerying/MBQLType:BugProduct defectsProduct defects
Milestone
Description
Describe the bug
Automatic PK field values remapping to a field with "Entity Name" semantic type doesn't work in query builder widgets with Search box. The same with FK -> Use foreign key -> Column remapping.
To Reproduce
type/FK -> type/Name:
- Admin -> Table Metadata -> People.
- Make sure that
People.NamehasEntity Namesemantic type. - Make sure that
People.IDhasSearch boxinFiltering on this fieldsection (has_field_valuesproperty). - New -> Question -> Tables -> People
- Filter -> ID
- Start typing a person name. Nothing happens - there is no autocomplete.
- Enter some valid person ID and add this filter.
- Open the filter again. See that the value is not remapped either.
type/FK -> column:
- Admin -> Table Metadata -> Orders.
- Open
PRODUCT_ID-> Remapping -> Use foreign key -> SelectProduct.Title. - Make sure there is
Search boxenabled as well. - New -> Question -> Tables -> Orders
- Filter -> Product ID
- Start typing a product title. Nothing happens - there is no autocomplete.
- Enter some valid product ID and add this filter.
- Open the filter again. See that the value is not remapped either.
Expected behavior
Both cases work with List of values. They should work with Search box.


Logs
No response
Information about your Metabase installation
- v50Severity
P1
Additional context
No response
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
.Team/QueryingPriority:P1Security holes w/o exploit, crashing, setup/upgrade, login, broken common features, correctnessSecurity holes w/o exploit, crashing, setup/upgrade, login, broken common features, correctnessQuerying/GUIQuery builder catch-all, including simple modeQuery builder catch-all, including simple modeQuerying/MBQLType:BugProduct defectsProduct defects