ROQL showing different results
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?
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;