Compare users in the table

[former_member204457]

Hi Gurus,

I want to compare two users (UNAME) in the table AGR_USERS by roles (AGR_NAME). Let's say User1 has roles A, B, C, D and User2 has role A, F, G. I want the output shows the discrepancy of the roles between users as such

User1 User2

F B

G C

D

Any help would be greatly appreciated.

[former_member204457]

Hi Gurus,

I want to compare two users (UNAME) in the table AGR_USERS by roles (AGR_NAME). Let's say User1 has roles A, B, C, D and User2 has role A, F, G. I want the output shows the discrepancy of the roles between users as such

User1 User2

F B

G C

D

Any help would be greatly appreciated.

[Former Member]

hi cyrus

create a view for that table join it

[Former Member]

HI,

You can use the below function module to get the User roles

ALM_ME_GET_USER_BY_ROLES

then write the code for your requirment

Regards

Sudheer