SELECT UID_UNSRootB FROM PersonWantsOrg

Hi,

there is no UID_UNSRootB in DB !
I think you mean Ident_UNSRoot, you get it like this:

select ur.Ident_UNSRoot from personwantsorg pwo
join UNSGroup ug on ug.XObjectKey = pwo.ObjectKeyOrdered
join UNSContainer uc on ug.UID_UNSContainer=uc.UID_UNSContainer
join unsroot ur on ur.Ident_UNSRoot=uc.Ident_UNSRoot

regards,
Tarigh

There is UID_UNSRootB in UNSGroupB. My goal is how to operate on column that contains XML like in below article:

https://www.quest.com/community/products/one-identity/f/identity-manager/6439/itshop---ask-for-department-membership/16865#16865

but in reference to UNSGroupB.

I would like to fire process for UPDATE event on PWO but limit it to specifiied custom target system (we've some of them) via UID_UNSRootB.

have you tried this:
 

$FK(ObjectKeyOrdered),UNSGroupB.FK(UID_UNSRootB).Ident_UNSRoot$='your_custom_target'

regards,
Tarigh