[Koha-bugs] [Bug 19315] Routing preview may use wrong biblionumber

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19315

--- Comment #8 from Nick Clemens <nick at bywatersolutions.com> ---
(In reply to Marcel de Rooy from comment #7)
> Nick: Isnt there anything to be done on the GetSubscription output? Whats
> the use of the 'wrong' biblionumber ?

Technically yes, the 'wrong' biblionumber can't reliably be used for anything,
it's more convenience as you can't get 'all columns but one'

Right now we have:
SELECT  subscription.*,
        subscriptionhistory.*,

And to fix we would have to list every field individually:
SELECT  subscription.subscriptionid,subscription.biblionumber AS
sbiblionumber,librarian, startdate...
        subscriptionhistory.biblionumber AS shbiblionumber,histstartdatem
histenddate,missinglist...

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