Hi
I have one node - and I would like to know what swql query I can create so I can see all the alerts on that node
For what it is worth, there are already a couple of useful widgets on the Node Details view that deal with alerts on the node being viewed. One is "All Alerts this Object Can Trigger", and the other is "Active Alerts on This Node". The second one will be hidden if there are no active alerts on the node.
Does that help?
Do you want the current active alerts or any alert that COULD trigger? They are very different queues. The first is easy, the second is much more difficult - maybe impossible.