Forms
The Forms additional export populates 2 tables in Snowflake:
Table Details
S4J_FORMS
This table contains information related to forms attached to work items in Jira. All form information associated with the current export’s work items is stored in this table. One instance of this table is created per configured export location. All exports with the Forms additional export option selected will merge their work item’s form information into this table. For this reason, multiple exports per location may include this option without causing export processes to perform duplicate work. If all forms from Jira are required, then one or more exports containing all Jira work items must include this option.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
ISSUEID | INT | ID of Jira work item where form is attached |
FORMID | VARCHAR | Form unique identifier |
NAME | VARCHAR | Form name |
UPDATED | DATETIME | Form update timestamp from Jira |
INTERNAL | BOOLEAN | Flag indicating whether form is internal |
SUBMITTED | BOOLEAN | Flag indicating whether form is submitted |
LOCK | BOOLEAN | Flag indicating whether form is locked |
S4J_FORMS_ANSWERS
This table contains information related to the answers provided for an individual form’s questions.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
FORMID | VARCHAR | Form unique identifier |
QUESTIONID | INT | ID of question from form |
LABEL | VARCHAR | Label of question from form |
ANSWERSTRING | VARCHAR | Question answer(s) (string) |
ANSWERLIST | ARRAY | Question answer(s) (array) |
ANSWERIDLIST | ARRAY | Question answer(s) ID(s) (array) |
CHOICE | ARRAY | Question choice(s)/option(s) (array) |
FIELDKEY | VARCHAR | Question field key |
UPDATED | DATETIME | Update timestamp from Jira |