Filter Instance records by Date created

CSP Request Details

None

CSP Rejection Details

None

CSP Approved

None

Description

Purpose: The Instance record Date created value - date and time stamp - is set in the instance record by the metadata component (metadata.createddate element). The filter for Date created is to provide filter on a date range. The implementation will be reusing the Date range component developed, and implemented in the Orders app, the segment for Order lines - Date created.

Scenarios:

  1. Scenario

    • Login to FOLIO Snapshot, go to Inventory

    • When the Instance segment is selected

    • Then filter for Date created is listed in the order according to (after: Suppress from discovery, and before Date updated). The Date created filter is displayed collapsed by default

  2. Scenario

    • When click on the little caret

    • Then the filter will be unfolded and two boxes, where to enter the date range are being display as in the UX mock up:

  3. Scenario

    • When following the general UX pattern

    • then the date format is shown as ghost text; e.g. YYYY-MM-DD

  4. Scenario

    • When entering the start date of the date range

    • Then the start date is entered in the "From" box

  5. Scenario

    • When entering the end date of the date range

    • Then the end date is entered in the "To" box

  6. Scenario

    • When both dates have been entered

    • Then click on the Apply button. The button has turned blue and the search is performed on the date range for the Date created which is a value set in the system by the Metadata component. The search is performed from e.g. 2019-01-01 to 2019-01-31 both days included

  7. Scenario

    • When clearing out the dates of the form

    • Then click on the round icon with a white "x"

  8. Scenario

    • Ensure automated testing coverage for this new code is 80% plus and confirm with screenshot

Environment

None

Potential Workaround

None

Attachments

7

Checklist

hide

TestRail: Results

Activity

Show:

Charlotte Whitt April 6, 2020 at 10:59 AM

Hi - yes, I was also wondering about it. I'll close this ticket

Sergiy Sergiyenko April 6, 2020 at 10:35 AM

, thank you for review.

I think the cause is due to 'timestamp' setting.
Since 'created date' returned in metadata is always in GMT+0 format, therefore 4/5/2020 11:38 PM by EDT looks like 4/6/2020 03:38 AM by GMT.
FYI, the same case with date in Orders App.

Charlotte Whitt April 6, 2020 at 8:46 AM
Edited

Manual test in FOLIO Snapshot, version folio/inventory 2.0.1000848, using Chrome.

This is a bit difficult to verify in FOLIO Snapshot, while sample data is being re-loaded every day when we populate a new update of the environment. But I loaded a new .mrc file (Clinical medicine) with today's date (4/6/2020) and all sample data having yesterday's date (4/5/2020) set as record created date.

Then I would have expected to get only one record (Clinical medicine), but in fact I get all 39 sample records. I'm not able to verify if this is the new date filter failing, or there is some time stamp setting messing up with this.

https://folio-snapshot.aws.indexdata.com/inventory/view/6a8b22ff-2e94-4daf-9eb8-35202043814a?filters=createdDate.2020-04-06%3A2020-04-07&sort=Title

I'll put the ticket back In progress.

Magda Zacharska February 27, 2020 at 5:26 PM

That is correct

Charlotte Whitt February 27, 2020 at 10:14 AM

Hi - I have labelled this story as `round_ii` while to the best of my knowledge, then this is needed for the Metadata Export app. Will you confirm?

Done

Details

Assignee

Reporter

Tester Assignee

Priority

Story Points

Sprint

Development Team

Prokopovych

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created October 10, 2019 at 6:45 AM
Updated September 15, 2020 at 9:04 AM
Resolved April 6, 2020 at 10:59 AM
TestRail: Cases
TestRail: Runs