Is it possible to get an up to date (CRM 7.3) definition for the query objects passed into a template? eg Jeff says in his blog community.sagecrm.com/.../sage-crm-advanced-e-mail-management-creating-a-template.aspx that: PersonObject SQL =
"SELECT * FROM vEmail, vPerson WHERE email_personid = pers_personid AND emai_emailaddress = FromAddress"
but vEmail no longer exists. I'm trying to determine which columns are included; Pers_Salutation seems to be absent, for instance, which is annoying. So, I found in the 7.3 System Administrator Guide (p. 35-15) it says the PersonQuery object "runs the following script":
Select * from vPersonEmail where elink_recordid = pers_Personid and emai_emailaddress = FromAddress
However, vPersonEmail doesn't include any columns prefixed with pers_ and the PersonQuery object passed into a template definitely contains pers_firstname and pers_lastname. Is the documentation just wrong? Is there an updated manual? How do I find out what fields are in the UserObject, CompanyObject and PersonObject objects - without having to resort to trial and error detective work?