You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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:
SQL: ... 'owner' = ANY(string_to_array(t4.Tags, ', ')) ...
The text was updated successfully, but these errors were encountered:
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 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, ', ')) ...
The text was updated successfully, but these errors were encountered: