Tuncay Senturk _Snapbytes_ Community Champion

Hi @AisM I don't know what "-1" value means but it may probably be the code that your Jira admins set. The Resolution field is a very important field in Jira. If it is set to a value (no matter what), it means that the issue is closed. Resolution value specifies the reason an issue is closed. In Jira reports, this field is…

Welcome to the community @Manoj Kumar Varukolu !

Thanks @Jimmy Seddon Just like you, I will be participating in as many sessions as I can according to my agenda, mostly in ESM/JSM sessions.

Hi @Prakhar Vedsa I need clarification before answering this question. * Are you on Jira cloud or is it server/DC? * What do you mean by categories? Are they different statuses or issue types or any field of an issue? Thanks

Hi @AisM OK, I see! Please let me know if you have any issues. Thanks

Hi @AisM Those variable names come from the ones in your code. Getting the value from DB part was not in the code, so I had to remain it as below String strEIT = "value-from-db" value-from-db should be the value coming from the DB. below is the issue key, of course, it needs to be updated accordingly. Again, strEC was…

Thanks @Kristján Geir Mathiesen I can't remember how many times I've read Robinson Crusoe by Daniel Defoe and Treasure Island by Robert Louis Stevenson. I think it is time to re-read them.

Hi @AisM Have you had a chance to use the code above?

Thank you @Nikki Zavadska _Appfire_ and that's very kind of you!

Hello @AisM Sorry for the delay, I just had the time. Below is the updated code relevant to the one you already shared. Assuming, * you have got the DB value in strEIT variable and it holds the text of the drop-down, not the ID (just like in your code) * the strEC variable holds the issue which will be updated * epic…

Hi @Julian Yamid Torres Torre @Eugenio Onofre is correct, you can't trigger an SLA based on the linked issue's condition. You can only display the linked issue's SLA progress with that configuration.

Ok sure! Please give me some time. I will work on the code after business hours :) 

Hi @AisM Thanks for providing the details. @Nic Brough -Adaptavist- already provided how to update a regular drop-down using Script Runner. As far as I understand, you will use parentOption (which is Option 1 in your DB) to update the drop-down and you will remove those childOption parts from the code. Do you want me to…

Perfect as usual! Thank you indeed!

Hello Aisha @AisM :) Of course, I'll be glad to help. So, I think you have a cascaded field but you want to change it to a single drop-down and you want to change the scriptrunner code accordingly. Please share the code which will be a good start to update. I will check the code and help you change the relevant part. Best

I think yes, just raise them a ticket and see what they say

Hi @Tom Vines Those tables starting with AO_ are the tables which are used by plugins. As far as I know, AO_544E33 is the prefix for Email this Issue (JETI) plugin. Since it says AUDIT_LOG, probably it will be ok to back up the table and truncate but I'd clearly recommend checking the plugin's documentation or raising the…

Hmm, that's tricky. I'd iterate the change items array to find the first status value and use that value until it changes. I mean you have to iterate the list twice, the first iteration will be to find the status change if exists, whenever it finds the change it breaks the loop and moves on to the second loop.

I see, please let me know if you need assistance on that one. Thanks

Hi @Meldok Welcome to the community! Sorry if I misunderstood your question but as far as I understood you want to get the status of the issue when the issue was updated. As an example, assume the priority field was changed, you would have changeitem like field: priority, oldvalue:High, newvalue:Low However, you also need…

Hmm, I see! As I mentioned, I'm not good at Structure. You need an if statement here, like if it is Epic then it should be resolved in 15weeks. I don't think you can achieve that in a single JQL (sorry)

I think I could not get it. If you add issuetype = 'Container' to the query, it automatically excludes all Epic issue types no matter when they were resolved.

No worries @Aisha M I usually use the resolution field to filter out old issues, so it is a good idea to add AND resolution is EMPTY This will make your query only unresolved issues, however you might want to return recently resolved issues, in that case, you can use the resolutiondate field. As an example, if you wish to…

I'd be happy to help. Yes, adding due date restriction is possible and it would definitely filter out the results. So, if you're using Jira's duedate field, you can add the below statement to return only issues that have duedate of year 2022. AND duedate > startOfYear() However, if you want to exclude the issues which have…

Hi @Aisha M Hope you're well. I'd like to help but I am not good at Structure. However, if you clarify, I'd try to help, for sure! Best

Hi @Phillip Welcome to the community! As far as I understood, you want to clear the Fix Version field for the issues in one of your projects. Could you please try the following steps? * Open the issue navigator and write your JQL to filter out those issues * Click ... on the top right of the page and select Bulk change ...…

Thank you @Nikki Zavadska _Appfire_ and @Biro for the fantastic content!

Hi @Erin Freed To change the reporter of an issue, you need to be a Jira administrator or have Modify Reporter permission for that project. You can grant the permission under the project settings -> permissions page. However, if you want to change the creator system field, I don't think there is a way. I hope it helps!

Thank you @Biro and @Nikki Zavadska _Appfire_ as usual!