Vikrant Yadav Community Champion

@Dorin Shen Thanks for sharing. Good Stuff for new JIRA users :)

Hi @Harish You can do this easily, simply by inserting a Transition Screen for a transition on which you want to add comment and make Comment field required using Field Requried Validator. On transition screen , if you want to display any other field except Comment field, then no need to add any field on screen, insert…

Hi @Ganesh If you are using system field or Custom field "Description" then using FIeld Configuration you can't set Default value for this field. Edit option is for adding small description under field. If you are using Custom field "Description", then i suggest you to go to custom field >> Search for Description >> Click…

Hi @Tony Rice You can check this post ,it might help you :- https://community.atlassian.com/t5/Jira-Core-Server-questions/MySQL-query-to-list-all-project-roles-based-on-a-project/qaq-p/1137182 @Martin Bayer _MoroSystems_ s_r_o__ Kindly help us on SQL query. Thanks V.Y

Hi @[deleted] URL is fine. It should be clickable and open web page in new tab. I have tested on Text Field ( sigle line) , it's working. JIRA detecting the URL. If it's a multiline field , then it won't work. otherwise it works for Single Line text field and URL field. 

Hi @[deleted] Remove field from Edit Screen, if you don't want to edit this field. Thanks V.Y

Hi @[deleted] URL is always clickable. If you use URL custom field it would be great. If you are using Team-Managed Project , then i suggest you to use "Short Text" field. Text field also allow you click on URL and site open on next page. Please be sure url must contain domain like .com , .io ( for aha), .uk, .in etc...If…

Hi @Tony Rice By default, the 'Administer projects' permission is assigned to the 'administrators' group (via the Administrators role) for projects. JIRA admins never change Administer permission or remove Administrator from this permission. I think you need to check JIRA Database Schema for this and create a SQL query.…

@Christina Nelson Very nice Article :)

Hi @Narek Zohrabyan If i am understanding it correctly , you want to hide another field ( may i know type of this field) , based on this condition like Start Date = CurrentDate < -5 days ? Thanks Vikrant Yadav

@[deleted] Great :) ...Glad to hear it works for you! For login counts you can use below query and filter out those users having count greater then three :- SELECT user_id, display_name, updated_date last_login, attribute_value login_count FROM cwd_user a, cwd_user_attributes b where attribute_name = 'login.count' and a.id…

Hi @Warde Wynter Welcome to Atlassian Community! For your query, i suggest you to create a seperate permission scheme for each projects. In Browser Project permission allow some project role like Users, Developers etc. Remove any logged in Users or Anyone of the web from Browse Projcect permission. Once you set up…

Working Query :- SELECT user_id, display_name, updated_date last_login, attribute_value login_count FROM cwd_user a, cwd_user_attributes b where attribute_name = 'login.totalFailedCount' and a.id = b.user_id Hope it works for you!

@[deleted] Try below Query :- SELECT user_id, display_name, updated_date last_login, attribute_value login_count FROM cwd_user a, cwd_user_attributes b where attribute_name = 'login.count' and a.id = b.user_id

Hi @[deleted] I suggest you not to touch JIRA PROD Database, if you are not expert in SQL. In order to get the list users getting error "Reset Failed Login Count". For this you can do one thing :- Select "All" in User Per Page >> Click Filter> Export Data in Excel >> Apply Filter on Username Column . You get all users…

Hi @Jairaj K Only person with JIRA Admin permission can create new Resolutions in JIRA. Go to Issues > Issues Atributtes > Resolution > Create Resolution. If you want to see multiple Resolution options when issue moving to Cancelled or Completed status, for this i suggest you to insert Resolution Screen for these…

Hi @Andreas Schulz Welcome to Atlassian Community! You can restrict Delete Page permission for particular users, using Space Tools > Permission > Untick Delete option. https://confluence.atlassian.com/confkb/unable-to-delete-page-history-829074712.html https://confluence.atlassian.com/doc/page-restrictions-139414.html Hope…

Hi @Frankie Gonzalez Welcome to Atlassian Community! Space is a place in your Confluence, in which you can put related things, such as content, pages, and documents. Spaces provide you with the opportunity to collaborate on a project with your team or a group of people. Each space has its own permissions, which assign…

Hi @Stanley Han You need the Confluence Administrator global permission to do this. To disable a user account: Go to > User management. Search for the user you want to disable. Choose Disable. https://confluence.atlassian.com/doc/delete-or-disable-users-138318.html Thanks, V.Y

@Sandy Really helpful for Admins.

@Leon I agree with @Anthony Martin If you follow the steps mentioned in Link :- https://www.pei.com/whitelist-email-office-365/ ..it definately works for all email address. I worked on O365 Admin Center, you need to put only domain not complete email address. Thanks V.Y

Hi @Leon This related to Email Server. For this you need to check with your organisation Email Admin or O365 admin team. They need to put @Atlassian.net domain into whitelist. Hope it works for you! Thanks V.Y

@Patricia Francezi_iDev_ Great IT GIRL at Olympics .. now IT GIRL at Atlassian . wow 🥳🏆🎖

@Nic Brough -Adaptavist- Yes, you are right. with the help of plugin we can create Issue picker field. In JIRA Custom field list, issue picker is not avaiable. Thanks for correction. 

Hi @Mahima Srivastav Yes, Issue Picker custom field is avaiable in JIRA. Both Single Issue and Multiple Issue Picker field is available. But in JIRA Cloud..Issue Picker field is missing . https://support.atlassian.com/jira-cloud-administration/docs/custom-fields-types-in-company-managed-projects/ Thanks V.Y

@Vineela Maddala Yes, file size also creates issue while uploading attachments. You can modify the file attachment size. Kindly check below document :- https://support.atlassian.com/jira-cloud-administration/docs/configure-file-attachments/ Thanks, Vikrant Yadav

Hi @Vineela Maddala Welcome to Altassian Community! it's a known issue. Try to remove special character from the file name. https://jira.atlassian.com/browse/JRACLOUD-71507 https://jira.atlassian.com/browse/JRACLOUD-70142 Thanks, V.Y

Hi @Tony Rice Try below query to get list of users added in Administrator project role for all JIRA projects. SELECT p.pname, pr.NAME, u.display_name FROM projectroleactor pra INNER JOIN projectrole pr ON pr.ID = pra.PROJECTROLEID INNER JOIN project p ON p.ID = pra.PID INNER JOIN app_user au ON au.user_key =…

"Stop chasing the kudos and start chasing the passion." Just Kidding....

😎 Glad to hear it works for you!