Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. MODINVSTOR-723

Add sortable publication year field to the instance record

    XMLWordPrintable

Details

    • Story
    • Status: Closed (View Workflow)
    • P3
    • Resolution: Done
    • None
    • 21.0.0
    • None
    • Falcon Sprint 114
    • 3
    • Falcon

    Description

      Background:
      The existing implementation of the dateOfPublication allow for storing data in the format that prevents sorting by publication year and make filtering inefficient. The examples of the data that is currently stored include:

      • ©2001
      • [1969?]
      • [between 1900 and 1999]
      • cop 1997
      • hafniae MCMLXXI,
      • 1391 [2012 or 2013]

      Purpose/Overview:
      The purpose of this story is to provide a field that will allow for sorting and filtering by the publication year

      Requirements/Scope:
      The publication year may have following formats:

      1. be empty
      2. consist out of four digits
      3. consist out of start date (empty,four digits)
      4. consist out of end date (empty,four digits)

      Examples of possible scenarios:
      Assuming that there are two fields associated with an instance that can store publication year related data, the information should be represented as follow:

      Instance Year(s) of Publication Field 1 Field 2
      Instance A 1999 1999  
      Instance B 1996-2001 1996 2001
      Instance C 1998 - unknown 1998  
      Instance D unknown -2000   2000
      Instance E unknown    

      Additional information:
      Sorting (to be implemented in a separate user story, here for informational purpose only):

      Field 1 Field 2 Sort by
      1999   Field 1
      1999 2005 Field 1
        2005 Field 2

      Approach:
      TBD by developers

      Acceptance criteria:
      1. The field is added
      2. The field can be populated with relevant data when:

      • publication year is known
      • publication start year is known
      • publication end year is known
      • publication year, start or end year are unknown

      3. migration scripts are provided Moved to MODINVSTOR-724

      Out of scope:
      UI implementation

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                bohdan-suprun Bohdan Suprun
                magdaz Magda Zacharska
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases