Use Table Transformer as Input to JQL Query

[Emily Berg]

Hello,

I have a table of issues that I would like to use as the input to a JQL query - essentially trying to do this:

I need a way to concatenate / sum all of the rows together into a single value:

INS-20218, INS-20217, INS-58952, INS-14935

The add the "Key in (" prefix

Then use the result as the input to the JQL.  Is this possible?

Thanks,

Emily

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @Emily Berg ,

I'm afraid, this case is not possible to implement.

The result of the Table Transformer macro will be always a table of some kind, it won't serve as an input (variable) for the JQL filter.

[Emily Berg]

Thank you for the response @Katerina Kovriga _Stiltsoft_ .  Would you have suggestions other than the use of a table transformer to accomplish this use case? Or do you know if the JQL macro doesn't support this type of input?

Emily 

[Katerina Kovriga _Stiltsoft_]

I assume your JQL Filter comes from something similar to this and this threads, so you are able to put plain text and variables inside its body.

Or maybe the macro comes from another 3rd party app? 

We've got the idea of your case but can't come up with any solution.

[Emily Berg]

I had not seen those posts so thanks for sharing the links @Katerina Kovriga _Stiltsoft_

Implementation looks a bit more complex than I had hoped but I will take a look. Thanks for the responses.