BE: In transit report: request fields

Description

Purpose: Create an export of all items with the status In transit, with enough information about each item so that a staff member can try to track it down. Include request information for items that have requests

Scenarios

  1. Scenario

    • Given the In transit items report (CSV) option in the Inventory pane header dropdown

    • When clicked

    • Then export a CSV file called InTransit.csv with the following headers:

      • Item barcode

      • Title

      • Contributors

      • Library

      • Shelving location

      • Shelving location code

      • some call number and enumeration/copy fields

        • to include Call number, call number prefix, call number suffix, enumeration, volume, year, copy number, sortable call number as defined for the item

      • Item status

      • Check in service point

      • Check in date and time

      • Destination service point

      • Request type

      • Requester patron group

      • Request creation date

      • Request expiration date

      • Request pickup service point

      • Tags

  2. Scenario

    • Given an item with the item status In transit and with at least one open request:

    • When the In transit report (CSV) is exported

    • Then include the item on the In transit report (CSV) with the following values:

      • Item barcode: barcode on the item record

      • Title: title for the instance the item belongs to

      • Contributors: contributors for the instance the item belongs to

      • Library: name of library for the item's effective location

      • Shelving location: name of item's effective location

      • Shelving location code: code for item's effective location

      • some call number and enumeration/copy fields

        • to include Call number, call number prefix, call number suffix, enumeration, volume, year, copy number, sortable call number as defined for the item

      • Item status: item status for item (should be In transit for all items in report)

      • Check in service point: the service point where the item was most recently scanned in the Check In app

      • Check in date and time: the system date and time of when the item was most recently scanned in the Check In app

      • Destination service point: Name of service point item was routed to at time of last scan in Check In app

      • Request type: the request type for top open request on the item

      • Requester patron group: patron group for patron with the request

      • Request creation date: creation date and time for the top open request on the item

      • Request expiration date: expiration date and time for the top open request on the item

      • Request pickup service point: name of service point for top open request on the item

      • Tags: tags for the request with the top open request on the item (format: tag1, tag2, tag3)

  3. Scenario

    • Given an item with the item status In transit and with 0 open requests:

    • When the In transit report (CSV) is exported

    • Then include the item on the In transit report (CSV) with the following values:

      • Item barcode: barcode on the item record

      • Title: title for the instance the item belongs to

      • Contributors: contributors for the instance the item belongs to

      • Library: name of library for the item's effective location

      • Shelving location: name of item's effective location

      • Shelving location code: code for item's effective location

      • some call number and enumeration/copy fields

        • to include Call number, call number prefix, call number suffix, enumeration, volume, year, copy number, sortable call number as defined for the item

      • Item status: item status for item (should be In transit for all items in report)

      • Check in service point: the service point where the item was most recently scanned in the Check In app

      • Check in date and time: the system date and time of when the item was most recently scanned in the Check In app

      • Destination service point: Name of service point item was routed to at time of last scan in Check In app

      • Request type: -

      • Requester patron group: -

      • Request creation date: -

      • Request expiration date: -

      • Request pickup service point: -

      • Tags: -

Notes:

  • If an item is on its way to its home location and a patron places a request on it in the meantime, then the destination service point (determined when the item is checked in) and the pickup service point may differ.

Environment

None

Potential Workaround

None

Checklist

hide

TestRail: Results

Activity

Show:

Svitlana ZmiivskaNovember 4, 2019 at 1:16 PM

Yes, it is

Marc JohnsonNovember 4, 2019 at 12:52 PM
Edited

These requirements suggest that the starting point for this report is items (rather than loans or requests).

How is this being implemented, is it going to be a custom report endpoint?

Done

Details

Assignee

Reporter

Labels

Priority

Story Points

Sprint

Development Team

Vega

Fix versions

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created September 23, 2019 at 8:05 PM
Updated December 5, 2019 at 3:25 PM
Resolved November 19, 2019 at 7:18 PM
TestRail: Cases
TestRail: Runs