Custom entry type creation
I have Created a custom entry type called "Position" with MSKEYVALUE, displayName, MXMEMBER_MX_ROLE
and MXMEMBER_MX_PRIVILEGE . I am creating new position (via UI task) and storing mapped roles and privileges within corresponding attributes. This workig as expected. I want to know from which tables or view I can get to know which positions and which roles or privileges?
Use something like this.
select mcThisOcName as EntryType,mcThisMSKEYVALUE as PositionName,mcOtherMSKEYVALUE as RoleORPrivilege,mcAttrName as RefAttribute from idmv_link_ext with(nolock) where mcThisOcName='Position'
All the best !!