Add count of template usage
Hello, I need to add to the following query:
select rtl.templatename "Plantilla", rtl.status "Estado", qd.queuename "Grupo de Soporte", cd.CATEGORYNAME AS "Categoría", scd.NAME "Subcategoría" from RequestTemplate_Fields rtf
left join RequestTemplate_list rtl on rtl.templateid=rtf.TEMPLATEID
left join queuedefinition qd on qd.queueid=rtf.groupid
LEFT JOIN CategoryDefinition cd ON rtf.CATEGORYID=cd.CATEGORYID
LEFT JOIN SubCategoryDefinition scd ON rtf.SUBCATEGORYID=scd.SUBCATEGORYID
The count of tiquets opens by each template name.
Thanks!