JIRA Query to find the list of issues updated in a month

As a process, we need to make an effort variance report every month for all the applications tested b y our team.  We use JIRA to log the efforts for each item.

Effort Variance = (Planned Efforts-Actual Efforts)/100

Following query may be used in JIRA to help:

project = TEST AND assignee in (“abc@xyz.com”,”pqr@xyz.com”,”ijk@xyz.com”) AND updated >= “2014/06/01” and updated < “2014/07/01”

The above query would list all issues for the project ‘TEST’ having assignee among ‘abc’, ‘pqr’ or ‘ijk’ which were updated in the month of June-2014.

The query can also be modified as per needs…:)