To test, well do something like
misc/cronjobs/runreport.pl --subject="My fancy subject!" --to=you@youraddress.com 1
where 1 is the number of your favourite saved report.
Success is your email arrives with the subject "My fancy subject!" Failure is
(with --subject defined) you get either the description of the report, or "Koha
saved report" as the subject. This is success without --subject defined.
Signed-off-by: Frederic Demians <f.demians@tamil.fr>
Bug repeatable and fixed by this patch.
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
my $format = "text";
my $to = "";
my $from = "";
-my $subject = 'Koha Saved Report';
+my $subject = "";
my $separator = ',';
my $quote = '"';
my $type = $report->{type};
$verbose and print "SQL: $sql\n\n";
- if (defined($report_name) and $report_name ne "")
+ if ( $subject eq "" )
{
- $subject = $report_name ;
- }
- else
- {
- $subject = 'Koha Saved Report';
+ if ( defined($report_name) and $report_name ne "")
+ {
+ $subject = $report_name ;
+ }
+ else
+ {
+ $subject = 'Koha Saved Report';
+ }
}
# my $results = execute_query($sql, undef, 0, 99999, $format, $report_id);
my ($sth) = execute_query($sql);