Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
regexp_replace(
array_to_string(
array_filter(
string_to_array(
relation_aggregate(
relation:='rel_reg_prov',
aggregate:='concatenate',
expression:="SIGLA"||'-'||"cod_rip", -- concateno i campi
concatenator:=','
)) , @element Ilike '%3%' AND @element Ilike '%a%' ) ) -- filtro complesso
,'(.+?)(-[^-, ]+)','\\1') -- regex: per estrarre solo il valore del primo campo
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment