Vikrant Yadav

Thanks @Aron Gombas _Midori_ I already have script for exporting JIRA Users Data in csv. No need of new plugin. :) Anyway, thanks for your help. I have fixed my script.

in Get Count of users whose last login time of last Calendar month Comment by Vikrant Yadav April 2023

@Aron Gombas _Midori_ Can you please help me with the correct script ?

in Get Count of users whose last login time of last Calendar month Comment by Vikrant Yadav April 2023

@Patrick Davis For this you can try to add 4 rule for 4 different fields, or you can add 4 changelogs smart value for each field.

in Have any recommendations for parsing the {{changelog}} string in Automation rule? Comment by Vikrant Yadav April 2023

Hi @Michael Nisperusa Arenas Welcome to Atlassian Community! I think you installed the wrong app in MS Teams. Install JIRA Cloud app in MS Teams for integrating JIRA Cloud with MS Teams. Kindly check doc :- https://support.atlassian.com/jira-software-cloud/docs/integrate-jira-cloud-with-microsoft-teams/ Thanks, Vikrant…

in Puedo conectar Jira Sever con Microsoft Teams en plan Free? Comment by Vikrant Yadav April 2023

Hi @Patrick Davis Try to get Old value and new value of Start Date using below smartvalue :- Old Value -- {{changelog.duedate.from}} New Value -- {{changelog.duedate.to}} Replace duedate with Start date Thanks, Vikrant Yadav

in Have any recommendations for parsing the {{changelog}} string in Automation rule? Comment by Vikrant Yadav April 2023

Hi @Fadli Fairuz Ramadhan Welcome to Atlassian Community! Are you trying to get latest comment and send comment to Slack ? You can use automation to get latest comment. Use smart value :- {{issue.comments.last}} Thanks, Vikrant Yadav

in How to get latest comment for create message to slack Comment by Vikrant Yadav April 2023

Hi @Lavanya Sreeramdas Welcome to Atlassian Community! Kindly check this document of creating Scripted Post function using Scriptrunner :- https://docs.adaptavist.com/sr4js/latest/features/workflows/workflow-functions-tutorial/post-functions-tutorial

in how to run groovy scripts and post functions in script runner Comment by Vikrant Yadav April 2023

@Andriy.Kuznetsov As per my knowledge, there is no method to get Quick filter history or change logs.

in Restore quick JQL-filter on Kanban Board Comment by Vikrant Yadav April 2023

Hi @Todor Gidikov Welcome to Atlassian Community! I think you are MS Teams "Incoming Webhook" app for getting notification on MS Teams channel. I suggest you to Jira Cloud for Microsoft Teams (Official) https://marketplace.atlassian.com/apps/1226478/jira-cloud-for-microsoft-teams-official?tab=overview&hosting=cloud…

in Automation message: Can "view in Jira " button become "assign to me" Comment by Vikrant Yadav April 2023

Then you have to write a code in Python which convert JSON response into CSV. I don't have experience in python, you can wait for other community member response, someone definitely know about this issue.

in How can I export to CSV the results of a search via the REST API? Comment by Vikrant Yadav April 2023

@Anibal Jodorcovsky This Excel trick save your time, and you don't need to export JIRA into csv again and again. Map only your projects fields in column. This is a one time setup, next time you only need to click refresh data. Above Screenshot feature is only available in JIRA. Using REST API you get data in json format.…

in How can I export to CSV the results of a search via the REST API? Comment by Vikrant Yadav April 2023

Hi @Anibal Jodorcovsky Welcome to Atlassian Community! You can export REST API data into CSV using MS Excel. REST API result in JSON, you can convert JSON data into csv OR you can use below method to get JQL Data directly into csv. Any changes in JIRA Issue also get reflected in Excel file, no need to export again or run…

in How can I export to CSV the results of a search via the REST API? Comment by Vikrant Yadav April 2023

Hi @Ismail Sanni Welcome to Atlassian Community! To get list of issues which are in "In Progress" only on 31st January :- status was in ("In Progress") ON "2023/01/31" AND status was not in ("In Progress") BEFORE "2023/01/31" AND status was not in ("In Progress") AFTER "2023/01/31" To get list of issues which are in "In…

in Please who can help me out with a JQL Comment by Vikrant Yadav April 2023

@Jyoti Kumari I don't think it's possible to hide pencil icon. You need to remove field from Edit screen, then only pencil icon get removed.

in How to hide fields from Inline edits through Script Runner Behaviour Template Comment by Vikrant Yadav April 2023

@Mahesh M Here is the Document :- https://support.atlassian.com/user-management/docs/give-users-admin-permissions/ Go to User Management >> Groups >> Add User to site-admins groups.

in how do i get jira admin access to be able to create new status Comment by Vikrant Yadav April 2023

