Report to find which templates include a certain product and/or report to find templates that include inactive products
Submitted by gretalloyd on Tue, 14/09/2021 - 21:25
Hi,
Is there a report or a way to find which templates include a certain product? I want to change the product on some of templates (but not change the product completely) and would save time not having to go through one by one looking for them.
Also, is there a report or a way to find templates that include any inactive products?
Greta
Re: Report to find which templates include a certain product ...
I'm not aware of any report that does this.
If you want to have a go at generating such a report, some basic SQL to generate a listing of templates and their included products is shown below.
Alternatively, if you want fund development of a report, please let us know at support[at]openvpms[dot]com. Please consider contributing it back to the project so other users can benefit.
-Tim
Re: Report to find which templates include a certain product ...
G'day Greta,
Is this the type of report you were after? It uses TimA's SQL, but needs a little more tidy-up, like parameters for selecting templates and maybe better labels for the fields.
Simon
Simon Slater
Registered Linux User #463789 @ http://linuxcounter.net
Re: Report to find which templates include a certain product ...
That is exactly what I was after, thanks so much Simon!
Re: Report to find which templates include a certain product ...
Here is a better version with parameters to select active templates and names of templates and products. Note that using the latter will only show those producs in each template, omitting any other product contained in the same template.
Given that this would be for internal use, the margins are small. If printed, there should be enough other space for annotating etc.
Simon
Simon Slater
Registered Linux User #463789 @ http://linuxcounter.net