Custom Group Properties in Alerts

t0ta11ed74

Is this not possible? I can add Node custom properties to Application alerts, and I can add Application custom properties to Node alerts. It doesn't look like the Group custom properties are exposed this way? If true, this is massively frustrating since it's easier to add some global info at the group level vs on each and every node. Am I missing something? I'm even willing to do some custom SQL to accomplish this if possible.

t0ta11ed74

In my case this was pretty easy to do with SQL in the alert. Since my groups are all cities where remote offices are (and for the most part only one office per city), I added another custom property to each group called city, then inserted the below into my alerts to get the group details. This works because I'm using a City custom property on the nodes too, so i key off that for my WHERE condition. The only problem with this solution is when there may be more than one office in a city. It'd be nice if I could just reference the group property variable in the alert though.

${SQL: SELECT Address FROM ContainerCustomProperties WHERE City='${N=SwisEntity;M=CustomProperties.City}' }