Hi @Mahesh M Welcome to Atlassian Community! Kindly contact your JIRA Admin for getting Admin access on JIRA instance, or you can ask JIRA Admin to create status for you. Right approach is to ask JIRA admin for creating new status instead for asking JIRA admin permission. Thanks, Vikrant Yadav

in how do i get jira admin access to be able to create new status Comment by Vikrant Yadav April 2023

@Bohdan Hutkovskyy I never tried it before. You can try to send data in Confluence using REST API. Create App in Slack which send API request to confluence. Or you can try to get Slack Conversation in MS Power Automation using Slack API and send API request to Confluence.

in Can I push a Slack thread or question to Confluence Question? Comment by Vikrant Yadav April 2023

@Jyoti Kumari I think you applied script at wrong Field. On my side, it's working fine. Edit screen/dialog box is coming, not allowing to Edit Priority from view screen.

in How to hide fields from Inline edits through Script Runner Behaviour Template Comment by Vikrant Yadav April 2023

@Haig Aboyan Glad to hear I am able to help you 😊 I shared smart value for Business Owner field, I thought you are looking for business owner email address. For assignee, your smart value is correct. Mark the solution as Accepted, if your query is resolved. It will help others having same doubt.

in Could not send email, the 'To' address field is empty. If you have referenced a field it may be empt Comment by Vikrant Yadav April 2023

Hi @Kate , If you have Transition screen Then simply add Script Runner field required validator. No need to create custom validator.

in Sriptrunner validator on transition: to check commet is not empty. Comment by Vikrant Yadav April 2023

++REST API Doc :- https://docs.atlassian.com/software/jira/docs/api/REST/9.7.0/

in Get Updated Data Via Jira API Comment by Vikrant Yadav April 2023

Hi @Jozef Wakeman Welcome to Atlassian Community! You can get comments of an issue using this API :- https://jira.stage.com/rest/api/2/issue/VTPC-24/comment JSON data include All issue comments and update date. Thanks, Vikrant Yadav

in Get Updated Data Via Jira API Comment by Vikrant Yadav April 2023

Hi @Christian Radwanski Welcome to Atlassian Community! JIRA filter column display fields data only. JIRA stores data in field and column are fields and showing data stored in that field w.r.t issue key. If you want to capture First name only of the assignee or reporter, you can do some Automation and store that data in a…

in How to create a column in the filter with surname/last name Comment by Vikrant Yadav April 2023

Hi @mon.andres02 Welcome to Atlassian Community! Click on Cog icon >> Billing >> Select Manage >> Manage Subscription >> Delete. https://support.atlassian.com/subscriptions-and-billing/docs/cancel-your-site-subscription/

in how can i leave jira sites? Comment by Vikrant Yadav April 2023

Hi @Bernhard Müller You can import JIRA directly into Excel. Open Excel >> Data >> Select Data Source Web >> Enter JIRA JQL API For Eg :- https://jira.attlassian.com/rest/api/3/search?jql=project=ABCD >> Connect >> It opens Power Query editor. For Power Query editor, import data into table. That's it, you get JIRA data…

in Reporting across multiple projects Comment by Vikrant Yadav April 2023

Hi @Jyoti Kumari You need to apply Behaviour on priority field :- def priorityField = getFieldById("priority")priorityField .setAllowInlineEdit(false) //priorityField.setReadOnly(true) This script will won't allow editing field from view screen , it opens Edit Screen. Thanks, Vikrant yadav

in How to hide fields from Inline edits through Script Runner Behaviour Template Comment by Vikrant Yadav April 2023

The only option is to contact Atlassian Support team for this issue. Create support zip and share with Atlassian support. Atlassian Engineer will help you out.

in Exception: Uncaught TypeError: i(...).html is not a function Comment by Vikrant Yadav April 2023

Hi @Haig Aboyan Try to change smart value to :- {{lookupObjects.Business Owner.emailAddress}}

in Could not send email, the 'To' address field is empty. If you have referenced a field it may be empt Comment by Vikrant Yadav April 2023

Hi @Bohdan Hutkovskyy Kindly check official document for integrating Slack with Confluence. https://support.atlassian.com/confluence-cloud/docs/use-slack-and-confluence-together/ Thanks, Vikrant Yadav

in Can I push a Slack thread or question to Confluence Question? Comment by Vikrant Yadav April 2023

Hi @Gilad Shtern , Unfortunately, it's not feasible to open Create/Edit window in new tab. You can try browser extensions to open links in new tabs. For eg :- Open Links in Tabs For Create screen, you can do one thing Press Ctrl and click "Create" button, create window opens in new tabs. Thanks, V.Y

in Open create/edit issue form in a separate window? Comment by Vikrant Yadav April 2023

Vikrant Yadav Community Champion

Comments