DataAction using Approvers DataRoom Source to Populate Approvers for Workflow

Knowledge: DataAction using Approvers DataRoom Source to Populate Approvers for Workflow

Back

Knowledge

Title*DataAction using Approvers DataRoom Source to Populate Approvers for Workflow

ManualAdministration

Manual Level TwoData Actions

Created21/02/2022

DetailDECLARE @SourceApplicationID as int = 0;
DECLARE @TaxonomyEntry as nvarchar(max) = '';
DECLARE @Emails VARCHAR(8000) ;
DECLARE @DisplayNames VARCHAR(8000);
SELECT @Emails= COALESCE(@Emails + ';','') + TextFieldX,@DisplayNames= COALESCE(@DisplayNames + ';','') + Users.DisplayName FROM Claims Join Users ON TextFieldX=Email WHERE ApplicationID=@SourceApplicationID AND ISNULL(Claims.Archived,0) = 0 AND ISNULL(Claims.TextFieldX) = @TaxonomyEntry
SELECT @Emails as Approvers, @DisplayNames as ApproversDisplay