function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
KunalKunal 

Nested Queries using SF API in .NET?

How to do nested queries using SF API in .NET?
 
I have a query that pulles a list of Ids from one table and again searches the same table for a different criteria using the same Ids.
 
In SQL, I would do the following:
 
"SELECT x,y,z FROM SomeTable WHERE x IN (SELECT x from SomeTable WHERE a>b and c>d and e=0) AND y>z"
 
How to do this in Salesforce? Is there an IN command like SQL?
 
I don't think Pulling the results of statement in paranthesis in a dataset would work because I am not filtering the dataset or querying it but using the Ids returned from the dataset to query the same table a different way.
 
May be I can create a lengthy SQL statement from the results of just the statement in paranthesis and construct an OR statement to get the results of the big statement but is Salesforce API so ineffective that it doesn't offer nothing more than SELECT, UPDATE, DELETE?