Vikrant Yadav Community Champion

@Ram Kumar Aravindakshan _Adaptavist_ sql.close() is not required ? I think i must be closed after processing ? Please suggest

@Ram Kumar Aravindakshan _Adaptavist_ Intially i was trying without creating connection with the local database. I was simply trying to run script in script console. Now i have created local database connection having name local_db and SQL box is empty. Now i am trying to run below query :- it's giving me only single…

@sanjay_sapra Great! Glad to hear it fixed!

@Ram Kumar Aravindakshan _Adaptavist_ without creating DB connection i can't run SQL query in script console ?

Hi @Ram Kumar Aravindakshan _Adaptavist_ Thanks for the response. But still it's not working. Do i need to create Local Database connection using Resouces then below scriot works ? :- import com.atlassian.jira.component.ComponentAccessor import groovy.sql.Sql import org.ofbiz.core.entity.ConnectionFactory import…

For more knowledge you can explore this :- https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-jql/#api-rest-api-3-jql-autocompletedata-get

Hi @Nishant Sharma Instead of using JQL in REST API, i perfer to create filter and filter id, which is easy to use. If you still looking to GET JQL result via API then below video can help. https://www.youtube.com/watch?v=oSxBnqdF3-A Thanks, Vikrant Yadav

Hi @sanjay_sapra Sharing is done when you Edit Dashboard permission and you have to share filter also which are used in Dashobard gadget with them, then only they can see gadgets in dashobard. * share the dashboard to the group* open the dashboard * from tools drop down list, select "share dashboard" * from Add Shares…

Hi @IT Help Test connection in incoming emails. Is it pass or fail? thanks

Hi @GRASSO, Leonardo you should find cloud documentation here :- https://support.atlassian.com/jira-software-cloud/resources/ https://www.atlassian.com/software/jira/guides pdf is not available. For learning you can visit atlassian university :- https://www.atlassian.com/university Thanks

@Heinz, Michael Cool! Glad to hear it helps :)

Hi @Danielle Cantrell If you are looking for a free solution, you can try Status Time Free. otherwise you can use Structure plugin.Structure plug-in have inbuilt attributes that calculate time in status https://wiki.almworks.com/plugins/servlet/mobile?contentId=71042417#content/view/71042417 Or you can use Script Runner…

Hi @Heinz, Michael kindly follow below steps in order to share board . * On the top navigation bar, click Boards, then click View all boards. * For Find a board, type the Board name. * When the Board name you want appears in the list, on its row, click the ... button, then click Configure. * On the General and filter page,…

Hi @Alex Basile you can delete default board and create new board. It doesn’t cause any problem. New board will set as default board. thanks Vikrant Yadav

Hi @Linisha Jesh you want to update end date field value after a transition? As per the tags it seems that you are using Jira Cloud. In jira cloud behaviour is not available. In cloud You can do It via post function or via listener or use scripted end date field. 

Hi @Linisha Jesh Instead of behaviour it is better to use scripted “End Date” field. so that once you create the issue, system calculate sum and Put in end date Scripted field. Try below code replace between by addTo Replace Lower Date field and higher date field with Start date and duration respectively. import…

Hi @Richard Lucas Use something like this :- (status changed FROM "in review" TO "resolved") AND assignee = vikrant-yadav2 status changed from x to y on <date> by <username> AND assignee was <username> on <date>

Hi @anjali gola You can add JQL as Quick transformation. Select Extend transformation. https://wiki.almworks.com/display/structure/Using+Transformations

Hi @Alexandre Berger Welcome to Atlassian Community! If i am understanding your question correctly , you want to transfer/assgin tickets to someone else , right ? If yes, you can do with the help of Bulk Operations. In Issue Search >> Search the issue which you want to assign to someone else >> Select Tools > Bulk Change >…

Hi @Martin Bayer _MoroSystems_ s_r_o__ It works....i hadn't try to run it as admin user. I was using logged in User. Thanks a lot, mate Cheers Vikrant Yadav

Hi @Martin Bayer _MoroSystems_ s_r_o__ Thanks for the reply. Here is complete Custom Script Post function , What do i need to add so that this post fucntion run as Admin. So that users can perform this transition. import com.atlassian.jira.component.ComponentAccessor import com.atlassian.jira.issue.label.LabelManager def…

Kindly close allowed option at end with )

Hi @Jacob Francois working script ,, use behaviour.. import com.atlassian.jira.component.ComponentAccessor import com.atlassian.jira.issue.Issue import com.atlassian.jira.issue.IssueManager import com.atlassian.jira.issue.CustomFieldManager import com.atlassian.jira.issue.fields.CustomField import…

@Martin Bayer _MoroSystems_ s_r_o__ please suggest 

@Evgeniya Slinko @Check out this video for creating issue via Rest API in JIRA cloud :- https://youtu.be/UBxxuSGi4j0 https://blog.developer.atlassian.com/creating-a-jira-cloud-issue-in-a-single-rest-call/

@Hana Kučerová Thanks a lot , it works.. ..great :)

Hi @John Kurre JQL is used to search required issue. With the help of JQL you can search issue which you want to close and do bulk operation, to transition the issues. yes . You can transition issue using Rest API Post call. Below link helps you to transition issue.…

@Gavin Locate your Workflow: > Issues > Workflows Click Edit under Actions for your workflow Select your "Done" transition, and Click POST Functions Click 'Add POST Function > Select 'Update Issue Field' Select Resolution for Issue Field and the appropriate Field Value

@Guillaume Mackowiak You can test Regex validator on :- https://regex101.com/

Hi @Guillaume Mackowiak Try Regex validator it allow all charaters , limit should be 1-50:- ^.{1,50}$ Explaination :- * . dot stands for all characters. Except \n for which you will have to use s DOTALL flag.