Standard picklist fields in Real-Time Events are not queryable or filterable in asynchronous SOQL
Last updated 2021-10-12 ·Reference W-7189367 ·Reported By 4 users
Standard picklist fields in Real-Time Events are not queryable or filterable in asynchronous SOQL. This bug can be reproduced by performing an Async SOQL on ReportEvent.Operation. Regular SOQL queries do return the values of the affected picklist field.
1) Create reportEvents with different Operation field values. If reportEvent has been configured as storable via Event Manager, you can do this by exporting various reports.
2) Perform an Async SOQL query (https://developer.salesforce.com/docs/atlas.en-us.bigobjects.meta/bigobjects/async_query_running_queries.htm) to map a picklist field to a text in your target custom entity using the following steps:
a) Enter the following SOQL query on the ReportEvent big object with the following details:
SELECT Name, Operation FROM ReportEvent
Operation type: INSERT
Target Object: Report_Event__c
b) Map the standard fields to the custom fields:
c) Submit the query.
d) Monitor the job status until completion.
e) Run a SOQL query on Report_Event__c:
SELECT Report_Event_Name__C, Report_Event_Operation__c FROM Report_Event__c WHERE CreatedDate = TODAY
Expected Result: The actual value from the event picklist should be populated in the target entity.
Actual Result: The picklist fields in the target entity are null.
Until the bug is fixed, perform queries via regular SOQL.
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.