What's new in Customer Journeys?

Connect and learn more! ×
ROQL for Organization Notes — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ROQL for Organization Notes

Accepted answer
edited Jun 8, 2022 12:11PM in General Technical Discussions 2 comments


I am trying to get Organization notes using ROQL. However, we cannot access because it is an array like Notes[0].Text.


Select ID, Organization.Notes[0].Text from Organization 

I can get this notes using custom report. In report, I need to build inner join with

orgs.org_id = notes.id AND notes.tbl = 3

As per business requirement, we need to use ROQL to get Org notes.

Does anyone has an idea (except custom report or use Analytics report in ConnectPHP) about org notes using ROQL ?

Appreciate your help

RN Version - 21 B

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!