...ira community, has shared an efficient SQL script that can help in identifying duplicated history records. You can find this script on GitHub: Detect Duplicated History Records Script WITH s...
Hello, I would like to display a table in Confluence that filters the tickets from Jira. The Acceptance Criteria should be displayed in the table. Is this possible? Or can I only filter according to...
I need an overview of all default PR reviewers from the database. I found the ao_9dec2a_default_reviewer table but I can not find the right table to join entity_id with. Any suggestions?
...eed to somehow split these fields apart, fill a large matrix with it and then might use it for the page properties report in the end. I gave it a try with the Table Transformer, however my SQL s...
...CSV. Can someone help me to create a working sql statement? Input: Table transformer table Table transformer Formula from a working example SELECT /*Calc NPS https://omf.ai/l...
...ption was the backend database (note this was before data pipeline was available as an alternative option). I thought it's SQL it's my "bread and butter" how hard can it be? Well ha, what a journey I...
Good day community, I would like to know how to split values in table transformer as it shows in the table below: COLUMN A COLUMN B Value A A, B, C Value B A/B/C ...
Hello community, I would like to receive support to something that maybe is silly to ask but I cannot find clearly answers about this topic. I have this initial table: And I would like through...
...ad max of 3 open tickets, min of 1. I have also access to backend Jira database in my organization, can query in SQL via Databricks, or use PowerQuery or DAX in PowerBI. But i don't have a...
...ashboard informando o código da sprint). É possível filtrar pelo SQL somente sprints em andamento? Não encontrei a condição.
...pencer) directly utilize their unique skills for table data processing, analysis, and visualization. So, let’s dive in. Confluence Tables and SQL Mastermind The sea of numbers and data is deep, so F...
Im looking a sequel query in mysql to fetch the below listed feilds in confluence spaces and pages . created by last modified /last updated date last viewed number of views incoming and outgoing...
Hello everyone, I want to build a Confluence table in which I have the following 2 main columns: Jira issue Confluence pages in which the Jira issue is mentioned on Does anyone know if this is ...
Hi everybody, I have added the Jira Filter Results Makro to a confluence page. The cells in one column contain multiple values (components defined in Jira), e.g. values like A10, B12, I30 and at t...
There are multiple attachments in each record (got from Confiforms which is downloadable on clicking). I want to Return those attachment in Table Transformer with SQL as it not r...
I want to create a hyperlink as Send mail in SQL query based on condition of Column There is an column with Email Id. Please help us to create a hyperlink based the email column with condition S...
...urrent Time stamp in SQL is giving error Suppose Last working date | Difference | Status 3/2/2023 355. &n...
Hi we would like to automate several SSO/SAML configuration, to export from and re-import to the SQL database (MySQL). Do you know which data (tables/columns/values) to export to get the c...
...n, Created by, Last Modified On, Last Modified By last viewed date I tried finding some related SQL query questions here but I do not see any that is getting information on the dashboard. So, if a...
I want to add a column in SQL(made from table transformer) using Alter Table I have written the code ALTER TABLE Table1 ADD STATUS varchar(255) But it is giving error like Parse error Expecting 'C...
I need to group people based on discipline, but cannot use any grouping that is already in structure, so I must use a custom group formula. After a ton of trial and error, I believe I have found a bu...
Hello team! I'm looking for the solution for the following inquires: 1) I need to find away how directly to export data (via API or SQL) about page viewers including names & roles a...
I have a ton of bugs and tasks but I want to see what departments/group/discipline they are in without using components, epics, or any other issue type. Lets say we have 4 people (I have man...
I tried the query below, but our jiraaction table has around 30 million records and it takes around 10 minutes to execute by each user. I need to consider de archived issues for this reason I can't ...
よくあるお問い合わせ Q-1. Automation for Jira で設定されているルールの見直しのため、スコープが特定のプロジェクト(単一プロジェクト、複数プロジェクト)に設定されているルールを取得したいです。対象の自動化ルールをSQLで一括で取得する方法はありますでしょうか。 Q-2. Automation for Jira 9.0.3 を利用しています。シークレットを利用してい...
Copied to clipboard