I ran a SOQL query from the developer console on one of my external objects which has a picklist field (Object name Fixture__x, picklist field name Status__c).
The following query:
SELECT Id, Status__c from Fixture__x
returns a couple of records with a status of
Then I tried:
SELECT Id, Status__c FROM Fixture__x WHERE Status__c = 'Scheduled'
The Query editor threw an error:
sObject type 'Fixture__x' is not supported.
However, if I execute the very same query in APEX, I get no errors, rather this debug log:
Picklists aren't supported in the SOQL WHERE clause for external objects.
Is this documented anywhere? Any reason why they aren't supported? Is there anything I'm missing or it needs to be done differently in order to achieve this? Aren't the picklists treated as strings (text) anyway?