From 7e7041a85c8dfdabe389f1ac5441dd5dfdc537c7 Mon Sep 17 00:00:00 2001
From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Date: Fri, 24 Jan 2020 11:04:05 +0000
Subject: [PATCH] Bug 24305: (follow-up) Add small comment for square brackets
 in get_prepped_report

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

Signed-off-by: Joy Nelson <joy@bywatersolutions.com>
---
 reports/guided_reports.pl | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/reports/guided_reports.pl b/reports/guided_reports.pl
index 3cae7cd546..5059e9502a 100755
--- a/reports/guided_reports.pl
+++ b/reports/guided_reports.pl
@@ -1083,6 +1083,9 @@ sub get_prepped_report {
     my ($sql, $param_names, $sql_params ) = @_;
 
     # First we split out the placeholders
+    # This part of the code supports using [[ table.field | alias ]] in the
+    # query and replaces it by table.field AS alias. Not sure why we would
+    # need it if we can type the latter (which is simpler)?
     my @split = split /\[\[|\]\]/,$sql;
     my $headers;
     for(my $i=0;$i<$#split/2;$i++){ #The placeholders are always the odd elements of the array
-- 
2.39.5