i want to create a jira query to fetch all issues between two fix versions

[Manoranjan]

This is query i am using to fetch the issue details

projects in ("project_name_1","project_name_2") and issueType in (bug,story) and fixVersion >="10.0.0.01" and fixVersion <= "10.0.0.02"

but its giving issues which has other fixversions aswell

[Alana Fernando]

@Manoranjan,

Below statement is from this advance searching document 

Note that the comparison operators (e.g. ">") use the version order that has been set up by your project administrator, not a numeric or alphabetic order.

Verify version order in both projects. 

Also judging by the 2 version you mention in the JQL, I feel like you want to filter out issues that has fix version  "10.0.0.01"  or "10.0.0.02"

If this is the case. you may use below JQL 

fixVersion in ("10.0.0.01" , "10.0.0.02")

Reference: version order

[Manoranjan]

Manually i dont want to specify all the fixversions, i want to fetch all issues between the  specified fixversion for example from 10.6.7.00 to 10.6.9.10, is there any other mean.

[Alana Fernando]

@Manoranjan your Query has no issue. but you have to verify the version order that has between "10.0.0.01"  and "10.0.0.02" in both projects.

To do this,

1. Go to manage version page in both project.
2. Verify versions available between "10.0.0.01"  and "10.0.0.02".

Most probably the Other versions you mentioned might be available between "10.0.0.01"  and "10.0.0.02". 

[Ramaiah Pendli]

Manually open Releases in both the Projects and check the what are the Releases in between both versions then check for those fix versions to get the exact results.