Archiv der Kategorie: Atlassian JIRA

Atlassian JIRA+MS SQL Server Get values from multiple version picker custom field in SQL / Mulitple Version Picker Werte über SQL Query erhalten

Problem The version strings of custom field, that can select multiple versions, shall be selected Approach – Ansatz The table projectversion can be used to connect to CustomFieldValue.NUMBERVALUE Solution – Lösung SELECT pk.PROJECT_KEY+‘-‚+CAST(a.issuenum AS varchar(max)) as issue, pv.vname FROM project_key … Weiterlesen

Veröffentlicht unter Atlassian JIRA, MS SQL Server | Hinterlasse einen Kommentar

JIRA SQL: Get Issue count of Issue Types and Issue status of alle JIRA projects / Anzahl der Issues pro Issue Type / Status pro Projekt

Problem Für alle JIRA Projekte soll die Anzahl der Issues pro Issue Type und Issue Status ermittelt werden. Ansatz – Approach SQL Database Query Lösung – Solution SELECT project.pname ‚Project‘, issuetype.pname ‚Issue Type‘, issuestatus.pname ‚Status‘, COUNT(project_key.PROJECT_KEY+‘-‚+CAST(issuenum AS VARCHAR(5))) ‚Count‘ FROM … Weiterlesen

Veröffentlicht unter Atlassian JIRA | Hinterlasse einen Kommentar

Atlassian JIRA+MS SQL Server: Get selected custom field value for Issue from JIRA Database in SQL

Problem A selected custom field value, that is in a MS SQL Server JIRA Database should be retrieved. Ansatz – Approach The tables project_key, jiraissue, CustomFieldValue, customfield and customfieldoption have to be joined Lösung – Solution SELECT pk.PROJECT_KEY+‘-‚+CAST(a.issuenum AS varchar(max)) … Weiterlesen

Veröffentlicht unter Atlassian JIRA, MS SQL Server | Hinterlasse einen Kommentar

JIRA 6.x SQL Statement: Get actual value / last change for custom field

Problem The actual value of a custom field from an Issue should be selected Solution select CAST(pk.PROJECT_KEY as VARCHAR(10))+‘-‚+CAST(issue.issuenum AS varchar(10)), cfo.customvalue FROM CustomFieldValue cfv INNER JOIN CustomField CF on CF.Id = CFV.CustomField INNER JOIN CustomFieldOption CFO on CF.Id = … Weiterlesen

Veröffentlicht unter Atlassian JIRA | Hinterlasse einen Kommentar

JIRA 6.1. and above: Database field PKEY is empty

Problem In prior versions than JIRA 6.1., the table „jiraissue“ in the database has stored the Issue IDs and has made it possible to make a selection on Issue IDs. Unfortunalety this field is empty now. It is not possible … Weiterlesen

Veröffentlicht unter Atlassian JIRA | Hinterlasse einen Kommentar