We have 3 version fields that we use:
"Has error on versions" (ErrorVersion)
This one is set when a bug is found in a version or a ticket has some problem with that version;
"Has change on versions" (ChangesVersion)
This one is set when code changes related to a ticket is made in these versions; and
"Doesn't have error on versions"(NoErrorVersion):
To show that a bug isn't happening on a specified version(s)
We also use some sorta of semantic versioning (pattern A.B.C)
My problem is:
I want to find all tickets that still have error on version 1.3.x, for example.
This is what I want to query for:
(Pretend
MAX(X)
returns the biggest version of the X field)
TicketErrorVersion = All versions that are between 1.3.0 (included) and 1.4.0 (not included)
MAX(TicketErrorVersion) > MAX(MAX(ChangesVersion), MAX(NoErrorVersion))
Is there a way to do that?
