How to use the Contacts Custom Query Builder?

How to use the Contacts Custom Query Builder?

In the Contacts Module, a Custom Query Builder is available to allow you to build your own report based on fields specifically linked to a contact that appear on the contact profile form or linked to groups and/or member dues (NOTE: available for those using X-CD to manage groups and member dues).

How to use the Contacts Module Custom Query

  1. Click Dashboard
  2. Click Contacts from left-side menu
  3. Click Download button from Contact Modules on top

  5. Click Custom tab
  6. In the drop down list, select an appropriate field, the criteria, and the value.
  7. If you want to add another field criteria select the AND/OR and click the + Add Filter button
  8. In the drop down list, select an appropriate field, the criteria, and the value.
  9. After all of your criteria have been added, click Run Query button
  10. Click Continue button
  11. Click the appropriate action button you wish to use e.g. Send Email or Download to Excel


How to get a list of contacts who selected the Do Not Contact field?

NOTE: This is applicable, if you have a 'Do Not Contact' field defined on your contacts form.

  1. Click Dashboard
  2. Click Contacts from left-side menu
  3. Click Download button
  4. Click Custom tab
  5. In the drop down list, select Do Not Contact field, select criteria 'Is', select value 'Yes'
  6. Click Run Query button
  7. Click Continue button
  8. Click the appropriate action button you wish to use e.g. Send Email or Download to Excel

How to get a list of contacts who are not members?

NOTE: This is applicable, if you are using X-CD to manage your membership.

  1. Click Dashboard
  2. Click Contacts from left-side menu
  3. Click Download button
  4. Click Custom tab
  5. In the drop down list, select User Groups field, select criteria 'Not In', select all values listed for Member groups (Hold down the CTRL or COMMAND button, click the first and then click the last value), ensure the OR option is clicked
  6. Click Run Query button
  7. Click Continue button
  8. Click the appropriate action button you wish to use e.g. Send Email or Download to Excel

    • Related Articles

    • How to Download the list of Contacts?

      There are two (2) different methods for downloading a list of Contacts. 1. You may use the Reports section or 2. use the Manage screen filters. Downloading Contacts from the Report section From Admin Dashboard Click Contacts from left-side menu Click ...

    • How to add a contact to the Do Not Contact Me (unsubscribe) list?

      The Do Not Contact Me list will remove an individual from receiving general broadcast type emails sent through the X-CD system by an administrator. If enabled, it gives the user a quick way to 'unsubscribe from all emails' -- as it relates to ...

    • I have duplicate contacts. How do I Merge Contacts?

      NOTE: This will move all items (e.g. author, abstract, review, registrations, member dues, groups, etc.) over to the master contact profile and then delete the duplicate contact profile in the Contacts Module. The information in the Master Contact ...

    • How to Find Duplicate Contacts?

      The Duplicate Contact Search feature will search the contact module and flag any contacts that need to be reviewed as potential duplicates. The search will first match on where the combination of the first and last name are the same and then secondly ...

    • Managing Member Dues Categories

      Create a Member Dues Category Click Dashboard Click Dues Management in left side menu Select Dues Categories in horizontal menu Select Create New Dues Enter a Dues Category Name e.g. Professional Member Select from the dropdown the corresponding ...