View | Details | Raw Unified | Return to bug 10689
Collapse All | Expand All

(-)a/C4/Serials.pm (-1 / +8 lines)
Lines 654-660 sub SearchSubscriptions { Link Here
654
    my ( $args ) = @_;
654
    my ( $args ) = @_;
655
655
656
    my $query = qq{
656
    my $query = qq{
657
        SELECT subscription.*, subscriptionhistory.*, biblio.*, biblioitems.issn
657
        SELECT
658
            subscription.notes AS publicnotes,
659
            subscription.*,
660
            subscriptionhistory.*,
661
            biblio.notes AS biblionotes,
662
            biblio.title,
663
            biblio.author,
664
            biblioitems.issn
658
        FROM subscription
665
        FROM subscription
659
            LEFT JOIN subscriptionhistory USING(subscriptionid)
666
            LEFT JOIN subscriptionhistory USING(subscriptionid)
660
            LEFT JOIN biblio ON biblio.biblionumber = subscription.biblionumber
667
            LEFT JOIN biblio ON biblio.biblionumber = subscription.biblionumber
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/serials-search.tt (-2 / +1 lines)
Lines 148-154 Link Here
148
                        </td>
148
                        </td>
149
                        <td><a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% subscription.subscriptionid %]" class="button" title="subscription detail">[% subscription.title |html %]</a>
149
                        <td><a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% subscription.subscriptionid %]" class="button" title="subscription detail">[% subscription.title |html %]</a>
150
                        </td>
150
                        </td>
151
                        <td>[% IF ( subscription.notes ) %][% subscription.notes %][% END %]
151
                        <td>[% IF ( subscription.publicnotes ) %][% subscription.publicnotes %][% END %]
152
                        [% IF ( subscription.internalnotes ) %]([% subscription.internalnotes %])[% END %]
152
                        [% IF ( subscription.internalnotes ) %]([% subscription.internalnotes %])[% END %]
153
                        </td>
153
                        </td>
154
                        <td>
154
                        <td>
155
- 

Return to bug 10689