As part of a new integration, a developer is asked to implement a new custom search functional that is capable of performing unrestricted Queries and can account for all values within a custom picklist field. Type_ c, on the Opportunity object. The search feature must also account for NULL values. The organization-wide default for the Opportunity object is set to Public Read-Only, and a new custom index has been created for the type_ c, field. There are more than 5 million Opportunity records within the env
A. Create a formula field that substitutes Null values for a sting of text, create an index for the formula field, then use the formula within the where cause
B. Perform two SOQL query; one to query Opportunities where Type c _ NULL, and another to query where Type_ c = Null, then join the result set using Apex
C. Use a SOSL query to return ALL opportunities that have a value of NULL in any field
D. Use the OR operator to combine WHERE Causes to strictly search for each value within the picklist, including Type__ c =NUL