Table Transformer: How to do a global RegEx search via ->match() properly?

[Stephan Bauer]

I am not sure if the 'g' flag is not working for RegEx searches via js in the Table Transformer plugin or if I simply do something wrong...

What I want to do now is find the latest sprint an issue was assigned to.

Fortunately we have a defined numbering scheme which is included in every sprint name of every team.

So my plan is to pull issues from JIRA, do a global regex on the content of the Sprint field, sort the result (which should be an array of Sprints according to our naming scheme) and pop the last item.

So, in theory, this should do it:

SELECT *,
       T1.'Sprint'.match("/[0-9][0-9].[1-5].([1-6]|IP)/g")->sort()->pop() As 'Latest Sprint',
  FROM T1

Unfortunately it seems that using the "g" flag leads to an empty result.

Any ideas?

P.S.: The markup for an example table

||Key||Sprint||
|MC20-2943|MC20-23.2.1 (Feb 26) MC20-23.2.2 (Mar 12) MC20-23.2.3 (Mar 26) MC20-23.2.4 (Apr 09)|

[Katerina Rudkovskaya _Stiltsoft_ · Accepted solution]

Hi @Stephan Bauer,

Please modify your SQL query as following:

SELECT *,
MATCH_REGEXP(T1.'Sprint',"[0-9][0-9].[1-5].([1-6]|IP)", "g")->sort()->pop() As 'Latest Sprint'
FROM T1



This query should be working fine.
You may also read more about the MATCH_REGEXP function here (the second table, row #145).

[Stephan Bauer]

Thanks, this works for me.