JQL Script for all offboarding Tickets

[Okey Onyeokoro]

I want to automate evidence gathering for compliance purposes, I need a JQL script that generates all offboarding tickets.

[Jonas Nilsson _ Unitlane]

One thing I would separate here is:

1. finding the offboarding tickets, and
2. preserving what those tickets can actually prove later.

JQL can help with the first part if your offboarding issues have a consistent project, request type, label, component, or custom field. But for audit evidence, I would also think about what the exported record needs to show after the ticket is closed:

- which offboarding request was reviewed
- which Jira/JSM evidence was available
- which records were missing or outside scope
- whether any limitation was accepted before handoff
- what artifact was exported or attached back to the issue

Disclosure: I work on Request Evidence Control for JSM. It is built for that second layer: running a coverage preflight on JSM evidence requests and exporting a review-ready evidence pack with visible limitations. If that is the direction you are going, it may be relevant:

https://marketplace.atlassian.com/apps/3851208244/request-evidence-control-for-jsm?hosting=cloud&tab=overview 

[Olga Cheban _TitanApps_]

hi @Okey Onyeokoro !

As the others mentioned earlier, JQL is used for search/filtering rather than ticket creation. However, there are other ways to automate the creation of offboarding tickets. 

If you are open to using third-party tools, I can recommend our solution, Smart Templates for Jira.

It allows you to create a standard set of Jira work items (or a single work item) and save it as a template for further use. After this, you will be able to automatically generate your offboarding ticket from that template.

Here's an example of an offboarding template for Jira. In this case, it's an epic containing a set of tasks with checklists. The template contains variables, such as {{employee_name}}. These variables enable you to easily adapt a single template for multiple uses.



Smart Templates has its own automation features and can also be used with native Automation for Jira.

Could you please provide more context about your workflow? Then I would be able to suggest more specific steps for setting up an automation rule. For example, it would be good to figure out what event could trigger this automation. How does the offboarding process work in your organization?

P.S. Here's an article where you can copy this template structure and find more details on how to set this up: Offboarding Template in Jira.

[Trudy P Claspill]

Hello @Okey Onyeokoro 

Welcome to the Atlassian community.

Do you mean that you want to create a JQL filter/search that will return to you the list of all offboarding tickets?

If so, are you familiar with how to search for tickets?

If you are not familiar with that, I recommend that you take advantage of the free, on-demand training available from the Learning link at the top of the Community pages. Here is a search to help you get started finding the relevant training material.

https://community.atlassian.com/learning/catalog?product=Jira&search=search&type=Course

The simplest search would be to get all the items that have the work item Type that you have specified as Offboarding.

You can use the Space selector to limit the search to items from only specified Spaces. An from the More Filters selector you can select other fields to use for criteria, such as selected the Created data field and specifying the date range for tickets of interest.

[John Funk]

Hi Okey,

JQL scripts cannot generate tickets. What are you actually trying to do? What is the exact use case?