Searching specific location in Advanced Search not limiting correctly in 3.0
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Medium
|
Unassigned |
Bug Description
Eg 3.0
OSRF 3.0
Pg 9.4
Ubuntu 14.04
When logged in as a staff member on either the web or staff clients searching at a specific location limits results inconsistently. It's not limited only to the selected location but it is significantly fewer items than searching everywhere. For instance, searching evergreen.
Pulling the database query out for the same search logged in and not, there are 2 primary differences:
The staff search includes these 2 column definitions:
,c_attr AS (SELECT (ARRAY_
,b_attr AS (SELECT (ARRAY_
where the public search defines them like so:
,c_attr AS (SELECT (ARRAY_
,b_attr AS (SELECT (ARRAY_
(Note the 'c_attrs,' and 'b_attrs,' segments in the inner ARRAY, they're fields being pulled from the results of asset.patron_
Further down, in the WHERE clause is this difference:
staff search:
((EXISTS (SELECT 1 FROM asset.copy_
and public search:
(EXISTS (SELECT 1 FROM asset.copy_
The first difference strikes me as the potential issue. The patron version selects the *_attrs column of the results from asset.patron_
Those are my *assumptions*, so I wanted to post this for possible discussion.
tags: | added: signedoff |
Changed in evergreen: | |
milestone: | none → 3.0.2 |
Changed in evergreen: | |
assignee: | nobody → Galen Charlton (gmc) |
importance: | Undecided → Medium |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
I can confirm the behavior on our 3.0.0 test server running with PINES customizations/ data.