@dhandapani Comments are stored in the jiraaction table in the database. You can use the following KB to help you with your query. https://confluence.atlassian.com/jirakb/how-to-find-all-the-comments-related-to-one-user-in-the-database-385909306.html dhandapani Contributo...
Sometimes writing a query in a different way can yield speed improvements. However in this case there should be no speed benefits because of something called a query plan. A query plan is the code that SQL comes up with to execute the query. It takes the query and then creates an optimiz...
Adding my response to your query below:an epic having multiple stories to be picked up by multiple teams in different JIRA projects. The story should also show up on their board: There are 2 approaches you can take for this, for each Project Board you can configure t...
We can achieve this by using a combination of APIs and JSON Query. In the article, we will be fetching the details of all the attachments in a site and also customize it further to fetch issues with attachments greater than 2MB. More details on Jira APIs: https://developer...
Query will run as expected to complete upgrade Actual Behavior Bamboo fails upgrade task withUnknown column 'InnoDB' in 'where clause' Diagnosis Please run the following queries to confirm ANSI_QUOTES are enabled: SELECT@@GLOBAL.sql_mode;
In my case I am using GrumPHP to manage thecommit-msghook. GrumPHP has a JIRA ticket task, which we can set up in the yaml file like so: 1 2 3 4 tasks: git_commit_message: matchers: Must contain JIRA issue number: '/[A-Z]{3}-[0-9]{4} : (.+)/' ...
Sometimes writing a query in a different way can yield speed improvements. However in this case there should be no speed benefits because of something called a query plan. A query plan is the code that SQL comes up with to execute the query. It takes the query and then creates an optimiz...
Query being ran as apart of upgrade task 51012: SHOW TABLE STATUS FROM `%s` WHERE ENGINE != \"InnoDB\"" How to Replicate Install Bamboo 5.13.2 using MySQL with ANSI_QUOTES enabled Expected Behavior Query will run as expected to complete upgrade Actual Behavior Bamboo fails upgrade task...
Hi, I have been struggling with putting together a query to give me the results I need. I'm hoping someone here might be able to help. I want to be
P.S: The query above will return all the issues created at the time of the import, including the issues created internally on Jira. If any users were able to create issues at the time of the import or the import spent more time than the one you added i...