Bug 21392

Summary: Some tables not available to AUTO_RENEW letter
Product: Koha Reporter: Magnus Enger <magnus>
Component: Command-line UtilitiesAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: jonathan.druart, robin
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on: 15705    
Bug Blocks:    

Description Magnus Enger 2018-09-21 12:17:47 UTC
The AUTO_RENEW letter is prepared like so, including data from 4 tables:

 105            my $letter = C4::Letters::GetPreparedLetter(
 106                 module      => 'circulation',
 107                 letter_code => 'AUTO_RENEWALS',
 108                 tables      => {
 109                     borrowers => $patron->borrowernumber,
 110                     issues    => $issue->itemnumber,
 111                     items     => $issue->itemnumber,
 112                     biblio    => $item->biblionumber,
 113                 },
 114             );

http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=misc/cronjobs/automatic_renewals.pl;h=6a170ca20f5f0aabc81f340b2c70b25dd8d4206a;hb=HEAD#l105

But when you go to Tools > Notices & slips to edit the contents of AUTO_RENEWALS, several more tables are listed as available. This includes: 

- branches
- biblioitems
- opac_news

If you try to include information from these three tables it will be missing from the final letter.