Home > Dashboard Panels > Contact Query

Contact Query

The Contact Advanced Query panel (for ACT!2010 and later) reports on all Contact Records in the ACT! database using advanced querying.  This panel offers pre-built queries to aid in the creation of exception reports.  Leave the query blank to return ALL records.  The Contact Advanced Query filter displays the Dash Advanced Query Designer:

Pre-Built Queries:
Contacts:  Returns all Contact Records which match the query.

Contacts with Custom Tables: Returns all Contact Records which have associated Custom Table Records matching the query.  Query can contain both Contact and Custom Table fields.

Contacts with Histories: Returns all Contact Records which have associated History Records matching the query.  Query can contain both Contact and History fields.

Contacts with Notes: Returns all Contact Records which have associated Note Records matching the query.  Query can contain both Contact and Note fields.

Contacts with Opportunities: Returns all Contact Records which have associated Opportunity Records matching the query. Query can contain both Contact and Opportunity fields.

Groups without Custom Tables: Returns all Contact Records which do not have any associated Custom Table Records matching the query.  Query can only Contacts Custom Table fields.

Contacts without Histories: Returns all Contact Records which do not have any associated History Records matching the query.  Query can only contain History fields.

Contacts without Notes: Returns all Contact Records which do not have any associated Note Records matching the query.  Query can only contain Note fields.

Contacts without Opportunities: Returns all Contact Records which do not have any associated Opportunity Records matching the query.    Query can only contain Opportunity fields.

The Contact Query Panel will show the fields for each Contact only

See also