Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

AttributeUi: add a values list derivation for MAP types #340

Closed
rpbouman opened this issue Dec 29, 2024 · 0 comments
Closed

AttributeUi: add a values list derivation for MAP types #340

rpbouman opened this issue Dec 29, 2024 · 0 comments
Labels
enhancement New feature or request

Comments

@rpbouman
Copy link
Owner

We already have a keyset derivation (make an array of the MAP keys), the values list derivation would be its complement (make an array of the MAP values).

It's significance would be to allow filtering.

Example: DuckDB sees the blueworks dataset as an array of records, where each element of records is a MAP(VARCHAR, VARCHAR).

We can currently turn this in to a tabular view by

  • putting the element indices of records on the row axis (unnesting the records array)
  • putting the key of the entries of the records elements on the columns axis
  • putting the max of the value of the entries of the records elements on the cells axis

image

But, if we now want to see only the objects of a particular type, or of a particular user, we cannot do it.
That is, we can add a filter on the value, but that would result in removal of all fields that happen not to have the values we selected.

If we would have a values list derivation, then we could use an array filter method (has any) to keep only those entries that have the selected filter value.

@rpbouman rpbouman added the enhancement New feature or request label Dec 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant