Field update in a transition Question

0
Hello!

Is there a possibility to identify if a particular field is updated/changed in a given transition ?

I'm trying to check it in ts_changeactions, ts_changes but not getting idea to bring all together to identify a particular field update with a given transition.

And I've to use this in a teamscript.

Let me know.

Thank you!
Responses (4)
  • Accepted Answer

    Wednesday, May 20 2015, 07:11 AM - #Permalink
    0
    I assume since you mentioned the TS tables you mean some way to know outside of looking at the item itself within the interface, like an external query or something? I'm sure since the data is displayed in the change history there will be some way to query for it
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, May 20 2015, 08:45 AM - #Permalink
    0
    The easiest way to check on a particular transition is to run a post-transition AppScript and check to see if the dbval for that field is different then the value. See GetDbValue and GetValue for the Field object within the AppScript Reference Guide.
    Like
    The reply is currently minimized Show
  • Accepted Answer

    Michael
    Michael
    Offline
    Wednesday, May 20 2015, 10:03 AM - #Permalink
    0
    Like Lynn said:

    Function GetOldValue(inFieldName)
    Dim fldlist, fldobj, retValue
    Set fldlist = Shell.item.Fields()
    Set fldobj = fldlist.FindField(inFieldName)
    Call fldobj.getdbValue(retValue)
    GetOldValue= retValue
    End Function

    Call Shell.Item.GetFieldValue("MYFIELD", newValue)
    If newValue <> GetOldValue("MYFIELD") Then
    . . .
    Like
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, May 21 2015, 06:56 PM - #Permalink
    0
    What's the bigger picture? There may be other ways to accomplish whatever it is you're trying to do.

    For example, you can add an action to the form that will set a boolean flag when the field changes.
    The reply is currently minimized Show
Your Reply

Recent Tweets