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
We can create selector with Tags
Or with UNNEST(SPLIT([Tags], ', '))
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:
Add the ability to create selectors for arrays (like from function -
SPLIT(Tags, ', ')), or fix unnest array filtration) Showunnest([array_field])in selector values, but filterany([array_field]) in (%selected values%)Details: If we have string field like Tags
We can create selector with Tags
Or with
UNNEST(SPLIT([Tags], ', '))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:SQL:
... 'owner' = ANY(string_to_array(t4.Tags, ', ')) ...