Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-79098

customfieldoption - Inserting values by batch via sql insert

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Unresolved
    • None
    • Custom fields
    • None
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Hi,

      is it possible to insert into the table "customfieldoption" via SQL-Insert-Statements like shown below?

      Most of the fields seem to be transparent, but how is the ID for a new entry generated?Is it just the actual highest ID plus one or what does it depend on?

      I got the basic informations in the first 4 lines and then generated two new lines for OptionValue10 and OptionValue11:

      Last ID     22602
      Customfield     22100
      Customfield_config     24400
      Last Sequence of Option     13
             
      CustomValues ID Sequence SQL-Statement
      OptionValue10 22603 14 INSERT INTO jira.customfieldoption (id,CUSTOMFIELD, CUSTOMFIELDCONFIG, PARENTOPTIONID, `SEQUENCE`, customvalue, optiontype, disabled) VALUES(22603,22100, 24400, NULL, 14, 'OptionValue10', NULL, 'N');
      OptionValue11 22604 15 INSERT INTO jira.customfieldoption (id,CUSTOMFIELD, CUSTOMFIELDCONFIG, PARENTOPTIONID, `SEQUENCE`, customvalue, optiontype, disabled) VALUES(22604,22100, 24400, NULL, 15, 'OptionValue11', NULL, 'N');

              Unassigned Unassigned
              a508b342af66 Wilfried Seitz
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: