Comment 11 for bug 1949109

We did some more testing with both our production data and a concerto test system with additional shelving location groups added. The order of the shelving location groups does not seem to be following position, then name as intended. Instead, the sort appears to be by the database id in asset.copy_location_group.

An example from the concerto test system:

With the following entries in asset.copy_location_group:

 id | name | owner | pos | top | opac_visible
----+---------------------------+-------+-----+-----+--------------
  1 | Juvenile Collection | 2 | 0 | f | t
  2 | Local Interest Collection | 3 | 0 | f | t
  3 | Adult Collections | 1 | 3 | f | t
  4 | Children's Collections | 1 | 1 | f | t
  5 | Teen Collections | 1 | 2 | f | t
  6 | BR1 Teen | 4 | 2 | f | t
  7 | BR1 Children's | 4 | 1 | f | t
  8 | BR1 Adult | 4 | 3 | f | t

The position then name sort would be:

 id | name | owner | pos | top | opac_visible
----+---------------------------+-------+-----+-----+--------------
  1 | Juvenile Collection | 2 | 0 | f | t
  2 | Local Interest Collection | 3 | 0 | f | t
  7 | BR1 Children's | 4 | 1 | f | t
  4 | Children's Collections | 1 | 1 | f | t
  6 | BR1 Teen | 4 | 2 | f | t
  5 | Teen Collections | 1 | 2 | f | t
  3 | Adult Collections | 1 | 3 | f | t
  8 | BR1 Adult | 4 | 3 | f | t

The dropdown in the angular catalog appears as follows:

Searching CONS

Library Groups
 Non-Branches
Shelving Location Groups
 Juvenile Collection
 Local Interest Collection
 Adult Collection
 Children's Collection
 Teen Collection
 BR1 Teen
 BR1 Children's
 BR1 Adult

Searching BR1

Library Groups
 Non-Branches
Shelving Location Groups
 Juvenile Collection
 Adult Collection
 Children's Collection
 Teen Collection
 BR1 Teen
 BR1 Children's
 BR1 Adult

Searching BR2

Library Groups
 Even Branches
 Non-Branches
Shelving Location Groups
 Juvenile Collection
 Adult Collection
 Children's Collection
 Teen Collection