JQL Query with Fixversion

Question

Hi,

I'm using this query to generate all release tickets where fixversion in the below criteria

filter = "all Release tickets" AND "fixversion" in ("3.0.50 Altus Inspections","3.0.1 Altus Infringements")

But I'm getting this error:

The value '3.0.1 Altus Infringements' does not exist for the field 'fixversion'

because there no tickets with '3.0.1 Altus Infringements' fixversion, so why the query doesn't at least pick tickets with "3.0.50 Altus Inspections"? knowing that if I use : filter = "all Release tickets" AND "fixversion" in ("3.0.50 Altus Inspections") I get all related tickets?

Thanks

rochdi.badis · Answer

with regular databases a query like (select * from tablename where fieldname in ("a","b")) and if there are no records with "b" the query will still generate all records with "a" criteria and ignore "b", but this not the case in my case where it's not ignoring the "3.0.1 Altus Infringements"  Criteria and not generating any records from  "3.0.50 Altus Inspections"?

Thanks

rochdi.badis · Answer

Not sure ,but what's the point of checking the spelling or existence of "3.0.1 Altus Infringements" because as I mentioned there are no records for it , but I was expecting to get records with "3.0.50 Altus Inspections" fixversion to be generated at lease similarly to any DB management system isn't ?

Thanks Edwin

edwin vasquez_f9df79 · Answer

Hope this answers your question. If not, let me know.