JQL to pull how a project was initially created - Scrum vs Kanban

Question

Hello,

I am trying to think of a way to pull what the initial template type was to create a project, whether Scrum or Kanban, to populate a status report. I can't think of the JQL because I am not sure if a field exists.

Seems like this info has to be somewhere in the Jira system since one has to select the template type (Kanban or Scrum) upon creating a project. Is there a way I, as a Jira Global Admin, can access that info via JQL or API? If so, what is the JQL or script?

If the answers to my questions above are "No", then can you advise on any other JQL or script that will definitively provide whether a project was created as a Kanban or a Scrum project?

Thanks for your assistance.

Note: My company is currently using Jira Standard but plans to upgrade to Jira Premium soon.

Fabian Lim · Accepted Answer

Hi @Apryl Harris

You will not be able to accomplish this via jql.

You may want to ask the adaptivist group, scriptrunner plugin makers, for some recommendations.

Regards

Bill Sheboy · Accepted Answer

Hi @Apryl Harris

Using the REST API, perhaps you could get all boards, filtered by the project, and compare the id values.  The lowest id is probably the first one for the project, and then check the type in the results.

https://developer.atlassian.com/cloud/jira/software/rest/api-group-other-operations/#api-agile-1-0-board-get

Kind regards,
Bill