Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you will find the site temporarily inaccessible. Thanks for your patience. Read more.
×Have more fun with Kudos
- Collect badges and make progress
- Participate in fun challenges
- Climb up the leaderboard
- Gift Kudos to your peers
Community resources
Community resources
Community resources
- Community
- Tag: sql
Tag: "sql"
-
Is there any way like ServiceNow in JIRA SM to insert incident details when there is an update on incident to a DB within JIRA, so that I can poll (retrieve) all the events periodically? I know Servi...
-
Dear Community, I am scratching my head about something: I am looking for all filters to find outdated onces. I tried 2 approaches: 1. SQL (table searchrequest) 2. Java API (via S...
- Jira
- Question
- api
- data-center
- database
- filter
- java
- +3 more tags...
-
-
I want a list of jiras created against each issue type under all the project from jan 2024. I am using below sql but it doesn't return list of those issue types where no jira was created from above m...
- Jira
- Question
- cloud
- database
- jira
- jira-software
- jql
- +2 more tags...
-
-
Hello, We recently have changed our jira instance URL. However, the avatar_URL is still pointing on the last URL making it impossible to show a user's avatar. I need help with sql query to u...
-
Hi Team, how to get list of all projects, project name and project category name in Jira Data Center or at least omit pagination on All project types - All categories page
-
I want to create a filter which shows me all tickets which are linked to a specific epic. How is the JQL command for this? It does not work if i use the command for text. I just end up with the epic...
-
How can I populate report on confluence based on SQL query and connecting other databases like Snowflake ? I am maintaining table manually in Confluence and I want to populate one o...
-
How can I populate report on confluence based on SQL query and connecting other databases like Snowflake ? I am maintaining table manually in Confluence and I want to populate one of the c...
- Confluence
- Question
- cloud
- confluence
- reporting
- snowflake
- sql
-
-
Hello, I'd like to generate the Recently Created Issues Report using SQL in Postgres and visualize it in a 3rd party BI. Well, I learned that SQL is not the best way but is there a chance? W...
-
I’m using the below SQL in a Table transformer Macro to group epic information (in table 1) and subtasks information (in table 2 - an epic might have more than one subtask). Note: T...
-
Hi All I'm looking to use this sql from the below sql query to get the artifact sizes per deployment project Useful SQL queries | Bamboo | Atlassian Documentation &n...
-
Hi all, I am using Table transformer on JIRA data (custom fields). I am trying to cast a field which is string data into an integer so I can use number equations on the data. I can't seem to...
-
Hello, Basically I would like to know how to build the table with the columns provided by the JIRA macro, using a query that is not giving values. This is a issue because as the macro doe...
-
Hi. I'm trying to create some sql to easily determine if a value in one of my table columns contains a valid number. My first attempt is to use the SUBSTRING function to extract the n...
-
...nd the database is PostgreSQL. Actually, we do not change anything only we restored the backup. However, we are facing an issue while restoring the SQL backup when trying to open the Jira web site, a...
-
Hi There, I have a table which is wrapped in multiple table transformers as I could not get them in one. Could be a limitation in my sql coding skills or maybe the macros work this way...but would w...
-
In the filter issue query, I would like to see the list of features linked to the Portfolio epic with the relationship "Split to". Currently I can see all the issue linked to the porfolio epic (issue...
-
...ontains a section for automation, JQL, SQL, REST APIs, and wiki markup. I also plan to add a section for frequently used website snippets using HTML, CSS, and PHP. Any reusable content is welcome. E...
-
Hey all, How can I do in table transformer to find between a line of text, a specific section to move into a new column? the idea is every selection of text applied in the SQL query, will be l...
-
I wanted to add the following to my SQL query (I use Confluence->Table Transformator): I wanted to output the total number of G1 projects and separately the total number for G2 p...
-
I have a SQL to format output using FORMATWIKI. I use the same function in multiple places in Confluence using table transformer. Every time I update the SQL, I need replace the SQL code in m...
-
Hello everyone, I would like to see if exist the possibility through Table tranformer to group cells and keep them in some way to the format: For example having a initial table like this: ...
-
...eady for Release, Closed I've wrapped my pivot in the ‘Table Transformer’ Macro but I can't get the SQL right, please can anyone advise please? SQL code: SELECT T* ORDER BY COLUMN.status CASE W...
-
...articular customer: When making a GET http request to /rest/api/3/label, an error 500 is returned with whole sql query being printed in the http response. How or where can we report it to Jira? W...
- Jira
- Question
- cloud
- jira
- jira-cloud
- sql
-
-
Hello, I would write an SQL Code for a table to make an x in a colume if a certain story is under the epic. Is there a code for it? Thanks!
- Jira
- Question
- data-center
- jira
- jira-data-center
- sql
-
Copied to clipboard
- FAQ
- Community Guidelines
- About
- Privacy policy
- Notice at Collection
- Terms of use
- © 2025 Atlassian