cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

Variables in "Custom Table" widget

Jump to solution

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

0 Kudos
1 Solution
I believe the group details view uses ${id} instead
- Marc Netterfield, Github

View solution in original post

2 Replies
I believe the group details view uses ${id} instead
- Marc Netterfield, Github

View solution in original post

Level 8

Hi Marc

Thx for pointing that out.
It worked like a charm 🙂

Wkr
Alain

0 Kudos