How to configure notifications for breached SLAs in Jira Service Management Boris Berenberg Apr 02, 2025 Change the login and logout URLs for Jira server Zul NS [Atlassian] Nov 21, 2024 How to disable deduping of branch creation events Andrew Nov 02, 2018 How to customise number of "filters...
To address these scenarios, follow the steps and queries below to identify private filters and dashboards in your JIRA database: Login to the JIRA database. Run the following SQL accordingly: For private Dashboard: Postgres DB 1 select * from portalpage where id not in (select entityid fro...
Group names can also be used in filters and workflows, but just changing them with SQL statements would be too risky and could result in errors. You can run the following queries to get a list of filters and workflows that contain your group names, and then edit them in Jira. ...
As with most relational databases, there may often be situations where you need to combine the results of multiple queries into one single dataset when using Google BigQuery. Typically in BigQuery, this occurs when you’re gathering data from multiple tables or even across datasets, and this is...
Zendesk admin tip: You can use JIRA filters to see Zendesk tickets. Useful if you are trying to see how many tickets are directly linked to the JIRA issues.
Jira Data Center users can track issue status changes through built-in features that include the History tab and JQL queries. However, users need to open each issue separately or build complicated JQL queries to utilize these native Jira features. ...
Jira Service Management projects come with a default email address, or you can add a custom email address that is already in use by your team. To add a custom email account: From your service project, select Project settings > Email requests. Choose your email service provider and ...
Multiple JQL queries in a single report Selecting quot OR quot value of multiple filters You can vote on this request, https://jira.atlassian.com/browse/JRASERVER-25833 Thanks, Amith Mathur Maor Avitan Contributor December 29, 2019 Hi, none of this is good for me,i n...
There are times the Jira administrator may need to get a report of OAuth tokens issued for external applications for all users in the instance. This document provides a SQL query to get the list of OAuth tokens from the database. Solution Run the following SQL queries ...
We also have a new guide on how todownload SysAid on Windows 10, but the same steps can be applied if you’re using the latest edition on Windows. For any queries or to share what you like about Jira, drop a comment below.