Referring formula column in S-JQL

[Poojaa Sudhakaran]

Hello there,

Is it possible to refer formula column from Quick transformation - SJQL?

Could you please help me with the syntax if that's possible?

Thanks,

Poojaa

[Stepan Kholodov _ALM Works_]

Hello Poojaa,

Apologies for the late answer. It is not possible to reference a Formula column in a Quick Transformation directly. JQL queries are based on fields' values in issues and S-JQL queries can also be based on existing relationships between items in the structure. The Formula column is a Structure attribute that exists localy and it can't be recognized in either type of these queries.

So to be able to use the Formula column values in queries, you can do it either way:

- to write the Formula column's value to a Jira field. Then it will just become like any other field in Jira and it will be possible to work with it the same way, including referencing it in queries. Here is a short video of it can be done using Effectors:
https://youtu.be/QSreuWUQTp8

- to group issues in the structure by the Formula column(please note it might not provide clear results in all cases) and then you can reference groups, based on the Formula column values, in S-JQL queries.

I hope this helps. Please feel free to contact us directly at support.almworks.com if you need further assistance with the Formula column, we'll be glad to look into your use-case deeper.

Best regards,
Stepan Kholodov
ALM Works