You need to sign in to do that
Don't have an account?
nikoo.malek1.3927635000918623E12
How access to field from second table in joint statement
I try to join 2 tables in SOQL that I am using in C#. not sure how get the value from second table that is contact table.
This is my query:
SOQL = "select Name,FirstName,LastName,BillingCity,Id, (Select ID, LastName,Title from Contacts) from Account";
queryResult = SfdcBinding.query(SOQL);
if (queryResult.size > 0)
{
for (int i = 0; i < queryResult.size; i++)
{
Account acc = (Account)queryResult.records[i];
string name = acc.Name;
string FirstName = acc.FirstName;
string LastName = acc.LastName;
string city = acc.BillingCity;
string Id = acc.Id;
}
how access to ID, LastName,Title from contact table in code?
This is my query:
SOQL = "select Name,FirstName,LastName,BillingCity,Id, (Select ID, LastName,Title from Contacts) from Account";
queryResult = SfdcBinding.query(SOQL);
if (queryResult.size > 0)
{
for (int i = 0; i < queryResult.size; i++)
{
Account acc = (Account)queryResult.records[i];
string name = acc.Name;
string FirstName = acc.FirstName;
string LastName = acc.LastName;
string city = acc.BillingCity;
string Id = acc.Id;
}
how access to ID, LastName,Title from contact table in code?
In SOQL query try like this:
Select id,Name,BillingCity,(Select Contact.id,Contact.LastName,Contact.Titile from Account.Contacts) from Account.
SOQL = "Select id,Name,BillingCity,(Select Contact.id,Contact.LastName,Contact.Title from Account.Contacts) from Account";
queryResult = SfdcBinding.query(SOQL);
if (queryResult.size > 0)
{
for (int i = 0; i < queryResult.size; i++)
{
Account acc = (Account)queryResult.records[i];
string name = acc.Name;
string FirstName = acc.FirstName;
string LastName = acc.LastName;
string city = acc.BillingCity;
string Id = acc.Id;
}
But now the acc.FirstName and acc.LastName; that are coming from contact table are Null. How I can get the value from contact Table?