You need to sign in to do that
Don't have an account?
Salesforce P1
Big Objects - Filters may not have any gaps within the composite key
Hi,
We have created a Big Object with the Index configured with 2 fields. We have a SOQL in Apex , having filter criteria on both the index fields. However, still we are encountering the error 'Filters may not have any gaps within the composite key'. Any one who came across this behaviour and has any work around, please share your thoughts.
We have created a Big Object with the Index configured with 2 fields. We have a SOQL in Apex , having filter criteria on both the index fields. However, still we are encountering the error 'Filters may not have any gaps within the composite key'. Any one who came across this behaviour and has any work around, please share your thoughts.
All Answers
Considering the best practices for querying with Big objects, we need to query with filters without leaving any gaps between the first and the last field in the query.
See related posts:
https://developer.salesforce.com/docs/atlas.en-us.bigobjects.meta/bigobjects/big_object_querying.htm
https://salesforce.stackexchange.com/questions/248375/indexed-big-object-soql-limitation-in-apex-class
https://developer.salesforce.com/forums/?id=9062I000000g8aQQAQ
If this information helps, please mark the answer as best. Thank you
As i mentioned, we have covered all the index fields in the SOQL criteria, still the error persists.