Tuncay Senturk _Snapbytes_ Community Champion

Hi @Jayaprakash Probably you are having similar problems with other apps' gadgets as well. Could you please check this article?

Cool! Thanks for sharing @Christine P. Dela Rosa 

Thanks @Jimmy Seddon 

I agree with @[deleted] , we need more details. My gut feelings say that it could be because of an Automation rule. In order to understand what's going on, check one of the issue's history (all tab) and see what's happening? Which field is changed. Devil is in details!

Thanks for informing @Ahmet Yilmaz 

It can return multiple columns SELECT projectid, second, third FROM ... and you can get anyone as ${it.projectid} ${it.second} ${it.third}

Yes, of course, you can use any SQL statement. Bear in mind that you have to use the same column name in your code which is returned from SQL statement. SELECT projectid FROM ... ${it.projectid}

Yes, the code above has the section (I believe it would work after a few touches) to get the list from the database Below the code, there is a section to put your actual code. if (projectIds.contains(event.issue.getProjectObject().getID())) { //your code here def cField =…

Hello Even the code is not complete and it is hard to guess but I think the script does not get the list from the Jira database. It works for the projects which are under the "Sub-domain" category in your Jira. There is a comment-out section in which I believe they first added infra project keys manually "ISPE,IRBR, ...".…

Haha, that's 'for sure' not a small snippet. This code gets a connection from the Jira database, executes select to the table (you need to change table name and column name part), and eventually, it checks whether the changed issue's project is included. So, your code will look like; import…

Hello again, I am not sure if it is a good idea (in terms of performance) to hit the database every time to get that list but this might be a solution. First, it gets the projectId values from the database table and collect them in projectIds variable, then check the issue's project Id. import…

Yeah, that's doable but still, there is a manual job. I mean you can get all projects list from the database table, but you would not know whether they needed to be used in that listener. To make it clear, assume you have 250 projects and right now you are synching (say) 100 of them. The question is where should the…

Ok, let me ask you another question then. Why don't you use a custom listener which is applied to Global (All projects) rather than selecting those projects manually?

Thanks for providing the script, but the mysterious part is not there. I need to know where are the projects stored? Is it the Jira projects or do you want to listen to the projects which are listed in a database table that is created by you just for this purpose?

In either case (whether it is a Jira database or an external database) I'd recommend checking Script Runner's Connecting to databases link. 

So, as far as I understand you need to connect the Jira database and get the result of the SELECT statement within your script linstener. Is that the case?

Hello @Aisha M Do you need to get the list of projects from the database? Wouldn't the script below help? import com.atlassian.jira.component.ComponentAccessor def projects = ComponentAccessor.getProjectManager().getProjectObjects()

Hi @Aytac Caliskan Welcome to the Community! @Mikael Sandberg is definitely right. On top of his answer, I believe that it might not only be related to workflow transitions. If you change Story point in the Edit screen (not a workflow transition screen), and the resolution field is set to "fixed", then it might be related…

Thanks for sharing @Erica, Thomas I really love the lozenges which give a bird's eye view.

Thank you @Nikki Zavadska _Appfire_!

Hi @siva As far as I understand you want to count the specific transitions. Assuming there are three transitions from Open status to Resolved status: * T1: Open -> Resolved * T2: Open -> Resolved * T3: Open -> Resolved you want to count only T1. If that's the case, I'm afraid Jira does not track the transition. It keeps…

Thanks for the update @Vishal 

Hi @Shakthi Oke Unfortunately, there is no way to do that unless you build your own JQL function. You can do that either by building your own plugin or creating a custom JQL function using Script Runner.

Hi ezeit@zpd.hamburg.de Welcome to the community! Did you have a chance to check this post?

I'd recommend Jira Software, for sure.

Welcome to the Community! You'll definitely like it.

We are very close to the solution. It seems that the workflow was changed and these issues stayed in invalid status. I'd suggest changing your workflow so it would support those statuses (TO DO, NEW,.. if there are more), then bulk transition all to a status which you want them to be.

Could you run the Integrity checker?

The code seems ok, but I'd recommend adding several warn level logs after each line to see where the problem is. 

Hi @Venugopal Paladi Yes, it is doable using an app. If you want to hide a transition based on a checkbox value, you can use Script Runner's script condition or a condition in JSU or JMWE. There are some samples, here are some:…