2

I'm learning Big Object on trailhead and I have completed deploy the big object to my org.

But I have a question is that: how can I query non-index field by SOQL? I know that only index fields can be used in filter and returned, how can I get the value of those non-index fields? When I include non-index field in SOQL, it said:
"No such column 'Level_Achieved__c' on entity 'Customer_Interaction__b' ".

If I can't get the value of those fields, how can I reuse those records in big objects in the future?

Below is the SOQL I Use:

SELECT Account__c,CreatedById, Level_Achieved__c FROM Customer_Interaction__b

SOQL Error Message

My Big Object Data Model

Improve this question
3
  • 1
    Can you check FLS of those fields ?
    – Mohith Shrivastava
    Apr 11, 2019 at 2:56
  • 1
    @MohithShrivastava Thanks, I found I forget edit the FLS for those fields, now I can query those fields in SOQL.
    – Zas
    Apr 11, 2019 at 3:09
  • Added as an answer to help others
    – Mohith Shrivastava
    Apr 11, 2019 at 3:16

1 Answer 1

Reset to default
4

The issue here is your system admin profiles do not have the field level security as read for those fields .

Check your system administrator profile and Mark these fields with read permission at least to use in soql .

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .