Add way to search for all people with a certain group role

[ChurchCRMBugReport]

It would be useful to have a search box on the /v2/people page to find people across all groups with a certain group role.

For example I'd like to email all people with the role "Chair" across all groups (committees).

I am using this SQL query to accomplish this in the meantime:

SELECT grp_Name, lst_OptionName, per_FirstName, per_LastName, per_Email FROM person_per LEFT JOIN person2group2role_p2g2r ON person2group2role_p2g2r.p2g2r_per_ID = person_per.per_id LEFT JOIN group_grp ON person2group2role_p2g2r.p2g2r_grp_ID = group_grp.grp_ID LEFT JOIN list_lst ON group_grp.grp_RoleListID = list_lst.lst_ID AND person2group2role_p2g2r.p2g2r_rle_ID = list_lst.lst_OptionID where lst_OptionName = "Chair";

Collected Value Title	Data
Page Name	/v2/index.php
Screen Size	1080x1920
Window Size	921x1250
Page Size	1721x1250
Platform Information	Linux crm 4.15.0-72-generic #81-Ubuntu SMP Tue Nov 26 12:20:02 UTC 2019 x86_64
PHP Version	7.2.24-0ubuntu0.18.04.1
SQL Version	5.7.28-0ubuntu0.18.04.4
ChurchCRM Version	3.5.5
Reporting Browser	Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36
Prerequisite Status	All Prerequisites met
Integrity check status
Apache Modules	core,mod_so,mod_watchdog,http_core,mod_log_config,mod_logio,mod_version,mod_unixd,mod_access_compat,mod_alias,mod_auth_basic,mod_authn_core,mod_authn_file,mod_authz_core,mod_authz_host,mod_authz_user,mod_autoindex,mod_deflate,mod_dir,mod_env,mod_filter,mod_mime,prefork,mod_negotiation,mod_php7,mod_reqtimeout,mod_rewrite,mod_setenvif,mod_socache_shmcb,mod_ssl,mod_status

[jasondunsmore]

FYI, I submitted this

[github-actions[bot]]

This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

[github-actions[bot]]

This issue was closed because it has been stalled for 15 days with no activity.