Query Builder
Overview
Much like Query Builder 2.0, the Systems hub utility, Query Builder, allows administrators to select lists of constituents based upon filters. There are a large number of filters to select from, including such items as Program, Interest, Special Need, GPA, Advisor, Financial Activity, Personal Attributes, Licenses, Health, and many more.
When a query is created that returns a list of users, Query Builder offers the option to email those users. Administrators can choose whether to email just the primary address on file in each user's preferred Address record or to send an email to the user's secondary email address, if the user has one, as well.
These email variables can be used to create text specific to the individual user being contacted:
• #Prefix#
• #first_name#
• #mi#
• #maiden#
• #last_name#
• #Suffix#
• #ID#
• #pin#
To view a 2022 video conference on using Query Builder and Query Builder 2, click here.