Retrieve Simple Task Note Field with ROQL
I'm trying to retrieve some task related infos to create a new page at my company's CP. We use our environment to manage our customers projects, with this objective we use incidents as "projects" and the tasks to summarize the project tasks.
At our CP, the contact can see the projects and we want to provide a way for them to see the task development individually, instead of just the curernt global status of the project.
Until now, we were able to access all the information we needed with ROQL, but we are having problems to figure out how to access the note field (task.note at the workspace console or report). We were only able to access the infos on the Note object's array, wich is also a desired info, but since on the task.note we long describe the task goal, we believe this is an important information to show.