I'm building a small wrapper to automate some tasks and when modifying the API query parameters in a specific way, I get the following 500 error. SQL Exception while executing the following:SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value FROM dbo.entity_property WHERE (ENTITY_NAME=? AND…
Hi, I use the table transformer macro in confluence to display Jira tickets. The jira tickets have bilingual content in the decription field. I try to seperate via SQL query by the SPLIT or SUBSTRING function with a separation character (#) Example: SUBSTRING(T1.'description',1, INSTR(T1.'description', "#")-1) AS…
Hi, I am trying to essentially take this JQL query and put this into Analytics: - project = <Jira Project> AND type = Bug AND (Sprint IN futureSprints() OR Sprint = EMPTY) AND status NOT IN (Done, Cancelled) I want to find all the bugs in a project that are apart of future sprints and not apart of any sprints. Here is the…
I am writing a script that will eventually become a job designed to remove all permissions of users who no longer have a Confluence license. The script works great when I feed it usernames directly. However when I pull all inactive users via a SQL search I get the error: JDBC exception on Hibernate data access:…
Hi, I do a number of Confluence pages that combine data from different sources. Typically I use an SQL Query for one table and a JIRA query for another, then use Table Transformer to run an SQL query based on both tables. (I may nest the JIRA table in it's own Table Transformer to convert some fields, date formats etc - I…
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 Service Now provides this as custom tables but I could not find any thing in JIRA SM? Please share any insights.
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 SearchRequestManager) The issue I am facing: Both methods return for filter A an author (aka owner, right?) B. BUT: the Jira UI lists the same…
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 mentioned date. SELECT p.pkey AS project_key, it.pname AS issue_type, COUNT(i.id) AS issue_count,…
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 itself.
It looks like you're new here. Sign in or register to get started.