function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion


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!

Message Edited by JDev on 09-26-2006 03:03 PM