Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

MSEARCH work. Inventory search with created or updated dates results records outside the specified date range

Description

Comment from - 5/2/2022:
I believe the issue is that the UI filter is not attaching a timestamp to the query, i.e. this is an STSMACOM issue not an MSEARCH one. Note that + values in the timestamp (which must accommodate the tenant's timezone) will need to be correctly encoded as %2B. A raw + will be decoded to a space, which will cause a parsing error and result in a 500 from mod-search.

Overview: Inventory search with created or updated dates results records outside the specified date range

• Action: filtering in Inventory using Date updated/created.
• Expected behavior: results list only includes records within the specified date range, i.e. the date parameters of the API query include a full ISO-8601 timestamp that accommodates the tenant's timezone.
• Current behavior: results showing from outside of specified date range. The root cause is values in the API query are missing timestamps and bare dates are converted to UTC timestamps. This means a tenant in London and a tenant in Los Angeles both send the same query,

which is converted to

when the Los Angeles tenant should send

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

4

Checklist

hide

TestRail: Results

Activity

Show:

Oleksii Petrenko July 25, 2022 at 4:57 PM

Deployed to MG bf. Please proceed with verification

Valery_Pilko July 21, 2022 at 12:05 PM

Verified at Snapshot environment, now BE side handles with the queries in format: "metadata.createdDate >= 2022-07-21T04:15:00%2D07:00"
1) I created the MARC Bib record "The Journal of ecclesiastical history." via data import at 7/21/2022 11:15 AM.

2) Send the request with the following query: "metadata.createdDate >= 2022-07-21T04:15:00%2D07:00" and get two records, including which one I created at step 1.

3) Send the request with the following query: "metadata.createdDate >= 2022-07-21T04:16:00%2D07:00" and get only one record, which was created later.

Done

Details

Assignee

Reporter

Labels

Priority

Story Points

Sprint

Development Team

Spitfire

Fix versions

Release

Morning Glory (R2 2022) Bug Fix

RCA Group

Incomplete/missing requirements

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created July 15, 2022 at 5:20 PM
Updated August 22, 2022 at 9:45 AM
Resolved July 21, 2022 at 1:03 PM
TestRail: Cases
TestRail: Runs