Vikrant Yadav Community Champion

Hi @luo-yuanfu Welcome to Atlassian Community! When you Clone an issue, CLONE prefix added automatically to the new issues. You can check Link Type to see which issue is Cloned and which one is original. https://support.atlassian.com/jira-software-cloud/docs/clone-an-issue/ In Original Issues, you will find "is cloned by"…

@vasanth You can check this script : https://library.adaptavist.com/entity/deactivate-inactive-users-after-custom-period

Hi @vasanth import com.atlassian.jira.component.ComponentAccessor import com.atlassian.jira.security.login.LoginManager import java.text.SimpleDateFormat; import java.util.Calendar; import com.atlassian.jira.user.util.UserUtil UserUtil userUtil = ComponentAccessor.getUserUtil() def loginManager =…

Hi @Sruthi Susan Biju Welcome to Atlassian Community! Yes, you can use Jira JQL API to get projects issue data into CSV. You need to get data using Web in excel. Similar post : https://community.atlassian.com/t5/Jira-Software-questions/How-can-I-export-to-CSV-the-results-of-a-search-via-the-REST-API/qaq-p/2326134

@Monique vdB Thanks a lot for sharing the most active members list. It's great motivation for us who reached 50,000 points. Hope in 2024 i'll reach 100000 points Happy New Year 2024 to all my community members! Atlassian Community is the best community website, in terms of UI, easy to use, response and queries solved…

This is the single line text field not a Jira Sprint field, in text field IN operator won't work. Kindly ask Jira admin for Jira Sprint field id. 

Hi @Kalpathi Rajkumar Harishma Welcome to Atlassian Community! As per the error message, it seems that you are trying to do JQL on single line text field. I think duplicate sprint field is created in your instance. System Sprint field is of type "array" not Short text. Kindly search using Sprint field id for eg…

Thanks a lot @Nic Brough -Adaptavist- for providing further clarification.

Thanks @Max Foerster - K15t @BHUSHAN PATIL for your response! Yes in Backlog, I can move/arrange issue top, bottom as per my preference when drag/dropping issues to Sprint then again I need to arrange them. I was thinking a way to see the Ranking number so that when moving issue to Sprint jira automatically arrange issues…

@Thijs yes user must have create issue permission to create issue in a project. If you set default reporter then that reporter should have create issue permission in that project. 

Hi @Max Foerster - K15t Thanks again! I have to select Site under "Sites and Products" on left side panel, then it lands on a new page which gives all information. 

Hi @Max Foerster - K15t Thanks for your response! But on my site, Storage option is not available. 

@Asha Goyal have you checked with Smartsheet suppot team ? This is a free plugin if you own smartsheet license. 

@Shaikha alketbi What is the field type of "Meeting" field ? 

Hi @Shaikha alketbi Here is the sample script :- //Apply Scriptrunner behaviour on select list field def team = getFieldByName("Accuracy") //select list field def desc = getFieldById("description") //multi-line text field log.debug("dropdown value" + team.getValue()) if (team.getValue() == "Satisfied") {…

@Gerald Lewis That's Great! Glad to hear you solved this query!

Hi @Jess Williamson New Link :- https://we.tl/t-Wu7Gm9jNZq

@Andy Heinzer Can you please help us with SQL query ? I am not able to create SQL query to get details.

Cool! Glad to hear I am able to help you. Yes, you need to move issues from Backlog >> Board. Disable Backlog feature from Project settings, then all the issues will be visible on board. Group issue by Epic on Board. Kindly accept the solution if it works for you. It helps other user facing same issue. 

You're Welcome!

Hi @Asha Goyal If you have Smartsheet licence, then Jira Connector by Smartsheet is a free plugin provided by Smartsheet to its licensed users. . https://marketplace.atlassian.com/apps/1215530/jira-connector-by-smartsheet?tab=pricing&hosting=cloud https://help.smartsheet.com/articles/2388677-smartsheet-integration-with-jira

Hi @Gerald Lewis You can use the following MySQL query to find Project and Issue types mapped with Project :- SELECT P.pname, GROUP_CONCAT(DISTINCT I.pname ORDER BY I.pname ASC SEPARATOR ',') AS issuetypes FROM project AS P INNER JOIN jiraissue AS J ON J.PROJECT = P.ID INNER JOIN issuetype AS I ON I.ID = J.issuetype GROUP…

It seems that you enabled Backlog in Kanban Team Managed Project. You need to move issue from Backlog to Board, then only visible on Board. 

Hi @manaf basheer Welcome to Atlassian Community! Have you enabled Epic in Backlog ?

@Davide Astarita Have you created and started the Sprint ? Once you start the sprint, then only you can see issues in a board. 

Hi @Davide Astarita Welcome to Atlassian Community! In Backlog, are you able to see Epic Panel having Epics and Issues ?

@Kale Bullen For organization, you can use smart value in JQL query :- Organizations = {{issue.customfield_10002.name}} JQL : Organizations = {{issue.customfield_10002.name}} AND status = "In Progress"

@Kale Bullen You're Welcome! You need to modify JQL query for Lookup issues based on your requirement. I used simple JQL query. Using JQL filter out those issues on which you are working. Modify Compare two value Condition I used six replace it with 3. 

Hi @Kale Bullen For this you need to write a project automation rule, use Lookup issues Action to count the number of issues match JQL. 

@Evgeny Kracko Are you trying to add a comment via MS Team ?