Monatsarchive: November 2019

QWare Risk Manager SQL Statements / Query

The following statements can be used to get the Risk Measure Tree from the Bayoonet QWare Risk Manager First you should create the view QWareSegment: After that you should create the view QWareImport that gives us the Risk Measure Tree: … Weiterlesen

Veröffentlicht unter Allgemein | Hinterlasse einen Kommentar

Atlassian JIRA mit MS SQL : Select the text, date or string value from a custom field of an issue

Problem A string, date or a text-value of an custom field shall be retrieved from an issue Solution

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

Atlassian JIRA MS SQL Server: Get Affects version or fixed version from the Database by query

Problem To fetch the values „Affects version“ or „Fixed Version“ from the JIRA Database via SQL, the use of different relations/tables is necessary Solution – Lösung You can use the ASSOCIATION_TYPE=’IssueVersion‘ for Affects version and ASSOCIATION_TYPE=’IssueFixVersion‘ to get the Fixed … Weiterlesen

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