The Provider field limits its search to 50 before any filter by permissions are taken into account

Bug #1554217 reported by Dale Rigney
32
This bug affects 6 people
Affects Status Importance Assigned to Milestone
Evergreen
Confirmed
Medium
Unassigned

Bug Description

Tested on evergreen 2.7

When you try to create an Invoice or Purchase order the provider field responds to the first character entered and displays a list of providers that start with that character. This list of providers is sorted alphanumerically, then limited to 50 before any other criteria such as work station and permission level are taken into account. This can result in a blank list when a consortium has over 51 providers that start with the same character and the 51st provider is the only provider that should display for the staff member/workstation. The list should apply the permission criteria and then apply the limit.

Here is snippet from the logs:
open-ils.pcrud.search.acqpro "8af1fd704726f45012505b011f5b52bb", {"active":"t","code":{"ilike":"r%"}}, {"order_by":{"acqpro":"code ASC"},"limit":50}

tags: added: acq
Revision history for this message
Tiffany Little (tslittle) wrote :

Noting that this is still an issue in 3.4.1. See now-duped bug 1895551.

Changed in evergreen:
status: New → Confirmed
importance: Undecided → Medium
tags: added: acq-admin angular
Revision history for this message
Britta Dorsey (bdorsey-isl) wrote :

Seeing this issue (or something very similar) in 3.11.2, but it's not consistent.

We have a library that has 20 providers that all start with their shortname (MRNRV). When they use Create Invoice, the Provider list only shows the same seven providers. When we attempt to enter a provider that does not appear, we receive an invalid entry.

Another library has 16 providers that start with JFFCO and they are all visible under Providers when using Create Invoice.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.