[Koha-bugs] [Bug 5136] New: Replace embedded SQL query with call to GetAuthorisedValues

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Aug 13 15:56:52 CEST 2010


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 at myacpl.org
        ReportedBy: oleonard at myacpl.org
         QAContact: koha-bugs at lists.koha-community.org
                CC: gmcharlt at 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.


More information about the Koha-bugs mailing list