Wildcards in map function

How To
, ,
1

I’d like to get(map()) a value from an array using a value as a filter. The value that I’d like to filter by contains a certain word, but I won’t always know its exact value. Can I use wildcards in the filter?

{{get(map(12.subitems; “id”; “mappable_column_values.text”; “01plan0810”); 1)}}

Above is the query I’d like to use. Except in my filter, the “01plan0810” value could have different numbers before and after the “plan”. So I’d like to change the query to something like,

{{get(map(12.subitems; “id”; “mappable_column_values.text”; “##plan####”); 1)}}

Can something like this be done within the get(map()) function?

2

No, the built-in map function does not support wildcard searches, and the searched value has to be exact and also case-sensitive.

The workaround is to use an Iterator and an Aggregator, with a filter in-between.

2 Likes
3

On further investigation, the map function does allow multiple values for filtering.

If the number of combinations/permutations of the wildcarded section is small, you could possibly provide all possible values. However this doesn’t seem to be suitable for your use case.

map (complex array; key;[key for filtering];[possible values for filtering separated by a comma])

2 Likes