Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Boards

Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
Status
colourBlue
titleBOARDS
Status
titleBOARDS TYPES

Filtering

...

Schema

  1. Loading boards filtered by

    Status
    titleBOARDS TYPES
    filter values (by Boards.TYPE). 
    Filtering skipped if
    Status
    titleBOARDS TYPES
    filter is not active.

  2. Filtering boards by

    Status
    colourBlue
    titleBOARDS
    filter values (by Boards.BOARD_ID) and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    filter values (by Boards.LOCATION_ID).
    Filtering skipped if
    Status
    colourBlue
    titleBOARDS
    filter and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    filter are not active.

  3. Export resulted boards list.

Expected

...

Result

All unique boards chosen by

Status
colourBlue
titleBOARDS
and
Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
filters are combined into one list and filtered by
Status
titleBOARDS TYPES
.

 

Sprints

Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
Status
colourBlue
titleBOARDS
Status
colourBlue
titleSPRINTS
Status
titleSPRINTS STATES

Filtering

...

Schema

  1. Loading boards with scrum and simple types (Boards.TYPE).

  2. Filtering boards by

    Status
    colourBlue
    titleBOARDS
    filter values (by Boards.BOARD_ID) and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    filter values (by Boards.LOCATION_ID).
    Filtering skipped if
    Status
    colourBlue
    titleBOARDS
    filter and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    filter are not active.

  3. Loading sprints by boards ids list from step 2 filtered by

    Status
    titleSPRINTS STATES
    filter values (by Sprints.STATE).
    Filtering skipped if
    Status
    titleSPRINTS STATES
    filter is not active.

  4. Loading sprints by

    Status
    colourBlue
    titleSPRINTS
    filter values.

  5. Filtering sprints loaded on step 4 by

    Status
    titleSPRINTS STATES
    filter values (by Sprints.STATE).
    Filtering skipped if
    Status
    titleSPRINTS STATES
    filter is not active.

  6. Export resulted unique sprints list subject to the condition of uniqueness of the natural key (Sprints.SPRINT_ID + Sprints.BOARD_ID).

Expected

...

Results

All unique boards chosen by

Status
colourBlue
titleBOARDS
and
Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
filters are combined into one list filtered by scrum and simple boards types.

All unique sprints loaded by unique boards list and

Status
colourBlue
titleSPRINTS
filter values filtered by
Status
titleSPRINTS STATES
filter. 

Board Sprints

Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
Status
colourBlue
titleBOARDS
Status
colourBlue
titleSPRINTS
Status
titleSPRINTS STATES

Filtering

...

Schema

  1. Loading boards with scrum and simple types (by Boards.TYPE).

  2. Filtering boards by

    Status
    colourBlue
    titleBOARDS
    filter values (by Boards.BOARD_ID) and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    filter values (by Boards.LOCATION_ID).
    Filtering skipped if
    Status
    colourBlue
    titleBOARDS
    filter and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    filter are not active.

  3. Loading sprints by boards ids list from steps 2 filtered by

    Status
    colourBlue
    titleSPRINTS
    filter values (Sprints.SPRINT_ID) and
    Status
    titleSPRINTS STATES
    filter values (Sprints.STATE).
    Filtering skipped if
    Status
    colourBlue
    titleSPRINTS
    filter and
    Status
    titleSPRINTS STATES
    filter are not active.

Expected

...

Results

All unique boards chosen by

Status
colourBlue
titleBOARDS
and
Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
filters are combined into one list filtered by scrum and simple boards types.

All sprints loaded by a unique boards list filtered by

Status
colourBlue
titleSPRINTS
and
Status
titleSPRINTS STATES
filters.

 

Board Issues

Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
Status
colourBlue
titleBOARDS
Status
titleBOARDS TYPES
Status
titleFILTER BY JQL

Filtering

...

Schema

  1. Loading boards filtered by

    Status
    titleBOARDS TYPES
    filter values.
    Filtering skipped if
    Status
    titleBOARDS TYPES
    filter is not active.

  2. Filtering boards by

    Status
    colourBlue
    titleBOARDS
    filter values (by Boards.BOARD_ID) and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    filter values (by Boards.LOCATION_ID).
    Filtering skipped if
    Status
    colourBlue
    titleBOARDS
    filter and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    are not active.

  3. Loading issues by the resulting boards list filtered by

    Status
    titleFILTER BY JQL
    value.
    Filtering skipped if
    Status
    titleFILTER BY JQL
    is not active.

Expected

...

Result

All unique boards chosen by

Status
colourBlue
titleBOARDS
and
Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
filters are combined into one list and filtered by
Status
titleBOARDS TYPES
.

All Issues filtered by boards and

Status
titleFILTER BY JQL
value loaded and exported.

 

Issue Sprints

Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
Status
colourBlue
titleBOARDS
Status
colourBlue
titleSPRINTS
Status
titleSPRINTS STATES
Status
titleFILTER BY JQL

Filtering

...

