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

[Apryl Harris]

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.

[Bill Sheboy · Accepted solution]

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

[Fabian Lim · Accepted solution]

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

[Apryl Harris]

OK - cannot access with JQL.

My company does not have scriptrunner.

Is there a way to access via Java or some other programming language? If so, what's the code?

Thank you.