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 5 Current »

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 ?

  1. first create a test project with key = TEST

  2. second create a grid, 2 column only

    • Date name = string column type

    • Date value = date column type

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

  4. connect to 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