Variables in "Custom Table" widget

alain_p

Hi everyone,

After seeing the post "Node Details -SQL" by @cscoengineer , wanted to try this on our environment.
Everything worked fine for Nodes Custom Properties using ${NodeID}

But as soon as I wanted to utilize this method for groups (Containers) by using  ${GroupID} 
ex code used:  

SELECT 'Name GCP1' AS [c], GCP1 AS [v] FROM ContainerCustomProperties WHERE ContainerID = ${GroupID}

I get an error message --> Query invalid

If  I keep 'use current network object as Data Source' checked, it displays the custom properties, but not in the way I would like. (

Anyone an idea on how to solve this.

All help welcome. Thanks.

Alain

mesverrum

I believe the group details view uses ${id} instead