List of signed Macros

David Hale asked on October 23, 2018 11:12

Hello,

I am currently looking for a way to output the kentico list of signed macros as a string.

I am aware there is a in cms report function but I am looking for a way to do this programmatically outside. Is there a way to achieve this?

macros

Recent Answers

Brenden Kehren answered on October 23, 2018 17:48

I'd suggest looking at the report SQL and that should help get the API's and/or query you can use to generate it on your own.

0 votesVote for this answer Mark as a Correct answer

Peter Mogilnitski answered on October 24, 2018 16:43 (last edited on December 10, 2019 02:31)

You can do it with SQL query more or less: select convert(xml ,PageTemplateWebParts),* from CMS_PageTemplate where PageTemplateWebParts like '%{[%]%|%'

This query above will return all page templates with unsigned macros. One template can have many unsigned macros. It is not a final regex but you need to experiment here. The idea is to search for macros like {% ...|(...|(identity)GlobalAdministrator%}. This query will give all templates with unsigned macros.

0 votesVote for this answer Mark as a Correct answer