Vikrant Yadav Community Champion

Yeah :( Let me check with Atlassian Support. Will post the answer here..once i get solution..

@Fabio Racobaldo _Catworkx_ I was also thinking the same, but when i searched without putting the issue key it gives me 10 issues, in which work is logged in both month by same user/same workauthor, while in some issue no work is logged by that author in Oct-Nov month even then displaying in the result. Please suggest :- 

FYI , Issue Key 3064 is a subtask. User is logging work in both task and subtask. Subtask and Tasks makes any difference in issue search ? 

Thanks @Fabio Racobaldo _Catworkx_ But it's not working as expected. It's showing zero result when searching :- In 3064 issue key, work is logged in both Nov and Oct month, when searching in JQL is showing No result found. 

Hi @Shrikant Pandurang Mandlik Similar post , kindly check this link :- https://community.atlassian.com/t5/Jira-questions/Scriptrunner-mail-handler-not-updating-custom-select-list-and/qaq-p/2005452 First create the issue, then try to update the issue fields. Reporter you can set before creating an issue. Thanks V.Y

Here is the working query for MySQL Database , which give the list of custom field which are EMPTY :- select count(*), customfield.id, customfield.cfname, cast([customfield].[description] as varchar(100)) as description from customfield left join customfieldvalue on customfield.id = customfieldvalue.customfield where…

Hi @Mohamed Benziane I have tried to add as NVARCHAR but getting error :- Incorrect syntax near the keyword 'as'. select count(*), customfield.id, customfield.cfname, customfield.description from customfield left join customfieldvalue on customfield.id = customfieldvalue.customfield where customfieldvalue.stringvalue is…

@chithra madhav Instead of changing the name, you can use Field Id. Anyways It's great news. Glad to hear i am able to help you out :) Kindly mark the solution as Accepted. As it help other people looking for same solution. Thanks V.Y

Behaviour mapping is correct ? Only one Sub-system field is available in Jira right ? Are these custom fields or plug-in fields?

Hi @chithra madhav If it's select list field then why not added issuetype.contains in your script. Anyways below script is based on select list field. Kindly mark the solution as accpeted if it works for you. Apply behaviour on Select List field :- import com.atlassian.jira.component.ComponentAccessor def application =…

Hi @aisling.curran Welcome to Atlassian Community! Kindly ask JIRA Admin to add Initiative issue type in a project. Issue type is missing in project. You already have Advanced roamdaps that's why "Plans" option is visible. In Free version, only Basic Roadmap available not Plan option. Thanks V.Y

Hi @James Lebron In my code, you won’t be able to transition the issue until you attach at least one attachment. When you attach an attachment , you won’t get an error message and issue get transitioned. In this you no need to attach transition screen, it works without transition screen. Give error message on view screen.…

Hi @James Lebron Try to add Scripted Validator :- It check Attachment should be empty. Atleast one attachment is mandatory. import com.atlassian.jira.component.ComponentAccessor ComponentAccessor.attachmentManager.getAttachments(issue).size() > 0

Hi @Boriz Agustin Thanks for sharing the script, you can try below script for updating Checkbox field options based on Issue Type :- import com.atlassian.jira.component.ComponentAccessor def issuetype = getIssueContext().getIssueType().name def optionsManager = ComponentAccessor.getOptionsManager() def customFieldManager =…

Hi @Boriz Agustin What is your scenario ? Are you trying to apply a Behaviour ?

Hi @Vini Vijayvargiya Welcome to Atlassian Community! Process Management project template is different from Software Development project template. In Process Management, you don't an option to create Scrum or Kanban board. Even if you add a Sprint field, you can't get an option to select Sprints which are created in…

Hi @Tobias Variable you can define as per the field name, if the field name is Application, you can create variable with name application. If you are trying to set default for select list field on a transition screen, you can use below script, replace bold value with your value :- import groovy.transform.BaseScript import…

Hi @Gonchik Tsymzhitov Thanks for sharing very informative post. Need your help in improving our JIRA DB performance. We are using MySQL DB, JIRA version 9.1.0, users are 8000+ , project :- 650+ DB Connection pool is so high, due to which JIRA performance is slow. What are the parameter i need to check in Database to find…

Hi @Tobias For adding Default value on Transition screen, you have to create Scriptrunner Behaviour of this and Limit behavior only to that Transition screen. Kindly check this document :- https://library.adaptavist.com/entity/limit-a-behaviour-to-a-specific-screen-in-jira Thanks V.Y

Hi @Amanda Busiello First you must have JIRA Admin permission and then go to "External System import" . Create one Test issue in the project in which you want to new Components. Copy that Issue Key and paste in CSV file in " Issue Key' column, copy the summary of that issue and paste in Summary column and add new…

You’re Welcome 😊 Happy to help!

@Cascapera Davide Thanks for the screenshot, Custom Request Type is not a Custom field, this is Scripted field or Programmatically field, that's why behaviour is not working. 

Hi @Cascapera Davide i have tested the script on my machine , Script is working fine :- Have you applied behaviour script on Select list field ? def application = getFieldByName("Application Count")//Select list field def description = getFieldByName("Description")//text field if (application.getValue() == "1"){…

Hi @Cascapera Davide Apply Scriptrunner behaviour on Field 2 :- Try below script it should work :- def field1 = getFieldById("customField_20600") def field2 = getFieldById("customField_10001") if( field2.getValue()== "my chooise"){ field1.setHidden(false) } else { field1.setHidden (true) } Thanks V.Y

Hi @Amanda Busiello I think you are trying to create Components in Bulk. Create csv file as suggested in Document, if you are using existing Test issue, then select Issue Key JIRA field for Key column, no to check Map this field and same for Summary field but for Components you have to check Map this field and try to…

Hi @chithra madhav Thanks for sharing the script. You applied script at wrong place. Add Script for Issue Type field. import com.atlassian.jira.component.ComponentAccessor import com.atlassian.jira.issue.* def issuetype = getIssueContext().getIssueType().name def selectcf = getFieldByName("Network _Category_Service…