Our company is running JIRA server 7.X with JIRA Service Desk as an add on. The version of JIRA Service Desk we are running includes the ability to create and add Organizations to help share requests - very cool feature.
Our company has over 4,000 employees. We use JIRA Service Desk to process employee time off requests. When a time off request is entered in the Service Desk, it is added to a Team Calendar in Confluence. Every employee in the company uses the same Team Calendar in Confluence to view time off requests, but people are only able to see the requests they have permission to view. So in other words, though people are all looking at the same calendar, they only see their own requests, or the requests that are shared with them.
We use JQL filtered JIRA issue event types to pull this off. As an example, the JQL filter we use to show someone their own leave on the Team Calendar is:
project = LV AND reporter = (currentUser())
Our employees also have the option of sharing their request with other employees using one of two different ways.
1. On the time off JIRA Service Desk form, we have created a custom field called "Shared with". Employees who are requesting time off can enter other employee names in the "Shared with" field on creation (comma separate value list of user names). When the time off request is submitted, a workflow post function adds the list of user names to the "Request participants" field in the Service Desk. The request is shared on the Team Calendar.
2. Or, employees can add an Organization to their request. The Organization is pre-populated with user names. This makes it easier on the employee who is requesting time off if they want to share their time off request with a large group of employees, and don't want to type each name individually.
Regarding #1, it's easy to come up with a JQL filter to show a user requests based on whether or not their user name is included in the "Shared with" or "Request participants" field. It looks like this:
project = LV and (currentUser()) in "Shared with"
However, for #2, I have no idea how to write a JQL query to determine if (currentUser()) is in one of the Organizations that was added to the time off request.
Does anyone know how to write this JQL query?
Susan, thank you for your reply. I agree. It is such a great capability to be able to add Organizations to Service Desk tickets. Sharing becomes so much easier. However, we need to be able to harness the power of JQL to meet all of our needs. Hopefully Atlassian will provide some fixes soon.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
...+ reading Fantasy). The same is true for him at the bank he works for: Efficiency is key when time literally equals money. Read on to learn how Sergey makes most of the time he has by...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs