You need to sign in to do that
Don't have an account?
ZitizonX
xtma_Individual_Email_Result__c
Hi all,
Where can I find information about "xtma_Individual_Email_Result__c" object/Table? I couldnt find any info in the API related docs or SF search.
Thanks
X
~ sfdcfox ~
In terms of the API, the custom relationships work like sub-queries in SQL, so you can do:
select id,firstname,lastname,email,(select id,name,custom_field__c from xtma_individual_email_results__r) from lead
(My apologies if the SOQL isn't quite right, it's late here).
This would give you a list of leads with a sub-list of email results on the lead. You could also reverse the query if it makes more sense, as well, such as:
select id,name,custom_field__c,lead__r.id,lead__r.firstname,lead__r.lastname,lead__r.email from xtma_individual_email_result__c
That type of call will give you a flat list that you can use in a traditional fashion (that is, the result looks like a normal SQL query, with one line per email result and duplicate lead data to fill in gaps as necessary). You might want to take a looksee at the documentation on SOQL-R for more information on querying that type of data.
~ sfdcfox ~
Message Edited by sfdcfox on 06-12-2007 12:59 AM
Thanks very much sfdcfox.. This will help me in heaps. Sleep well mate I will post up the final solution if i get it right...Thanks agian...
X