on 05-28-2014 10:20 AM
My user (MX_PERSON) has some standard attributes as MX_LASTNAME. MX_FIRSTNAME, MSKEYVALUE, DISPLAYNAME.
So I added some 3 custom attributes (Z_NATIO, Z_FAMST, Z_GENDER):
After populating some users data in IDM,
MSKEYVALUE MX_LASTNAME MX_FIRSTNAME DISPLAYNAME Z_NATIO Z_FAMST Z_GENDER
user1 LN1 FN1 LN1 FN1 US M 1
user2 LN2 FN2 LN2 FN2 UK F 2
user3 LN3 FN3 LN3 FN3 IT F 3
Here is my request to get all the users' information including the 3 added custom attributes:
select MSKEYVALUE, MX_LASTNAME, MX_FIRSTNAME, DISPLAYNAME, ????? from idmv_link_ext where mcThisMSKEYVALUE in (user1,user2,user3)
Could you please help me to get also the 3 attributes values for all users ?
Many Thanks,
Michaela
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Chris and Brandon.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.