we have cloud SLX v22.214.171.1249.
I am trying to insert fileds into the mail merge template using the joins to our custom tables and userinfo:
event_invitiation.eventid -->events. eventid
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.