Duplicate instance rows returned for cross-table filters

Description

Overview: When you filter search results on location, an instance with multiple related holdings appears multiple times in the result set.

Steps to reproduce:

  1. Login to FOLIO snapshot, go to Inventory

  2. Select the instance record for "Bridget Jones's Baby"

  3. Create a holdings record with the location "Annex"

  4. Clear the search so that all instances are displayed

  5. Limit the search to "Location -> Annex"

Expected result:
"Bridget Jones's Baby" appears once in the instance list, in the 2nd pane.

Actual result:
"Bridget Jones's Baby" appears twice in the instance list:

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

2
  • 14 Dec 2018, 05:27 PM
  • 27 Nov 2018, 06:55 PM

Checklist

hide

TestRail: Results

Activity

Show:

Charlotte Whitt May 18, 2022 at 2:04 PM
Edited

- I have closed this ancient bug. I can not reproduce this any more slightly smiling face

Charlotte Whitt December 20, 2018 at 12:58 PM

- will you take a look on this - it was re-opened by Wayne.

Wayne Schneider December 14, 2018 at 5:27 PM

Sorry, reopening the issue, it is still a problem. How to replicate:

  1. On folio-testing, select the instance record for "Bridget Jones's Baby"

  2. Create a holdings record with the location "Annex"

  3. Clear the search so that all instances are displayed

  4. Limit the search to "Location -> Annex"

"Bridget Jones's Baby" now appears twice in the instance list:

Charlotte Whitt December 13, 2018 at 12:40 PM

Sounds good - I'll close the issue. Thanks

Wayne Schneider December 12, 2018 at 8:13 PM

Yes, this looks good to me now.

Cannot Reproduce

Details

Assignee

Reporter

Labels

Priority

Development Team

Core: Platform

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created February 14, 2018 at 4:57 PM
Updated May 18, 2022 at 2:06 PM
Resolved May 18, 2022 at 2:06 PM
TestRail: Cases
TestRail: Runs

Flag notifications