Hi,

On Mon, May 3, 2010 at 4:12 AM, LAURENT Henri-Damien
<[email protected]> 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
[email protected]
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches

Reply via email to