Variable Custom HTML links on group summary page

thedba

Hi,

I would like to create a Custom html link on a group summary page that would direct to a specific url for each group. 

I was hoping to accomplish this by storing the relevant url information in a custom property and calling it as a variable.

<a href="https://servicenow.com/sys_sysparm_report_id=${snowrpt}">SNOW Report</a>

That did not work as any custom property variable that I try to pass is not resolved.

The only variables that I was able to pass through are ${Caption} and ${Description}.  I can't store the url information in these fields so it is not a workable solution. 

I also tried to retrieve the variable through a SQL statement but that would not work either.  It just passes the sql syntax as the url. 

<a href="https://servicenow.com/sys_sysparm_report_id=${SQL:{select snowrpt from ContainerCustomProperties where containerID=1:}}">SNOW Report</a>

Any suggestions?

Thanks!

mesverrum

Just to be clear, summary pages almost never resolve useful variables, do you mean group details page?  The best way I have found for figuring out which variables will resolve is just to go to the database table for whatever object I'm editing the details page of.  For example on groups I typically have to use ${id} or ${name} for some custom SQL/SWQL wizardry because the custom properties live on a different table than the groups do (Containers).

Try making a custom SWQL resource (Custom Query) with the following

select c.customproperties.snowrpt as [Service Now Report], concat('https://servicenow.com/sys_sysparm_report_id=​​',c.customproperties.snowrpt) as [_linkfor_Service Now Report]

from orion.container c

where c.containerid=${id}