[Koha-bugs] [Bug 13392] New statistics wizard for suggestions

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

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

Julian Maurice <julian.maurice at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Failed QA                   |ASSIGNED

--- Comment #11 from Julian Maurice <julian.maurice at biblibre.com> ---
> 1) I am not sure about adding ordereddate and orderedby as those seem
> duplicating the information we can get from aqorders.entrydate and
> aqbasket.authorisedby.

It seems there is no direct link between a suggestion and an order line.
Are you suggesting we should create this link ?


> 3) For MARC21 the publicationyear is saved in the copyrightdate column
> in the database. Please change so that copyrightdate is used in the
> SQL query for MARC21 databases.

It seems in fact that suggestions.publicationyear is not used at all (my
own database only contains NULL or 0 in this column whereas
copyrightdate contains the actual data)


> In testing this I had difficulties with getting a suggestion into the
> ORDERED status with and without the patches - can you check if that
> works for you? The new database fields stayed empty too :(

Yes, it worked for me, but I will re-check.

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