I would like to be able to pass in the table/slice name into the template as a variable, which can then be used in the select. (I have tried to use <<_APPNAME>> but it doesn’t work for me. I have also tried to set the <<_RULENAME>> to the table name but it doesn’t work in the select).
I currently have 3 slices which I use to produce reports. The slices are of 3 shifts. The reports are identical, except that I have to explicitly name the slice in the select statement in each report. It is not possible to pass in the table/slice name and use this table/slice name in the template. This means any changes to a template has to be done in all 3 templates. My app will later need to produce similar reports for different sites (up to 8), which will mean the number of templates will grow even further and make maintenance of the templates even harder.