Schema

  1. Loading boards with scrum and simple types (Boards.TYPE).

  2. Filtering boards by

    Status
    colourBlue
    titleBOARDS
    filter values (by Boards.BOARD_ID) and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    filter values (by Boards.LOCATION_ID).
    Filtering skipped if
    Status
    colourBlue
    titleBOARDS
    filter and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    filter are not active.

  3. Loading sprints by boards ids list from steps 2 filtered by

    Status
    titleSPRINTS STATES
    filter values (by Sprints.STATE).
    Filtering skipped if
    Status
    titleSPRINTS STATES
    filter is not active.

  4. Loading sprints by

    Status
    colourBlue
    titleSPRINTS
    filter values.

  5. Filtering sprints loaded on step 4 by

    Status
    titleSPRINTS STATES
    filter values (by Sprints.STATE).
    Filtering skipped if
    Status
    titleSPRINTS STATES
    filter is not active.

  6. Loading issues by the resulting sprints list filtered by

    Status
    titleFILTER BY JQL
    value.
    Filtering skipped if
    Status
    titleFILTER BY JQL
    is not active.

Expected

...

Result

All unique boards chosen by

Status
colourBlue
titleBOARDS
and
Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
filters are combined into one list and filtered by scrum and simple boards types.

...

All sprints issues filtered by

Status
titleFILTER BY JQL
value loaded and exported.

 

Sprint Reports

Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
Status
colourBlue
titleBOARDS
Status
colourBlue
titleSPRINTS
Status
titleSPRINTS STATES

Filtering

...

Schema

  1. Loading boards with scrum and simple types (Boards.TYPE).

  2. Filtering boards by

    Status
    colourBlue
    titleBOARDS
    filter values (by Boards.BOARD_ID) and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    filter values (by Boards.LOCATION_ID).
    Filtering skipped if
    Status
    colourBlue
    titleBOARDS
    filter and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    filter are not active.

  3. Loading sprints by boards ids list from steps 2 filtered by

    Status
    colourBlue
    titleSPRINTS
    filter values (by Sprints.SPRINT_ID) and
    Status
    titleSPRINTS STATES
    filter values (by Sprints.STATE).
    Filtering skipped if
    Status
    colourBlue
    titleSPRINTS
    filter and
    Status
    titleSPRINTS STATES
    filter are not active.

  4. Loading sprints reports data by unique natural key (Sprints.SPRINT_ID + Sprints.BOARD_ID).

Expected

...

Results

All unique boards chosen by

Status
colourBlue
titleBOARDS
and
Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
filters are combined into one list filtered by scrum and simple boards types.

...

All unique sprints reports items loaded and exported by unique Boards.BOARD_ID and Sprints.SPRINT_ID combination. 

Sprint Report Issues

Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
Status
colourBlue
titleBOARDS
Status
colourBlue
titleSPRINTS
Status
titleSPRINTS STATES
Status
titleISSUES TYPES
Status
titleISSUES STATUSES

Filtering

...

Schema

  1. Loading boards with scrum and simple types (Boards.TYPE).

  2. Filtering boards by

    Status
    colourBlue
    titleBOARDS
    filter values (by Boards.BOARD_ID) and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    filter values (by Boards.LOCATION_ID).
    Filtering skipped if
    Status
    colourBlue
    titleBOARDS
    filter and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    filter are not active.

  3. Loading sprints by boards ids list from steps 2 filtered by

    Status
    colourBlue
    titleSPRINTS
    filter values (by Sprints.SPRINT_ID) and
    Status
    titleSPRINTS STATES
    filter values (by Sprints.STATE).
    Filtering skipped if
    Status
    colourBlue
    titleSPRINTS
    filter and
    Status
    titleSPRINTS STATES
    filter are not active.

  4. Loading sprints reports issues data by unique natural key (Sprints.SPRINT_ID + Sprints.BOARD_ID).

  5. Filtering sprints reports issues data by

    Status
    titleISSUES TYPES
    and
    Status
    titleISSUES STATUSES
    filters values.
    Filtering skipped if
    Status
    titleISSUES TYPES
    and
    Status
    titleISSUES STATUSES
    filters are not active.

Expected results

All unique boards chosen by

Status
colourBlue
titleBOARDS
and
Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
filters are combined into one list filtered by scrum and simple boards types.

...

All unique sprints reports issues loaded and exported by unique Boards.BOARD_ID and Sprints.SPRINT_ID combination filtered by

Status
titleISSUES TYPES
and
Status
titleISSUES STATUSES
filters values. 

Velocity Charts

Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
Status
colourBlue
titleBOARDS
Status
colourBlue
titleSPRINTS

Filtering

...

Schema

  1. Loading boards with scrum and simple types (Boards.TYPE).

  2. Filtering boards by

    Status
    colourBlue
    titleBOARDS
    filter values (by Boards.BOARD_ID) and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    filter values (by Boards.LOCATION_ID).
    Filtering skipped if
    Status
    colourBlue
    titleBOARDS
    filter and
    Status
    colourBlue
    titlePROJECTS (JIRA SOFTWARE)
    filter are not active.

  3. Loading sprints by boards ids list from steps 2 filtered by

    Status
    colourBlue
    titleSPRINTS
    filter values (by Sprints.SPRINT_ID).
    Filtering skipped if
    Status
    colourBlue
    titleSPRINTS
    filter is not active.

  4. Loading velocity charts data by unique natural key (Sprints.SPRINT_ID + Sprints.BOARD_ID).

Expected

...

Results

All unique boards chosen by

Status
colourBlue
titleBOARDS
and
Status
colourBlue
titlePROJECTS (JIRA SOFTWARE)
filters are combined into one list filtered by scrum and simple boards types.

...