i need to change/reestablish the time assigned to an activity, it is possible when some data is previously loaded ?

Confluence User - 24 Jul, 2017

Change the time assigned an activity...??

process;workflow;database

1


25 Jul, 2017
confluenceUser
confluenceUser
  • From the database, look for the table named "shkactivities".
  • There are various columns related to date/time.
  • I think the one you are looking for is Activated
  • Use this SQL function to convert the unixtime to what you can understand.

     

    FROM_UNIXTIME((aci.Activated-aci.ActivatedTZO)/1000)
RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print