[Koha-bugs] [Bug 5338] Serials in guided reports

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

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

mathieu saby <mathieu.saby at univ-rennes2.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Failed QA

--- Comment #9 from mathieu saby <mathieu.saby at univ-rennes2.fr> ---
Test made
In Guided Reports, I selected the new 'Serial' value in modules list
then I selected all the fields of the following tables: serial, serialitems,
subscription, subscriptionhistory, subscriptionroutinglist
I did not choose sorting, grouping or counting option

The resulting report is:
SELECT 
serial.serialid,serial.biblionumber,serial.subscriptionid,serial.serialseq,serial.status,serial.planneddate,serial.notes,serial.publisheddate,serial.claimdate,serial.routingnotes,
serialitems.itemnumber,serialitems.serialid,
subscription.biblionumber,subscription.subscriptionid,subscription.librarian,subscription.startdate,subscription.aqbooksellerid,subscription.cost,subscription.aqbudgetid,subscription.weeklength,subscription.monthlength,subscription.numberlength,subscription.periodicity,subscription.countissuesperunit,subscription.notes,subscription.status,subscription.lastvalue1,subscription.lastvalue2,subscription.innerloop1,subscription.innerloop2,subscription.innerloop3,subscription.lastvalue3,subscription.firstacquidate,subscription.manualhistory,subscription.irregularity,subscription.skip_serialseq,subscription.letter,subscription.numberpattern,subscription.locale,subscription.distributedto,subscription.internalnotes,subscription.callnumber,subscription.location,subscription.branchcode,subscription.lastbranch,subscription.serialsadditems,subscription.staffdisplaycount,subscription.opacdisplaycount,subscription.graceperiod,subscription.enddate,subscription.closed,subscription.reneweddate,
 subscrip
 tionhistory.biblionumber,
subscriptionhistory.subscriptionid,subscriptionhistory.histstartdate,subscriptionhistory.histenddate,subscriptionhistory.missinglist,subscriptionhistory.recievedlist,subscriptionhistory.opacnote,subscriptionhistory.librariannote,
subscriptionroutinglist.routingid,subscriptionroutinglist.borrowernumber,subscriptionroutinglist.ranking,subscriptionroutinglist.subscriptionid
FROM biblio
LEFT JOIN biblioitems on (biblio.biblionumber=biblioitems.biblionumber)
LEFT JOIN serial on (biblioitems.biblionumber=serial.biblionumber)
LEFT JOIN serialitems on (serial.serialid=serialitems.serialid)
LEFT JOIN subscription on (serial.subscriptionid=subscription.subscriptionid)
LEFT JOIN subscriptionhistory on
(serial.subscriptionid=subscriptionhistory.subscriptionid)
LEFT JOIN subscriptionroutinglist on
(serial.subscriptionid=subscriptionroutinglist.subscriptionid)
LEFT JOIN aqbooksellers on (subscription.aqbooksellerid=aqbooksellers.id) 

Koha accepted to run it and get 1311 results

I only have 35 serials in my db.
In fact the reports gets 1 line for each of my records :(
So I fail QA.

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
You are watching all bug changes.