9 Replies Latest reply: Aug 6, 2012 1:39 PM by David Nelson RSS

    Load & Trim OSUser variable

      I'm trying to implement a "My Assigned Tasks" button whose action selects the currently logged on user (OSUser) from an already existing field (assigned_to). My problem is that the OSUser value needs 11 characters trimmed from the beginning, and this is proving to be difficult. I've put this in the script as a load statement, but get the obvious error that the OSUser field doesn't exist:

       

      LOAD Right(OSUser, Len(Trim)-11) as UserName

      ;

       

      Once I have the OSUser isolated to match the assigned_to field (which will match after the character trim) I might need some advice/suggestions on how to implement this via a button/bookmark combo or other method. Thanks.