+ Start a Discussion

select id,name,Active_Status_c,picklist_2_c from Account where id NOT IN :acc

what is the meaning of this query

September 7, 2022
·
Answer
·
Like
0
·
Follow
0

Sai Praveen (Salesforce Developers)
Hi Kaustubh,

This is SOQL query where you are retrieving id,Name,Active_Status_c and picklist_2_c fields from Account object and you are using filter such that is will not return the results whose Account ids are not in acc variable.

please find the below article (https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql.htm) for more details on SOQL

Let me know if you face any issues.

If this solution helps, Please mark it as best answer.

Thanks,

September 7, 2022
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

select id,name,Active_Status_c,picklist_2_c from Account where id NOT IN :acc

You need to sign in to do that.