Hello
we have cloud SLX v8.1.0.1179.
I am trying to insert fileds into the mail merge template using the joins to our custom tables and userinfo:
contact.contactid----->event_invitiation.contactid
event_invitiation.eventid -->events. eventid
events.accmgrid--->userinfo.userid
When I add userinfo.username&phone&email for acc. mgr from events table I am getting the "Parse SQL error"
The local join that I created events.accmgrid--->userinfo.userid does not stick when I reopen the template.
I created a global join in query builder - it's not showing up when I insert fields from template.
Thanks!
|