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.