Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
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
7
Views
2
Comments
edited Jun 8, 2022 12:11PM in General Technical Discussions 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!