Inside drilldown tags - how to apply transformative operations on set tags - <set>

[GaryZ]

Can you apply transformative operations inside set tags from drilldown tags?

ex:

<drilldown>
 <set token="form.builds_tk">$click.value$</set>
</drilldown>

Would like to take the value captured from click value, split it (or regex), then use the first value.

ex:

<drilldown>
 <set token="form.builds_tk">mvindex(split("$click.value$", "-"), 1)</set>
</drilldown>

[GaryZ]

Awesome.... That worked. 

[bowesmana]

You can do some great stuff with eval in drilldown, but be mindful that there are some bugs with using more than one multivalue eval statements, e.g. this one fails

<eval token="k1">mvindex($row.key$, mvfind($row.name$, $click.value2$))</eval>

as it fails trying to call mvindex with the result of the mvfind.

Note also that the first element is element 0, not 1 if that was your intention.

[GaryZ]

@bowesmana You are correct.  I did have to change my index to point at 0 instead of 1

[ITWhisperer · Accepted solution]

Rather than using set use eval - try it like this

<drilldown>
 <eval token="form.builds_tk">mvindex(split("$click.value$", "-"), 1)</eval>
</drilldown>