18 lines
497 B
Transact-SQL
18 lines
497 B
Transact-SQL
UPDATE TBDD_MODULES SET DB_VERSION = '1.5.1.0' WHERE SHORT_NAME = 'SIG_ENV_CR'
|
|
GO
|
|
|
|
--CHANGED 13.11.2024 MS RECEIVER_TERM integriert
|
|
ALTER VIEW [dbo].[VWSIG_ENVELOPE_RECEIVERS] as
|
|
SELECT R.GUID,
|
|
R.EMAIL_ADDRESS,
|
|
R.SIGNATURE,
|
|
ER.ENVELOPE_ID,
|
|
ER.PRIVATE_MESSAGE,
|
|
ER.ACCESS_CODE,
|
|
ER.[SEQUENCE],
|
|
ER.NAME,
|
|
ER.ADDED_WHEN,
|
|
R.EMAIL_ADDRESS + ' - ' + ER.[NAME] AS RECEIVER_TERM
|
|
FROM TBSIG_ENVELOPE_RECEIVER ER
|
|
JOIN TBSIG_RECEIVER R ON ER.RECEIVER_ID = R.GUID
|
|
GO |