• State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 96 subscribers
  • Views 3730 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

SELECT UID_UNSRootB FROM PersonWantsOrg

p.noga
over 8 years ago

We've publish Custom Target System Group to ITShop. When request is accepted in PersonWantsOrg column ObjectKeyOrdered has value:

<Key><T>UNSGroupB</T><P>ff43a49c-9a85-4084-9fa9-d915b3481a47</P></Key>

How to select UID_UNSRootB for UNSGroupB based on value in ObjectKeyOrdered (extract UID_UNSGroupB from XML)?

Parents
  • 0 over 8 years ago

    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

Reply
  • 0 over 8 years ago

    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

Children
No Data