Uploaded image for project: 'ERM Platform'
  1. ERM Platform
  2. ERM-1251

Support searching on License start and end date

    XMLWordPrintable

Details

    • ERM Sprint 104, ERM Sprint 105
    • Bienenvolk

    Description

      Purpose:
      Find licenses based on when their start and end dates are, and find licenses that are lacking start or end dates

      Description
      Add options to search by start and end date into the Licenses search and sort screen

      • Separate search options - one for start date, one for end date.
      • The user should be able to specify a date on or after which the start/end date falls AND a date on or before which the start/end date falls - these constraints should be applied together. e.g. "find licenses with an end date on or after 1st January 2020 AND on or before 31st December 2020). Both the constraints are optional
      • The user should be able to check a box to include licenses without a defined start/end date and this should be combined with the date constraints as an "OR". e.g. "find licenses with an end date that is either on or after 1st January 2020 OR is empty

      See mockup

      For the checkboxes use the phrases:

      • Include licenses with no start date set
      • Include licenses with no end date set

      User story statement(s):

      As an ERM librarian,
      I want to be able to search for licenses by start and end date
      so that I can find licenses that currently apply or applied during a specific period

      As an ERM librarian,
      I want to be able to search for licenses that have an end date within a specific time period (e.g. this year, next 90 days, next 60 days)
      so that I can find licenses that are going to expire and take action to extend or renegotiate them

      As an ERM librarian,
      I want to be able to search for licenses that do not have an end date defined
      so that I can find licenses with no defined end date

      As an ERM librarian,
      I want to be able to search for licenses that do not have a start date defined
      so that I can find licenses with no defined start date

      Scenarios:

      1. Scenario:
        • Given a license with an end date of 31st December 2020
        • When I search for all licenses with an end date on or before 31st December 2020
        • Then I find this license
      2. Scenario:
        • Given a license with an end date of 31st December 2020
        • When I search for all licenses with an end date on or before 31st December 2020 but on or after 1st January 2020
        • Then I find this license
      3. Scenario:
        • Given a license with an end date of 1st January 2021
        • When I search for all licenses with an end date on or before 31st December 2020 but on or after 1st January 2020
        • Then I do not find this license
      4. Scenario:
        • Given a license with no end date defined
        • When I search for all licenses without an end date
        • Then I find this license
      5. Scenario:
        • Given a license with no end date defined
        • When I search for all licenses with an end date after 1st January 2020 (not including those without an end date)
        • Then I do not find this license
      6. Scenario:
        • Given a license with an start date of 1st January 2020
        • When I search for all licenses with a start date on or after 1st January 2020
        • Then I find this license
      7. Scenario:
        • Given a license with an start date of 1st January 2020
        • When I search for all licenses with a start date on or after 1st January 2020 but before 31st December 2020
        • Then I find this license
      8. Scenario:
        • Given a license with an start date of 1st January 2021
        • When I search for all licenses with a start date on or after 1st January 2020 but on or before 31st December 2020
        • Then I do not find this license
      9. Scenario:
        • Given a license with no start date defined
        • When I search for all licenses without a start date
        • Then I find this license
      10. Scenario:
        • Given a license with no start date defined
        • When I search for all licenses with a start date on or after 1st January 2020 (not including those without an start date)
        • Then I do not find this license
      11. Scenario:
        • Given the Start date filter
        • If I enter a date in both the "On or after" and "On or before" fields, if the "On or after" date is later the "On or before" date
        • Then on clicking "Apply" I see the error "The `On or after` date must not be later than the `On or before` date"
      12. Scenario:
        • Given the End date filter
        • If I enter a date in both the "On or after" and "On or before" fields, if the "On or after" date is later the "On or before" date
        • Then on clicking "Apply" I see the error "The `On or after` date must not be later than the `On or before` date"

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                ostephens Owen Stephens
                ostephens Owen Stephens
                Gill Osguthorpe Gill Osguthorpe
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases