last_edited_user populate

jlandwehrwaukeshacountygovnull

I would like to populate the last_edited_user field using a variable generated from a third party workflow. Is this possible? It continues to pull the SDE versioned user name and ignore my attempts to do a field update with a variable username collected from an authenticated login.

JoeBorgione

I've used this Sql Server trigger on the 'A' table of my centerlines for a number of years:

USE [vecc2012]

GO

/****** Object:  Trigger [vecc].[centerlineseditor]    Script Date: 8/3/2016 11:15:51 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:        <Author,,Name>

-- Create date: <Create Date,,>

-- Description:    <Description,,>

-- =============================================

ALTER TRIGGER [vecc].[centerlineseditor]

   ON [vecc].[a28]

   for INSERT

AS update vecc.a28

--BEGIN

    -- SET NOCOUNT ON added to prevent extra result sets from

    -- interfering with SELECT statements.

    --SET NOCOUNT ON;

    -- Insert statements for trigger here

    Set editor = user

    where objectid in (select objectid from inserted)and user <> 'vecc'   

--end   

It just grabs the user-name to populate the field (unless the user is vecc; that's me);  How does the the third party user name differ from what you are getting?