https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32748

--- Comment #71 from Thibaud Guillot (thibaud_g) <[email protected]> 
---
Created attachment 205781
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=205781&action=edit
Bug 32748: (QA follow-up) Fix duplicate AV when limited to several libraries at
once

When an authorised value is limited to more than one library, the
no_limit query in GetAuthorisedValues joins authorised_values_branches
and returns one row per associated library, so the value was listed
several times in the item edition dropdown.

Group by the authorised value so each one is only returned once, and
aggregate the restricted flag with MIN() so the value stays
unrestricted as soon as one of its libraries matches the current one.

Sponsored-by: BibLibre

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to