SOQL returns error

[Adam Stepanek]

Hi Scott,

I have a SOQL query here which returns error in query editor, but runs fine in anonymous console or Salesforce Inspector extension.

SELECT
        Id
FROM Template_Field__mdt
WHERE Id IN (
        SELECT Field__c
        FROM Template_Field_Junction__mdt
        WHERE Template__c = 'm0BAU000001IN8r2AG'
)

in query editor it returns

org.apache.cxf.binding.soap.SoapFault: EXTERNAL_OBJECT_UNSUPPORTED_EXCEPTION: COUNT() query could not be processed

‌

[Scott Wells]

Delivered in 2.2.8.1.

[Adam Stepanek]

Thx for quick fix

[Scott Wells]

You bet! You caught me at the exact right time, and the fix was just adding EXTERNAL_OBJECT_UNSUPPORTED_EXCEPTION as another known/allowed error message when trying to execute a COUNT() query, so VERY low risk for a last-minute change.