Hi, I would like to extract issues history details through excel macro (VBA Script) to know how much time each issue spent in each stage. Please help.
Hi @Naresh ,
Welcome to the Atlassian Community! Is there a particular reason you want to use a VBA Script? Jira has various ways to extract issue history and time spent in each stage but I've not yet seen a VBA Script do this.
Depending on your hosting type I can point a couple of ways to do this:
Let me know if you have further questions.
Cheers,
Gökçe
Thank you for your response! I need to check with our Admin if we are using Cloud or Server. Meanwhile, could you please share any any screen shot for how to access (where to find if it is there) Script Runner/API for cloud and Enhancer Plugin for server.
I didn't know there something like these exist, that's why I was thinking of using VBA script. But in case if I have don't have access to these plug ins (sometime companies don't purchase all the plugins), is there any script I can use?
Best
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Enhancer Plugin is linked here: Link
You can download it in your instance by navigating to Administrator menu > Manage apps > Find new apps > Type Enhancer Plugin for Jira
You Jira admin can set it up for you, just pass the name of the plugin to her/him.
As for the Cloud instance, Rest API is linked here: Link
As for the script for Cloud, the community has some answers I'm sure. I'll link it when I come across it.
Cheers,
Gökçe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.