Restore Outstanding objects in a custom table?

Been trying to find a solution for restoring Outstanding objects in a custom table. 

The scenarios is like this, Sync from HR-system -> Custom Staging Table -> Person.

The reason for the "staging" table is cause I want to catch some changes there before they're synced to Person, if for some reason an identity is missing from HR, they're marked as Outstanding in the staging table, If the same identity returns in the sync I want to be able to remove the Outstanding state. 

Parents Reply
  • No, you're not stupid. I believe you can create a script that is formatted a special way that you then can select in the sync editor.

    <Tag("Projector")>
    <BaseObjectType("Person")>
    Public Sub CCC_Person_RemoveCompany(unit As IUnitOfWork, entities As IEntity())
       For Each currEntity As IEntity In entities
          If Not String.IsNullOrEmpty(currEntity.GetValue("CompanyMember").ToString()) Then
             currEntity.PutValue("CompanyMember", "")
             unit.Put(currEntity)
          End If 
       Next
    End Sub


    Or you can do it in the staging table as you are updating the rows each time.

Children