Apex Code Development You need to sign in to do that
Don't have an account?
Passing dynamic value in where clause in SOQL in bigObject
Hello experts,
I am trying to hit data using SOQL on bigobject,
Where accId:
public String accId;
List<BigObjectTaskData__b> tempList = [select id from BigObjectTaskData__b where whoId__c =: accId];
So, I am getting error in where clause(where whoId__c =: accId)
If I do not use (where whoId__c =: accId) it works
And if use where clause like (where whoId__c ='0035D000006FdfWQAS'), So it works well.
help me, how to pass "accId" variable value in where clause??
I am trying to hit data using SOQL on bigobject,
Where accId:
public String accId;
List<BigObjectTaskData__b> tempList = [select id from BigObjectTaskData__b where whoId__c =: accId];
So, I am getting error in where clause(where whoId__c =: accId)
If I do not use (where whoId__c =: accId) it works
And if use where clause like (where whoId__c ='0035D000006FdfWQAS'), So it works well.
help me, how to pass "accId" variable value in where clause??
write a string query dynamically and execute that string query.