SOQL Query Inspector and fields of Type JunctionIdList

Issue #2084 resolved
Eric Kintzer created an issue

Execute this query in SOQL Query tool

SELECT id, BccIds, CcIds, ContentDocumentIds, ToIds 
FROM EmailMessage ORDER BY CreatedDate DESC

The inspector flags the four(4) fields of Type JunctionIdList as Cannot resolve symbol because these fields don't have DescribeFieldResult for the EmailMessage object.

Yet the fields do exist on the object per ObjectReference and their values do get returned when making the SOQL query as shown in the screen shot.

Project is configured as V54.0

The same query works in APEX (see second and third screen shots)

Why they are accessible at runtime but not in Describe is beyond me and I’ll tweet this out to the the SFDC PMs to see if they can shed light on this

Comments (3)

  1. Scott Wells repo owner

    Yeah, I see the same thing, and I think I may have noticed that in another open source project (NPSP maybe?) and earmarked it for investigation. Definitely strange that those fields aren't reported by the APIs.

  2. Scott Wells repo owner

    I've updated the OST generator to fill in these missing fields. The change will be in the next build, likely Thursday morning.

  3. Log in to comment