0

Here's my question on custom big object: can we filter a record under big object?. I just want to filter and show an account record based on account name, here we are storing about 300,000 records of some custom object.

  • Account is not a BigObject. Can you clarify by editing your question how you are using BigObjects in this scenario? Or is your question related to high data volume? – David Reed Feb 27 '18 at 18:51
  • Agree with you David, for example if it's a custom Order__b big object. Can we search a record based on order number? where I have already stored some 300,000 records?. – Laxman Feb 27 '18 at 18:53
1

Yes, you can perform a SOQL query against a BigObject table. However, there are very significant limitations as to how you can construct your query.

The true answer to your question is going to ride on how your BigObject is defined. That's because the specific fields, and their order, in the BigObject's index defines how you can use standard SOQL against it.

If you're working with a BigObject Order__b and it has an Order_Number__c field that is the first field in its index, you can query using WHERE Order_Number__c = :SOME_ORDER_NUMBER, for example.

If you want to do something more than that, you'd need to use Async SOQL to filter a dataset into a new custom object that you can then operate upon.

| improve this answer | |
  • and I can show the results on visualforce page also right?. – Laxman Feb 27 '18 at 19:06
  • I can't say as I've ever built a Visualforce page using BigObjects. I don't know if there are limitations there. – David Reed Feb 27 '18 at 19:07
0

As I completed a small project on Big object, I can say this can be done with Index fields. Please take assess which fields you want to filter and take index on those fields, so that you will be able to filter the records in the SOQL query.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.