Vikrant Yadav Community Champion

Hi @Ram Kumar Aravindakshan _Adaptavist_ just to let u know , that we can run SQL query without creating Local DB resource. Initial script provided by me was correct only mistake I was doing is using “ log.debug” I have changed to log.warn and it worked. Script console script make connection with database for this we no…

Hi @Rosauro For checking comment on a particular date, you can user below query, but it only works if you have ScriptRunner Plugin installed. project = "JIRA Support" AND issueFunction in commented("after 2019/01/31 before 2020/01/07") Thanks

Hi @Sagar Mahajan Below query give you complete list users along with Login Count, if login count is zero it means users never logged in. SELECT u.user_name AS [USER NAME] ,m.parent_name AS [GROUP] ,ua.attribute_value AS [LOGIN COUNT] ,u.updated_date AS [LAST LOGIN] ,u.created_date AS [CREATED] FROM cwd_user AS u LEFT JOIN…

Hi @Rosauro if you search by comment, the JQL query will only search for those issues which have been commented on, which means that all the issues without comments will be ignored. This issue is already sloved by Atlassian Team. Check out below link very helpful :-…

@Valerie Burns Report to Atlassian. Raise a ticket under Atlassian Support. 

Hi @Christopher Rampola Welcome to Community! Edit issue depends on the Project Permission. First check in which project role Approving Manager is added. Then go to Project Permission and check if that is added under "Edit Issue" or not. If that role is added under "Edit Issue permission" then Apporving Manager can edit…

Hi @Milica Popovic If the Addin is installed then it must be visible under My Addin. Click Insert >> Select My Addins. If JIRA Cloud for Excel is visible. Click three dots and select Remove. If not visible in my addins >> Then first click Trust this Addin then follow the steps mentioned above. First Login O365 account and…

Hi @Sagar Mahajan For No activity means those users which never logged in right ? User which not loggind into JIRA from last 1 -2 years, you can't delete those users you can only make them inactive. JIRA won't allow you to delete those users, if users is assginee, reporter , componet Lead or Project Lead. For Clean up…

Hi @Anupam Sinha You can do it easily with the help of Simple Scripted Condition which is a part of Script Runner and put this condition :- cfValues['Some Custom Field'] == 'Some Value' As you have mentioned it's a single line text field, value is not constant in this case. Condition might fail sometime if Agent name is…

Cool! Glad to hear it helps.

Hi @Hector Hood In this case you can use Script Runner REGEX validator for this, apply below code. It wont allow special char but allow space. ^[A-Za-z0-9 ]+$

@[deleted] Cool 😎 glad to hear it works. Let us know for any further concerns. Kindly accept the answer if solution works for you so that it helps others users. thanks

Hi @[deleted] enable wiki style Rendering from field configuration which mapped with project. in field configuration >> Search field >> Renders >> Select Wiki Style 

JQL is used to retrieve issues only. It show the list of issues created under project or create by a user. It is flexible and faster way to search issues.

If you don't want to use BEFORE AFTER use DURING status changed to "closed" during ("2020-06-03", "2020-06-07")

Hi @Milica Popovic In Excel online, there is no option to disable or enable plugin. You need to check with your Messaging team or IT team who is the Admin of O365. FOr disabling addon from excel , first open Desktop App or Click Open in Desktop App , Click Files >> Options >> Addin >> Select COM- Addon >> Untick JIRA addon…

Solution available here :- https://community.atlassian.com/t5/Jira-questions/JQL-for-tickets-closed-within-a-time-range/qaq-p/348531

Hi @Colin Young Welcome to Community! You can try something like this :- project = "JIRA Support" AND issuetype = "New Project Request" AND status changed to closed BEFORE "2020/12/01" AFTER "2020/11/30 00:00" Thanks Vikrant Yadav

@Sagar Mahajan Check it out to find user with last login :- https://confluence.atlassian.com/jirakb/find-the-last-login-date-for-a-user-in-jira-server-363364638.html SELECT d.directory_name AS "Directory", u.user_name AS "Username", DATEADD(second, cast(attribute_value as bigint)/1000,{d '1970-01-01'}) AS "Last Login" FROM…

@Coddess Ltd Cool, glad to hear that helps. Let us know if you have any follow up concerns. If this answer solved your issue,kindly accept the answer.

Hi @Sagar Mahajan If you have Script Runner plugin , you can do it with the help of Script Console. Get complete user details along with last logins. Thanks!

Hi @Ramanathan Hariharan This error comes when Sprint of the given name "Drop-1CustomerEngApp" not avaiable. Check Sprint with this name exists or not ? If exists then might be so spelling issue or Space issue. Type Sprint in double quots " Sprint Name" thanks

Hi @Coddess Ltd Welcome to Atlassian Community! Currently don't support the ability to change the URL of your cloud site You can't just change the URL, you'd have to do a cloud-to-cloud migration, see links below: * Changing the Cloud Instance URL Address or Migrating to a New Cloud Instance * More Easily Change Atlassian…

hahahaha! Nic, many time it happens people keep on searching Server Id on JIRA Cloud instance. i thought , you forget to mention this, so i decided to add this as well.

@IT Help Then might some issue in Mail Handler, check correct handler is selected or not. Check if email is coming from unknown/non-jira users. If users are non-jira then default reporter must be set or tick create user. Try to test the handler. Once you click on test jira pick are all unread emails from mailbox and create…

@Ram Kumar Aravindakshan _Adaptavist_ Thanks a lot, Mate!

@Peaqock Financials Server ID only available for jira server or DC. In jira cloud server id is not available.

Hi @Nathan You can do it with the help of Workflow post function which assign ticket to a particular person. Or you can follow steps mentioned in the following document :- https://confluence.atlassian.com/confeval/jira-service-management-evaluator-resources/jira-service-management-auto-assign-issues thanks

Hi @Nishant Sharma The latest version of the Jira Cloud platform REST API is version 3, which is in beta. Version 2 and 3 of the API offer the same collection of operations

@Ram Kumar Aravindakshan _Adaptavist_ Great, Result is correct now. But i want every value in next line. Currently complete result in same line. I want to append /n also, so that i can output come in next line. Where do i need to put /n in output ? Can i use this in our PROD server as well or it's risky touch JIRA DB ?