http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5136 Summary: Replace embedded SQL query with call to GetAuthorisedValues Change sponsored?: --- Product: Koha Version: HEAD Platform: All OS/Version: All Status: ASSIGNED Severity: minor Priority: P5 Component: Circulation AssignedTo: oleonard@myacpl.org ReportedBy: oleonard@myacpl.org QAContact: koha-bugs@lists.koha-community.org CC: gmcharlt@gmail.com Estimated Hours: 0.0 circulation.pl gets the contents of the BOR_NOTES authorized value loop by querying directly: # get authorised values with type of BOR_NOTES my @canned_notes; my $sth = $dbh->prepare('SELECT * FROM authorised_values WHERE category = "BOR_NOTES"'); ... There is an existing function, GetAuthorisedValues, which does the same. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.