%mapquery() is limited to just the ObjectTbl table, so it's not possible to use this function to search based on notes. You'll need to use a separate sql connection to the mapfile to do this.
Is it possible to search with %mapquery for rooms with a given room note, in the way that one can with room name?
If so, what is the required syntax for my sql query?