Build LIsts

We need some work done to have some pre built lists (queries built). The lists would be a pull from the users table (but also included related fields from other tables). We are using the native Users function for WP We are using Groups to group them into teams, families etc. AMR Users to create the lists. As for queries - we need list of each team (and pull the family info). There are 7 teams. - full membership list with all members grouped by family - list of all athletes with profiles and parents family User Data Downloadable Spreadsheet Lists need to be made available to people with Admin and Editor status in the Admin Dashboard. People with Editor status are staff who can post NEWS items, change content on pages and have access to these lists below. They should not have full access to making changes to settings or changing User information. I will be using the Admin Menu Editor [login to view URL] which is already installed and upgrade to the Pro version in order to have the capability to change the Editor view of the dashboard. The list should be downloadable through a dashboard function. Either using a plugin or creating a simple plugin. 1) 'All Members' List - If the registered member is in one of the “Membership Groups” (ie. Family Membership, Masters Membership, Alumni or Associate Membership, or Staff and Coaches Membership, Honorary Membership) then they will be included in this list, along with all family members in their family group. If they are not in any of the “Membership Groups” listed above, they should not be included in this list. Families will be grouped based on their “Family Group” and list the “Membership Group” holder first and list all other family members below them. If nobody in the family is in a “Membership Group” then nobody in the family shall be listed. Sample Fields to include: Family User Group Name (eg. #729 - Swaffield) Username (eg. Swaffield) Name (eg. Mary Swaffield) User Email (eg. ) DOB (eg. 4/18/1983) Gender (eg. female) 2) "Team" Lists - A list for each of the Programs (Core and Extended groups listed together). Find all users in any of the Team Groups (FIS Core, FIS Extended, Masters Team, Masters National Points List Registration, Ski X Core, U12, U14 Core, U14 Extended, U16 Core, U16 Extended, U18). The lists are as follows: FIS Core and FIS Extended Masters Team and Masters National Points List Registration U12 U14 Core and U14 Extended U16 Core and U16 Extended U18 Sample Fields to include: Family User Group Name (eg. #729 - Swaffield) Name (eg. Laura Swaffield) User Email (eg. whistlermsc+) DOB (eg. 2/2/1998) Gender (eg. female) Father’s Name (eg. Steve Swaffield) Father’s Email (eg. ) Mother’s Name (eg. Mary Swaffield) Mother’s Email (eg. ) Program Name (eg. U16 Extended)