Searching for values in tables in description

adambadura May 30, 2021

Our team does some evaluations of JIRA tickets by filling a table located at the beginning of the description. Something like:

h1. Evaluation
||Component||Value||
|A|123|
|B| |
|C|456|
|D|0|

Now, I would like to make a search that orders its results based on the "Value" of a given component.

Alternatively, I would like a search that shows only items in which the "Value" of a given component is 0, non-0 or empty (three types of searches).

Is this even possible? From my experimentation, it seems that searches with

description ~ "|A|0|"

don't work as if they didn't even analyze the "text" of a table.

I know that keeping such formal data as a table in the description is a poor idea and leads to such problems. However, I have little impact on the formal side of the JIRA we use, especially that this solution is used only by our team, not the rest of the company.

0 answers

Suggest an answer

Log in or Sign up to answer