topic Compare users in the table in Application Development and Automation Discussions

Compare users in the table

former_member204457 — Wed, 12 Sep 2007 13:23:20 GMT

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

Any help would be greatly appreciated.

Re: Compare users in the table

Former Member — Wed, 12 Sep 2007 13:25:48 GMT

hi cyrus

create a view for that table join it

Re: Compare users in the table

Former Member — Wed, 12 Sep 2007 13:26:25 GMT

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