http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10689
Katrin Fischer <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #21598|0 |1 is obsolete| | Attachment #21599|0 |1 is obsolete| | --- Comment #9 from Katrin Fischer <[email protected]> --- Created attachment 21602 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=21602&action=edit [PASSED QA] 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 <[email protected]> Signed-off-by: Bernardo Gonzalez Kriegel <[email protected]> Adding a sign Signed-off-by: Katrin Fischer <[email protected]> All tests and QA script pass. Works as described, fixes a bug as the templates show that the intention was to display both notes in the column. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] 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/
