Aristotle Support
Sub Categories
folder Defining queries
Defining queries
folder Sub-Queries
Sub-Queries


Common Queries
All Individuals In The Database
All Individuals in the Database Query Finding all individual (no organizations) in your database       Join And Table General Field ...
07 Mar, 2010
All Non-Standard Address
All Non-Standardized Address This query will give you all address that USPS standardization has not been done or has failed.     Join And Table Addresses Field ...
07 Mar, 2010
All Organizations in the Database
All Organizations in the Database Query Finding all organizations (no individuals) in your database       Join And Table General Field ...
07 Mar, 2010
All Records In The Database
Everyone in the Database Query Finding all records in your database       Join And Table General Field Record Type ...
07 Mar, 2010
E-mail Query
E-mail Query Finding everyone in your database with a valid e-mail address.       Join And Table Email Field Email Address ...
07 Mar, 2010
Finding Pure One Party Households
Finding Pure One Party Households and Giving Them a Pure Party Code. Finding a household that belongs only to one party.Although this process is long, it only has to be done once and the records will be permanently coded.  For this example, we will be finding households that all members are...
07 Mar, 2010
Limiting a query to an Individual
Limiting a Query to Individuals Only This query piece can be added after finishing other queries to limit the results to individuals only. For instance, if we searched for records in a particular zip code and we wanted to limit those results to individuals only, we could add this query on after...
07 Mar, 2010
Records by City
Records by City All records within a particular city.   Join And Table Addresses Field City Relationship ...
07 Mar, 2010
Records by Street
Records by Street All records on a particular street.   Join And Table Addresses Field Street Name Relationship ...
07 Mar, 2010
Records by Zip Code
Records by Zip Code All records within a particular zip code or zip codes.     Join And Table Addresses Field Zip Code ...
07 Mar, 2010

← Prev Next
1 2