This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revisionLast revisionBoth sides next revision |
sa37-00 [2015/01/14 13:01] – davidbell | sa37-00 [2017/12/01 16:35] – external edit 127.0.0.1 |
---|
-- RETURN null; -- if not using EWS | -- RETURN null; -- if not using EWS |
set rv = 'EWS'+crlf; -- mandatory for EWS | set rv = 'EWS'+crlf; -- mandatory for EWS |
set rv = string(rv,(select (select staff.Email || '; ' from staff where Staff.staffid = UserStaffID ) || list(number,';' order by pt.name asc) from Phone as p key join PhoneType as pt where p.WhoID = UserStaffID and p.Who = 'U' and pt.Capabilities = 'E'),crlf); -- one or more sender addresses separated by ; Use userstaffid to look up valid ones for logged in user. | set rv = rv + string(rv,(select (select staff.Email || '; ' from staff where Staff.staffid = UserStaffID ) || list(number,';' order by pt.name asc) from Phone as p key join PhoneType as pt where p.WhoID = UserStaffID and p.Who = 'U' and pt.Capabilities = 'E'),crlf); -- one or more sender addresses separated by ; Use userstaffid to look up valid ones for logged in user. |
-- set rv=rv+'IQXEWSSendMail.exe'+crlf; -- the program to call (with full path if not either in system path or iqx.exe folder). Notepad.exe handy for testing. | -- set rv=rv+'IQXEWSSendMail.exe'+crlf; -- the program to call (with full path if not either in system path or iqx.exe folder). Notepad.exe handy for testing. |
set rv = rv+'IQEWSSendMail.exe'+crlf; -- the program to call (with full path if not either in system path or iqx.exe folder). Notepad.exe handy for testing. | set rv = rv+'IQEWSSendMail.exe'+crlf; -- the program to call (with full path if not either in system path or iqx.exe folder). Notepad.exe handy for testing. |