User List by Email Filter — Confluence Cloud Macro

## Fetch groups
#set($groups = $ConfluenceManager.get("/wiki/rest/api/group"))

## Check if there are any groups available
#if ($groups && $groups.results.size() > 0)
#set($uniqueEmails = {}) ## A map to store unique email addresses and corresponding user names

## Loop through each group to retrieve group members
#foreach($group in $groups.results)
#set($groupMembers = $ConfluenceManager.get("/wiki/rest/api/group/$group.id/membersByGroupId"))

## Loop through each member in the group
#foreach($member in $groupMembers.results)

## Check if the email matches the filter and is not already in the uniqueEmails map
#if ($StringUtils.contains($member.email, $parameters.emailFilter) && !$uniqueEmails.containsKey($member.email))
#set($discard = $uniqueEmails.put($member.email, $member))
#end
#end
#end

## If no matches are found, show a message indicating no matching email addresses
#if ($uniqueEmails.size() == 0)
<p>
    No email addresses match the filter: <strong>$parameters.emailFilter</strong>
</p>
#break
#end

## If there are matching email addresses, display them in a table
#if ($uniqueEmails.size() > 0)
<table class="aui aui-table-interactive aui-table-rowhover" style="width: fit-content;">
    <thead>
        <tr>
            <th>Name</th>
            <th>Email</th>
        </tr>
    </thead>
    <tbody>
        ## Loop through the uniqueEmails map to display each entry
        #foreach($entry in $uniqueEmails.entrySet())
        <tr>
            <td><a href="${baseUrl}/people/${entry.value.accountId}" target="_blank">$entry.value.displayName</a></td>
            <td><a href="mailto:$entry.key">$entry.key</a></td>
        </tr>
        #end
    </tbody>
</table>
#end
#end