I need to use JQL with my JIRA so that I can perform nested if then statements and do more extensive data hygiene on my JIRA database. I need to know how I can find out whether I have JQL and if so how to install it or start utilizing it?
Everyone has JQL provided they have access to JIRA. Simply put it is a search feature available to anyone who can access JIRA.
As for what results you will get, it depends on what project permissions you have. Your search would always only return results for projects and issues you can see in JIRA itself.
If you have a more specific question then do clarify.
Go to Issues > Search for Issues in your JIRA instance. See: https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-939938733.html
If you are using a script then please refer to JIRA Server API or parse your search via Rest API.
I hope this helps.
Your nested if conditions are simply as follows:
For example your question about about closed date(I am winging this as I am not using exact operator allowed based on fields):
((‘closed date’ is not empty AND statusCategory != Done) AND variable = ‘your variable’)
This is how you build nested conditions.
We are on a role. So here is one. So I have created 6 filters and brought them into a dashboard. Used a particular gadget to display all of them. Each one is signifies an error that needs to be fixed within JIRA. How would I create a bar graph that displays assignee Name at the bottom and total number of all the errors each assignee has? Which would be totaling up each filter/error. IS there a way to do that? Would I have to create a filter that totals all the other filters? Is that Possible?
If you would be ok with a 90 degree turn, just use seven filter statistic gadgets (yes, you'll need a 7th saved filter that includes all the definitions of the other six).
A filter statistics gadget's important parameters are "filter to summarise" and "field to group by". You can see where I'm going with the first, the second is obviously "assignee"
Hi after Nic Brought answered my last question. I have completed what he has stated. And it works. Now I built a graph that counts all the "Business Rules'" whic hare 6. Each business rule is a filter on my dashboard. then the graph summing all the issues within ewach business rule by following Nic's advice above. However it is counting each error within each business rule. However it doesn't count distinct errors within each business rule. Can someone guide me on how to do that within a filter? The filter that Nic has stated to build in his last post to me.
JQL simply finds issues that match a question. It has nothing to do with how you show the results to people.
You've say "distinct errors within a business rule". I'm not sure what you're looking for here, but JQL is just going to find a list of issues matching "issue has an error" or however else you are defining it. It's got nothing to say about what is inside the issue, it just finds them.
It's up to your reporting to think about "distinct errors" and "calculations".
I say "your reporting", but all we've looked at so far is the off-the-shelf reporting. I would guess that there probably isn't a gadget or report that can extract the errors, but I don't know how you're recording them, so I am not 100% sure. Equally, it would be hard to suggest an app that might be able to generate the report you need, beyond the very powerful ones that can do all-the-things like Eazybi
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events