The overdue listing could be enhanced by displaying the issue number for serial results. For example, Géo, by Axel Ganz would become: Géo, by Axel Ganz, No. 379
Hmm, I am surprised that it's not possible - but on the other hand have never tried to do it. We have 2 different syntax for item information in overdues. In theory this should work: <item><<items.enumchron>></item> or <<items.content>> + Cronjob with enumchron specified in the field list
This patch would not impact the letters but in fact the following page : Home › Circulation › Overdues
Created attachment 7138 [details] [review] proposed patch
Adrien, Is the serial value not stored in the enumchron value of the items table? It would be best to avoid joining on another table if we don't need to.
items.enumchron and serial.serialseq seem to be very close indeed. Are they supposed to store the same information? (on my test base, dumped from a real base, these infos are close but not exactly the same) If yes, shouldn't we delete one of them ? (my database is out of synchro on this)
Some differences: The existence of items.enumchron depends on how you work with serials. If you have subscriptions and decide to not create items, only the field in serials will exist. enumchron can have infomration, that is not related to serials. For example you could have volume information there. It's not only available in the serials module, but also in catalguing. Only the field in items can be indexed for search. I think we need both - not sure about the differences.
Ok, so if enumchron can be empty or contain other informations, I guess it would be better to stick with serialseq on this patch? Ian, what do you think?
Sorry if I was not clear :( I think it makes sense to display enumchron, we added it to a lot of pages recently. And this is an overdues report - so there has to be an item :)
It sounds like the conclusion was that a revised patch which uses items.enumchron is required. Marking Failed QA until the revised patch is provided.
Created attachment 8185 [details] [review] proposed patch #2 with enumchron New patch using enumchron instead of serialseq.
Created attachment 8246 [details] [review] Bug 7434: Display of issue number for serials in overdues items.enumchron is now displayed when not null Signed-off-by: Jared Camins-Esakov <jcamins@cpbibliography.com>
Adds enumchron to overdues list. Simple and straight forward, marking Passed QA.
There have been no further reports of problems so I am marking this bug resolved.