Hi Team,
According to https://jira.atlassian.com/browse/JRASERVER-36046, this is not possible but since this is 9 years ago like to confirm if is still the case.
In addition is there any plan this would be consider??
Regards,
DS
Hi @David So ,
What queries specifically would you like to run on the database? This other post may be helpful: https://community.atlassian.com/t5/Jira-Service-Management/integration-between-JIRA-Service-Management-cloud-and-MS-SQL-DB/qaq-p/1797241
Hi Carlos,
Is quite a big query, not sure if the KB https://community.atlassian.com/t5/Jira-Service-Management/integration-between-JIRA-Service-Management-cloud-and-MS-SQL-DB/qaq-p/1797241 works for Jira software, on top the response from Ravi Sagar _Sparxsys was to use scriptunner which is NOT feasible for us, any other options? I found add-on like https://marketplace.atlassian.com/apps/1217627/sql-reporter-for-jira?tab=overview&hosting=datacenter but is probably last resort if can be done from the app itself.
Summary, i.Assignee as Assignee, i.reporter as Reporter, priority, ISS.pname as Ticket_Status, Rez.pname as Resolution , Created, i.Updated, cv12.datevalue RESOLUTIONDATE, cv.DATEVALUE as DueDate,'' as analyst, cv4.DateValue as CompletionDate,cv3.DATEVALUE as StartDate, cv2.DATEVALUE as OriginalDueDate , cv5.StringValue as EpicName, co4.customvalue as Dept, cv7.StringValue as Metric, co.customvalue as Percentagecompleted, co3.customvalue as DataAsset, co2.customvalue as PriorityLevel, cv11.STRINGVALUE as SMEfrom jiraissue ILEFT JOINissuetype IT ON I.issuetype = IT.IDLEFT JOINissuestatus ISS ON I.issuestatus = ISS.IDLEFT JOINproject Prj ON I.project = Prj.IDLEFT JOINresolution Rez ON I.Resolution = Rez.IDLEFT JOIN customfieldvalue cv on cv.ISSUE = I.ID and cv.customfield = 19565 – DueDateLEFT JOIN customfieldvalue cv2 on cv2.ISSUE = I.ID and cv2.customfield = 21001 --OriginalDueDateLEFT JOIN customfieldvalue cv3 on cv3.ISSUE = I.ID and cv3.customfield = 21040 --StartDateleft join (select max(display_name) display_name, user_name from cwd_user group by user_name) u on u.user_name = i.Assigneeleft join (select max(display_name) display_name, user_name from cwd_user group by user_name) u2 on u2.user_name = i.REPORTERLEFT JOIN customfieldvalue cv4 on cv4.ISSUE = I.ID and cv4.customfield = 21016 --Completion DateLEFT JOIN customfieldvalue cv5 on cv5.ISSUE = I.ID and cv5.customfield = 10004 – EpicNameLEFT JOIN customfieldvalue cv6 on cv6.ISSUE = I.ID and cv6.customfield = 21041 – DeptLEFT JOIN customfieldvalue cv7 on cv7.ISSUE = I.ID and cv7.customfield = 16324 – MetricLEFT JOIN customfieldvalue cv9 on cv9.ISSUE = I.ID and cv9.customfield = 21069 – DataAssetLEFT JOIN customfieldvalue cv8 on cv8.ISSUE = I.ID and cv8.customfield = 21011 – PercentagecompletedLEFT JOIN customfieldvalue cv10 on cv10.ISSUE = I.ID and cv10.customfield = 21044 – PriorityLEFT JOIN customfieldvalue cv11 on cv11.ISSUE = I.ID and cv11.customfield = 21060 – SMELEFT JOIN customfieldvalue cv12 on cv12.ISSUE = I.ID and cv12.customfield = 14933 – resolvedleft join customfieldoption co on co.CUSTOMFIELD = cv8.customfield and cast(cv8.STRINGVALUE as integer) = co.IDleft join customfieldoption co2 on co2.CUSTOMFIELD = cv10.customfield and cast(cv10.STRINGVALUE as integer) = co2.IDleft join customfieldoption co3 on co3.CUSTOMFIELD = cv9.customfield and cast(cv9.STRINGVALUE as integer) = co3.IDwhere I.Project = 10000and Created > CURRENT_DATE + INTERVAL '-1 year
David
there's no way to run a SQL query through a REST API using builtin features.
Fabio
Yeah... unfortunately there is not a way to run the query using REST API in the native Jira.
It looks like you're new here. Sign in or register to get started.
