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

Look Back
ROQL showing different results — 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 showing different results

Received Response
10
Views
1
Comments
edited May 25, 2021 5:40AM in Agent Desktop 1 comment

Content

Hi All,

I have two fields that stores the email address which are in the to and CC field of the email. The data is as <[email protected]>,<[email protected]>,<[email protected]>. When we run the ROQL in the Connect Object Explorer it the gives the results as expected. But, when we use the same query on the portal page is give the Output as only commas (, ,). None of the value is retrieved. Can you please let us know why this is the inconsistency in the result of the query output?

ROQL :

Select Incident.ID, Incident.CustomFields.p.to TO, Incident.CustomFields.p.cc CC from Incident where Incident.CustomFields.p.cc is not Null LIMIT 25;

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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