on 2016 Mar 23 4:08 PM
Request clarification before answering.
Hi Youssef,
You can try this simple query to get all the users who have reference user.
select distinct mskey from idmv_vallink_basic where mcAttrName='MX_REFERENCE_USER'
if you wanted to get the reference user is test s_test then, use below query
select distinct mskey from idmv_vallink_basic where mcAttrName='MX_REFERENCE_USER' and mcValue='mskey'
where mskey is the mskey of the ‘reference user (test s_test)mskey’
Regards,
Jaya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
11 | |
8 | |
8 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.