Apex Code Development You need to sign in to do that
Don't have an account?
JDev PrintAnything
Not sure where to post this. We've been trying to use PrintAnything (Salesforce Appechange tool) to retrieve a custom Object related to Contact via an intermediate custom object to print a contact data sheet. We are able to retrieve Contact and the first level custom object (a child relationship) but have not been able to retrieve the second level ( we need to look up the name of the related ID of the second custom object from the first custom object.) The queries are:
1. retrieve single row - Contact:0035000000KwNB3
2. select Id,Name,CreatedDate,CreatedById,LastModifiedDate,LastModifiedById,SystemModstamp,Contact__c,C_Event__c,RSVP_Status__c,Attended__c from RSVP__c where RSVP__c.Contact__c = '0035000000KwNB3AAN'
3. retrieve single row - C_Event__c:undefined
where we are looking to retrieve in 3 the C_Event Name for all C_Event__c on the returned RSVPs using Filter syntax: Retrieve RSVP__c.C_Event__c.0
Problem identified and resolved the correct syntax for query 3 is Retrieve:RSVP__c.C_Event__c.n with parameter set for mn array return. The tool is very capable but the syntax is specific and a browser doesn't make the best editor!
1. retrieve single row - Contact:0035000000KwNB3
2. select Id,Name,CreatedDate,CreatedById,LastModifiedDate,LastModifiedById,SystemModstamp,Contact__c,C_Event__c,RSVP_Status__c,Attended__c from RSVP__c where RSVP__c.Contact__c = '0035000000KwNB3AAN'
3. retrieve single row - C_Event__c:undefined
where we are looking to retrieve in 3 the C_Event Name for all C_Event__c on the returned RSVPs using Filter syntax: Retrieve RSVP__c.C_Event__c.0
Problem identified and resolved the correct syntax for query 3 is Retrieve:RSVP__c.C_Event__c.n with parameter set for mn array return. The tool is very capable but the syntax is specific and a browser doesn't make the best editor!
Message Edited by JDev on 09-26-2006 03:03 PM