Skip to main content
Mitratech Success Center

Action Category list and Form association

SELECT ac.ActionCategoryID
    ,ac.CategoryName
    ,substring((
            SELECT ', ' + q.QtemplateName
            FROM QTemplateActionCategory qac
            LEFT JOIN qtemplate q ON q.Qtemplateid = qac.QTemplateID
            WHERE qac.ActionCategoryID = ac.ActionCategoryID
            GROUP BY q.QtemplateName
            FOR XML path('')
                ,TYPE
            ).value('.', 'NVARCHAR(MAX)'), 3, 4000) AS FormsAssociatedToActionCategory
FROM ActionCategory ac
GROUP BY ac.CategoryName
    ,ac.ActionCategoryID
ORDER BY ac.CategoryName
 

  • Was this article helpful?