Knowledge: DataAction using Approvers DataRoom Source to Populate Approvers for Workflow
Back
    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
    Privacy Policy
    Cookies help us to improve your user experience. By using this site you consent to cookies being stored on your device. Read more...
    Back to Top
    View or hide all system messages