I am looking for database query to get a list of all users based on internal groups who has access to restricted pages and also to list of all users who has access to unrestricted pages. So what woul...
I am looking for SQL query to get a list of all users who has access to restricted pages and also list of all users who has access to unrestricted pages. So what would the query to retrieve this i...
Team, we have a requirement to find 400 users associated date like no of projects user has access, assigned issue, reported issues, account active or not, user last login
I have been fighting with this for days without a satisfying result. I am loading data from Jira and need to transform it with Table Transformer to fit my needs. Example and columns: Key | ABC-6...
@Katerina Kovriga _Stiltsoft_ this is in continuation to the solution you provided here Solved: Conditional Formatting for Confluence tables (atlassian.com) I was able to apply that in my ...
Good Day! Just want to check if it is possible to deploy SQL Server repository to Live. I have found video showing pushing changes from SQL Server to bitbucket (https://www.youtube.com/watch?v=F...
...(connectstmt, props) // <3> def sql = new Sql(conn) try { String query = "SELECT cycle, line, prod, fcomp, sfcomp, pm, rnd FROM dbo.itrac_rnd" ResultSet rs = sql.executeQuery(q...
Dear community, I have a very specific requirement: For accounting reasons users have been grouped into user groups per department (Jira as well as Confluence). Now there should be a evaluation/l...
If a power user created a dozen automation rules with a massive defect, how would I delete them all. I don't want to disable them, I want to delete all of the references. Can I do it usin...
Hi community i struggled a lot to try to find a root cause with no success. I try to count number of test failed , number of test succees for requirements. I m using table transfomer to do some sl r...
Hi All, Brand new to both Jira and SQL so please bear with me! I'm using SQL to select the time worked on certain activities by employees. The base query works fine (validated via other means). H...
...dbc:postgresql:localhost:testdb', user:'', password:'', driver:'org.postgresql.jdbc.JDBCDriver'] def sql = Sql.newInstance(db.url, db.user, db.password, db.driver) def NameVM1 = customFieldObjects.findByName("N...
I am trying to build out a query that counts the number of users who can access each Space in Confluence. So far I have the following: SELECT DISTINCT s.spacename as Space, COUNT(u.di...
I'm migrating Bitbucket 7.8.0 database from one MS SQL server running MS SQL 2016 to another running MS SQL 2019. I'm not seeing any instructions on how to do this. Are there any other steps other t...
...ealize that this does not include tickets that were created prior to the date range but the team is actively working. Has anyone created a SQL formula like this? If so, would you mind sharing the l...
...ustomfield table in the tables provided by jira, ID, name I can understand but for project & issuetype names and field types are giving "?" value as the SQL result Can you help?
I am looking for a query to help me retrieve all of this information from the Jira database. The REST API does not include timeZone or locale | name | | displayName | | emailAddress | | time...
Hi Community I was wondering how can I extract more information from the 'Linked Issues' besides Issue Key. I have created created linked Jira tickets with bits of information. In confl...
Hi there, With community's help, I use Confiforms TableView as source table and Table filter, table transformer macro with SQL to do difference comparison of two columns of source table. H...
...hought that we could identify users who aren't active by their last comment date instead of last login date, and have been working hard to write a SQL query to pull this information from the Jira D...
I am getting support from a plugin and they want me to run a SQL query on Jira. I see a lot of information on SQL queries, but none on how to get to the location to type the SQL string. What am I m...
How to add in SQL select extra column (customfield (category))? Maybe someone has some kind of sql script? Now it looks like this: select ASSIGNEE, SUMMARY, concat(originalkey, '-',issuenum) as I...
Hi folks! We're in the process of adding SSO to our Jira and Confluence instances, but have a slight hurdle to overcome. Currently the naming convention for usernames is firstname.lastn...
HI everyone, I have access to DB at the backend of our JIRA Cloud instance. I am trying to build reporting and i want to create a JIRA hierarchy that will show me the Initiative - All the EPIC's lin...
Hi there, I tried to search the resources but got stuck and hope someone can help. My question is how to calculate the subtraction only using the filtered data? The source data is like bel...
Copied to clipboard