Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

SOLV-8031 - Getting issue details... STATUS

In this documentation you will learn how data are stored on Jira database, especially for string and date column type using TGNG app.

You will also learn how data are stored on Jira database or on an external database using Data Mirror.

Contents

In these use cases and examples we are using MySQL 8.X Database for Jira Software 9.12.X but the SQL commands should run on almost all supported database systems.

You can find all supported database systems in this Atlassian documentation: https://confluence.atlassian.com/adminjiraserver0912/supported-platforms-1346046805.html

1st Use case: 1 row storage format in Jira Database

What is the value of Test-1 issue who has a Dates custom field where the "Date Name" = Feature Done, "Date Value" = 15.07.2023 ?

todo

  • first create a test project with key = TEST

  • second create a grid, 2 column only

    • Date name = string column type

    • Date value = date column type

  • create an issue and grid data : 1 row =
    "Date Name" = Feature Done, "Date Value" = 15.07.2023

  • connect MySQL database system, using Jira database, and run this SQL command:

    SELECT id,
           customfield,
           textvalue
    FROM customfieldvalue
    WHERE issue=
        (SELECT id
         FROM jiraissue
         WHERE issuenum=1
           AND project=
             (SELECT id
              FROM project
              WHERE pkey='TEST'));

2nd Use case: 2 rows storage format in Jira Database

What is the value of Test-2 issue who has a Dates custom filed where the "Dates Name" = Feature Start Date and "Date Value" = 03.10.2023 and has another row with "Date Name" = Feature End Date and "Date Value" = 31.10.2023 ?

3rd Use case: 1 row and 2 rows storage format using Data Mirror feature

  • No labels