Send invitation to group from GJ backend

I see, you want to send an email to an entire ACL group on an event. That's not really possible without custom coding, because the recipients email addressed are not available from substitutions. I guess one way to do it would be a CB Query Field that queries for all the users in the Editor ACL group, concat the results as comma separated, then supply that query field as a substitution for the To parameter.

The below query could be used in a CB Query Field to grab a comma separated list of email addresses for all users in a specific usergroup.


With the above replace GROUP_ID_HERE with the usergroup id you want to check for. For example 2 is generally Registered.

Thank you very much,

can you just clarify what you mean by "For example 2" ?

Thanks again

devodave wrote: Thank you very much,

can you just clarify what you mean by "For example 2" ?

Thanks again

In Kyle's SQL code you see:

WHERE g.`group_id` = GROUP_ID_HERE

and his comment stating:

With the above replace GROUP_ID_HERE with the usergroup id

2 is the number you should use for the registered user group.

But you should really verify this from your Joomla usergroups table.

Thank you guys for your help,

So if I understood correctly:
1) create field - for example- UE_publisherCAT with above query
2) create auto action with [UE_publisherCAT] for the 'to' parameter

Is this right, or there is another way to supply the query field as a substitution for the To parameter?

Thanks for your assistance

So if I understood correctly:
1) create field - for example- UE_publisherCAT with above query
2) create auto action with [UE_publisherCAT] for the 'to' parameter

Is this right, or there is another way to supply the query field as a substitution for the To parameter?

Yes, your steps are correct. You create the query field then substitute it in as the To.