Skip to content

Selector for array fields #202

Open
Open
@timka-s

Description

Add the ability to create selectors for arrays (like from function - SPLIT(Tags, ', ')), or fix unnest array filtration)
Show unnest([array_field]) in selector values, but filter any([array_field]) in (%selected values%)

Details:
If we have string field like Tags
image

We can create selector with Tags
image
Or with UNNEST(SPLIT([Tags], ', '))
image

But, if we choice unnest value, we will receive error - "set-returning functions are not allowed in WHERE"
SQL: ... unnest(string_to_array(t4.Tags, ', ')) = 'owner' ...

On the other side, filtration for SPLIT(Tags, ', ') works fine:
image
SQL: ... 'owner' = ANY(string_to_array(t4.Tags, ', ')) ...

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions