Support (one level) hierarchy on rating scheme items

[davidwatkins73]

Description

We would like to be able to support rating schemes that look like:

• group a
  • item 1a
  • item 2a
• group b
  • item 1b

Implementation notes:

• The groups are not selectable (although they may toggle a select/deselect all in MVA's)
• Items must have unique names per scheme regardless of groups

Tasks:

• enforce uniqueness of item names (per scheme)
• enforce uniqueness of assessment definition names
• add external_id to rating_scheme
• increase column size of rating_scheme_item - code
  • Need to be able to support more than one chars worth of options, (i.e. country codes). This may have unforeseen knock-ons, so proceed with caution :)
• add rating_group column to rating_scheme_item
• UI changes (using opt-groups, see comment below)
  • Mostly around edit
  • Perhaps on the detail view when clicking on an assessment
  • Measurable ratings editor / display
• Admin screens (item edit)

We do not intend to:

• Show in list view
• Show in report grid
• Include in exports (?)

Resourcing

We would like to add this request to the Waltz team's feature backlog

[davidwatkins73]

Example of opt-groups:

<select>
        <optgroup label="Programming Languages">
            <option value="C">C</option>
            <option value="C++">C++</option>
            <option value="Java">Java
        </optgroup>
        <optgroup label="Scripting Language">
            <option value="JavaScript">JavaScript</option>
            <option value="PHP">PHP</option>
            <option value="Shell">Shell</option>
        </optgroup>
</select>