Hi fabiano Pinto,

For that I would like to suggest you to create a sub entity for the user. The user has logged in or not. 

For example 

User_log_in_details

User_id

HasLogin Boolean by default false.

Follow this- 

1.When you register a user, perform the creation task for User_log_in_details entity with user identifier.

2. When this user login in then update this record as true for has login.

3. As per situation, you can create one screen for admin who will be responsible for the assigning the roles. 

4. List should be who has s not logged in the system by applying join with user and user_log_in_details which user has HasLogin =false. But for only for register person is not a good approach who will assign the roles.

5.  Now keep a dropdown for roles which role the admin wants to assign for each record of user.

Hope this helps.

Thanks

Prince

Hello,

I assume if you are trying to identify the user by key, and later on checking the roles, the easy way is why don't you just fetch the user id of a user from user table from the username or email what so ever is unique in your  case, and then pass that user id to user role table that you will find in system module, this will help you check whether user has any role assigned or not, more over you can just simply pass the user id to check role action and see whether the user has particular  role or not.

Thanks

Tousif Khan

Hi fabiano,

Just join the three tables as shown below and apply the filter of userName

this will give you all the details of any user that you want(including the roles), if you know their userName.

Hope it helps,

Thanks

Hii

    I you can asine the manager role user table i am already share oml logic user page and user details and resolve this issue check OML