Having trouble with SWQL for cus prop entries.
Node.CustomProperties.group_membership = 'AVAYA'
this fails - Query is not valid
any advice?
What is your full query? Are you using this in a custom resource or a report directly?
I'm assuming that group_membership is the name of the custom property?
Im using it directly in the report it self.
At this point Im assuming I am missing some valuable piece of information.
Paste a screenshot of the widget and filter screen where you are trying to use this. There is a wide range of widgets that have been added over the years and annoyingly they are not all consistent in how they use the filters.
Some of them are plain SQL, some are swql, some are SWQL but the code of the widget itself changes your filter trying to be "helpful" so it can be a bit of a pain to pin down the correct syntax to use for all widgets. Most of them have examples of syntax but even those examples have been known to be wrong before.
What kind of report are you trying to write? Is there a use case or answer you are trying to achieve?
Is it possible that you don't have [ group_membership ] in your query as a selected field from Orion.NodesCustomProperties? I've done that a few times myself. Sometimes it's the simplest things... LOL
