We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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
1
Views
2
Comments
edited Oct 22, 2021 6:18PM in Integrations and APIs 2 comments

Hi,

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

ROQL

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.

Register

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