http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10689
Bernardo Gonzalez Kriegel <bgkrie...@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #21100|0 |1 is obsolete| | --- Comment #7 from Bernardo Gonzalez Kriegel <bgkrie...@gmail.com> --- Created attachment 21598 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=21598&action=edit [SIGNED-OFF] Bug 10689 - public note does not appear in subscriptions search In a serials module, when searching subscriptions, the results table as a "Notes" column. In TT code, you see that it tries to display public note "subscription.notes" and internal note "subscription.internalnotes". Internal note is well displayed but not public note. You can see the 2 notes in serial details in summary tab. The problem commes from the SQL query. A join is perform on subscription and biblio, both containing a "notes" column. This patch solves the problem by using a alias in query for both columns (biblio.notes is acutally not used in template but could be). Test plan : - Edit a subscription - Add public and internal notes. For example : "too busy" and "on holiday" - Perform a subscription search that returns this subscription => "Notes" column contains both notes. For example : "too busy (on holiday)" - Test with only public note - Test with only internal note ==== Works as described. Signed-off-by:Mathieu Saby <mathieu.s...@uhb.fr> Signed-off-by: Bernardo Gonzalez Kriegel <bgkrie...@gmail.com> Adding a sign -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/