• State Verified Answer
  • Locked Locked
  • Replies 2 replies
  • Subscribers 94 subscribers
  • Views 3594 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to delete an entrance from table PersonInOrg (through DB)?

fermin sanjuan
over 5 years ago

Hi everyone,

I want to create a process which triggers when a user gets deactivate.

This process has two parts:

  1. It unsubscribes already all "assigned" requests -> DONE

  2. I want to delete all existing entrances in the table PersonInOrg in case this user is member of any Group/role... -> (that´s my question for you all)

I tried to delete directly the entrances with a whereclause but it is not possible according to the XOrigin value.

I updated the field "XMarkedForDeletion" in the PersonInOrg table, but nothing happended.

Any ideas?

thanks a lot in advance.

Fer

Parents
  • +1 over 5 years ago

    Deleting PersonInOrg objects via HandleObjectComponent should only remove the direct assignment v7+.

    If there are other assignment sources (e.g. indirect assignment), the entry will not be remoed. You need to make sure all assignment sources are revoked. Once XOrigin hits 0. the entry will be removed by a separate process.

Reply
  • +1 over 5 years ago

    Deleting PersonInOrg objects via HandleObjectComponent should only remove the direct assignment v7+.

    If there are other assignment sources (e.g. indirect assignment), the entry will not be remoed. You need to make sure all assignment sources are revoked. Once XOrigin hits 0. the entry will be removed by a separate process.

Children