JQL Query with Fixversion

[rochdi.badis]

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

[edwin vasquez]

Hello @rochdi.badis and welcome to the Atlassian community!

I've only seen this error when the value you are searching for doesn't exist. If there are no issues associated with that value, it will still search for all issues that apply. I created two versions, Testversion1 and testversion2. Testversion2 doesnt contain any issues and my query still ran successfully. I would double check that the "3.0.1 Altus Infringements" version exists and its spelled properly.

[edwin vasquez]

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

[rochdi.badis]

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

[rochdi.badis]

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