[Koha-patches] [PATCH 12/12] Circulation Log Fixing :

[Galen Charlton]

Hi,

On Mon, May 3, 2010 at 4:12 AM, LAURENT Henri-Damien
<henridamien.laurent at biblibre.com> wrote:
>> * it would break any reports that a library may be running on action_logs
> When clicking on an issue log, getting the biblio back, instead of the
> item checked out seems a serious mis information for me.

tools/viewlog.pl is in fact at the *bib* level; returning the item
whose ID is equal to that of the bib ID would also be incorrect.

> We could also make the information become a JSON notation :
> {"itemnumber": "1234","biblionumber":"5678","notes":"this is a note for
> information"}
> or even :
> {"item":{"itemnumber": "1234","biblionumber":"5678"},"notes":"this is a
> note for information"}
> We could then adapt the HTML with jquery.
>
> This would be meet a more general requirement and allow more flexibility
> onwards.

Storing additional information in a JSON blob is fine, but if queries
are meant to be run on action_logs, separate columns (or a record_type
column) are still necessary to avoid the expense of parsing the JSON
while trying to look up an action_log entry by any ID stored in the
blob.

Regards,

Galen
-- 
Galen Charlton
gmcharlt at gmail.com