Is it possible to create a query that uses the notes field in the Edit Node page...
Sure. This query will get all the notes for node 123:
SELECT AccountID, TimeStamp, Note
FROM Orion.NodeNotes
WHERE NodeID=123
This query will get just the text of the most recent note for node 123:
SELECT TOP 1 Note
ORDER BY TimeStamp DESC
I was looking everywhere, thank you, that works!
