Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.


Action Category list and Form association

SELECT ac.ActionCategoryID
            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('')
            ).value('.', 'NVARCHAR(MAX)'), 3, 4000) AS FormsAssociatedToActionCategory
FROM ActionCategory ac
GROUP BY ac.CategoryName
ORDER BY ac.CategoryName

  • Was this article helpful?