New custom property not working for Dashboard

Question

I created a node and interface custom property called Cloud, and assigned a few devices/interfaces with 'Azure' and when I try to filter Cloud = 'Azure' on a Percent utilization I am getting the error: Custom SWQL filter is incorrectly formatted.

If I change the filter to something like City = 'Something' it does work, not sure what the issue is.

mesverrum · Answer

My first thought is you probably made it an interface property and not a node property, that's why it worked for the ootb node property of City but not your new one.   Depending on which widget exactly you are talking about the syntax for an interface property might be different,  or it might not be allowed at all.   You'll want to provide some screenshots so people can see exactly what you are working with.

lynchnigel · Answer

for custom properties you can do things like...

FROM Orion.Nodes n

Status = 2 AND (caption) LIKE '%'  + ('edge')

WHERE (n.CustomProperties.azure)  LIKE ('Azure'))

adam.beedell · Answer

Try LIKE instead of =