[Koha-bugs] [Bug 14246] New: Add borrowernumber to koha_news
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu May 21 17:44:13 CEST 2015
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14246
Bug ID: 14246
Summary: Add borrowernumber to koha_news
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Database
Assignee: gmcharlt at gmail.com
Reporter: xarragon at gmail.com
QA Contact: testopia at bugs.koha-community.org
News items in Koha's OPAC and Staff client are anonymous. This is the first in
a set of patches to add authorship tracking to the news items, with optional
display preferences maintaining the current functionality.
This first patch changes the database; it adds a column called 'borrowernumber'
to the 'koha_news' table, adding a foreign key relationship to the 'borrowers'
table. This is how tracking authorship is done. A LEFT JOIN statement is then
used to get the title, firstname and surname columns available in the news data
set. That is a separate patch.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list