Good day.
Recently I am experiencing issues in extracting data from JIRA with a help of JQL. Here is an example:
Task: To see, how many employees declined our offer since the beginning of the year.
First filter in use: filter = "Junior devs" and status changed to "Job offer" after "2018/01/01" and status in ("backlog","rejected","employed","declined offer","Not part of company","potential hire")
- "filter = "Junior devs"" links to proper board, issue type and all Epic Links that are considered Junior Developers
- "status in" limits filter to only finalized applications
This filter gives me all people whom we employed this year, and among this list I see, lets say, 3 people who declined our job offer. All 3 actions were done during this year (checked manually)
Second filter in use: filter = "Junior devs" and status changed to "declined offer" after "2018/01/01" and status in ("backlog","rejected","employed","declined offer","Not part of company","potential hire")
- nothing has changed except status in "status changed to".
This filter should give me only those who declined our offer (3, as we know from previous list), but we get only 2 results.
Does anyone has idea why such inconsistencies exist and how to overcome them? Problem is that it's not the only situation where I see such issues, and if in this case outcome can be counted manually, than in other cases its almost impossible.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.