| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
| Info |
|---|
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
| Table of Contents | ||
|---|---|---|
|
| Info |
|---|
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.2023connect MySQL database system, using Jira database, and run this SQL command:
Code Block language sql 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 ?