A trigger that updates the actualStartDate when it’s created, actualEndDate when it’s completed, and orgUnit1 and orgUnit2 when it’s responsible employee is changed.
VISMA_CLIENT_ID
and VISMA_CLIENT_SECRET
.orgUnit2
-table and ALL
events. This will give you some sample code, but we’ll just remove all of that.
orgUnit1
, orgUnit2
, orgUnitProcessing
, actualEndDate
, actualStartDate
, changedDate
, and the official
-field from the project.
To simplify creating the query, we can use the playground in Business NXT to create the query. The query will look like this: