Building a Query to find New Members
Last Modified on 09/01/2025 1:44 pm AEDT
Quick Steps: Members > Query Builder > Add
One of the most useful things that our Clients have found using the Query Builder is the ability to run reports on new Members to the Organisation. This allows you to set up a Query that will help you contact or export all Members that have joined your Organisation since a certain date.
>1. Within the Management Console, select
Members from the top menu, then
Query Builder from the left menu.
2. Click
Add at the top of the page.
3. Give your new Query a name, such as New Members Report and then click
Save.
4. Click on
Build at the top of the page to being building the query.
5. Click on the
Add button at the top of the page above Member Filters.
6. Select Where as the join, and then Add Date from the dropdown menu.
7. Select the greater than (>) or greater than or equal to (≥) symbol, depending on your preferred option.
8. Finally, select the date you wish to view Members that have joined after.
9. Click
Save, then click
Test to test the query.
Note: Make sure when you use your Query after the initial build that you update the Date used to ensure you're always pulling the newest list of new members.