Hi,

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

It is a person group. My understanding is that first  I need  a function that return the list of persons belonging to a special person group , still struggling to find it!!!Then use maybe get mail function to return the email of each person.

Thanks

@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>

Thanks but unfortunately I need a function because I am trying to add a Custom Attribute into a Custom Event and it doesn’t accept Select Statement. 

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,

@Thirunavukkarasu Kapilan Thanks for your reply.

It is kind of surprising to hear that such a simple function is not available  now in IFS. 

Without a function I am unable to use a custom Event to notify Users that approval is needed in a certain stage in Business Opportunity ...

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,

just an update, I end up writing the custom event in embedded SQL to be able to access the table because I couldn’t find a function