[Koha-bugs] [Bug 10689] public note does not appear in subscriptions search

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10689

Bernardo Gonzalez Kriegel <bgkriegel at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #21100|0                           |1
        is obsolete|                            |

--- Comment #7 from Bernardo Gonzalez Kriegel <bgkriegel at 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.saby at uhb.fr>
Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel at gmail.com>
Adding a sign

-- 
You are receiving this mail because:
You are watching all bug changes.