Method to return User's emails

Hi,

Is this User Group or Person Group? Kindly mention the window/page you view the mail information.

@NMALKI 

I’m not sure whether there exists such function but below SELECT statement might be useful.

select Pers_Comms_API.Get_E_Mail(person_id), t.*

from PERSON_GROUP_ASSIGNMENT_TAB t

where group_id = <the group id you want to query>

Dear @NMALKI , 

I have checked the APP10 core environment and found there is a window called “Person Access Group” and the line level is connected to the Person_Group_Assignment_Tab. I hope this is what you mentioned.

But when consider your requirment to get all the person Id for a specific group through a function, it is not possible in core functions. I have checked the Get methods and there is no get method defined to return a set of records. 

So only possble way to do that by using sql statement like below,

select person_id from person_group_assignment_tab t WHERE t.group_id= ‘groud_id’;

orelse, request a customization to implement new method as per your requirment. 

Best Regards,

Dear @NMALKI, 

Yes!!! I can understand you frustration on this and as I know there are not much functions to return a record set in core environment and most of the functions are designed to return specific data by passing primary key/s. 

Customization could be the only way of achieving this kind of request.  Apologies for that. 

Best Reagrds,