List users based on Role assigned

Abhijeet Teli shared this idea 2 years ago
Completed

Team,


Currently we have a way to check how many Corporate Writers we have in our instance, but we cannot check who are those users, for this i need to search in all user base,


When i navigate to Administration -> Admin Console -> Roles i can see Report Writers Role having 10 Members, It would be great if i can click on that number and all corresponding user get listed on a light popup window,


Thanks,

Abhijeet

Best Answer
photo

Hi Abhijeet,

This would be a useful option, and have submitted your idea to the dev team, logged as task #225003.

Unfortunately, there is no ETA I can provide as it has yet to be planned or allocated, but something we expect to do in the future release.

Thanks for your suggestion!

Regards,

David

Comments (4)

photo
1

Hi Abhijeet,


Thanks for sending in the idea. To me, this one sounds pretty reasonable as it definitely would be nice to be able to retrieve a listing of of users assigned to a role directly from the admin console. At the very least, we should be able to put together a usage report that does something similar.


For now, I'm going to go ahead and assign this idea to our product team who will reviewing all of our ideas at the end of the month. We'll be sure to keep you posted on the status of this idea as decisions are made.


Stay tuned!


Kind Regards,


Dustin

photo
1

Hi Abhijeet,


While this enhancement goes through the review process, I just wanted to let you know that is possible to retrieve this information from the Yellowfin Configuration Database. This can be accomplished by running the following query:


  1. SELECT P.IpPerson,
  2. P.FirstName,
  3. P.Lastname,
  4. SMR.RoleCode,
  5. ORCD.ShortDescription
  6. FROM Person AS P
  7. JOIN StaffMemberRole AS SMR
  8. ON P.IpPerson = SMR.IpEmployee
  9. JOIN OrgReferenceCodeDesc AS ORCD
  10. ON SMR.RoleCode = ORCD.RefCode


Anyway, I just wanted to pass this tidbit on in case you are anyone else is looking to find similar information.


Kind Regards,


Dustin

photo
1

Hi Abhijeet,

This would be a useful option, and have submitted your idea to the dev team, logged as task #225003.

Unfortunately, there is no ETA I can provide as it has yet to be planned or allocated, but something we expect to do in the future release.

Thanks for your suggestion!

Regards,

David

photo
1

Abhijeet, this request has been completed and will be in the EOM Jan v7.3 build. Thanks for the idea. Cheers