|
Content with label example in Documentation for Metrix Users and Administrators (See content from all spaces)
Related Labels:
query, zipcode, queries, sample, connections, organizations, rollup, contacts
Query Using the Rollup Function
often nice to see subtotals and totals inline with the detail data in your tables. MS SQL Server has the ability to do this, using the ROLLUP function. Here's a data sample that just counts the number of contacts in each city and state: ContactCount ...
Other labels:
query, rollup
|
Creating a Query that Displays Organizations and Primary Contacts
twostep query process. The first query selects all of the organizations with Primary contacts # Go to Queries # New Query, select Advanced # Save it with a name that is in keeping with your naming conventions (e.g. "OrgsWithPrimaryContacts") # tblContacts is already there. Press the "Add Table\" button ...
Other labels:
query, organizations, contacts
|
Querying on Connections
Querying for Connections data requires the use of an Advanced Query. The purpose of this article is to provide you with the SQL statement for creating this sort of query. If you are new to the Advanced Query Builder or querying in Metrix, we urge you to first watch the twopart ...
Other labels:
query, connections
|
Create a Query based on a Zip Code range
Create a Query based on a Zip Code range This query can be used to search for contacts within a zip code range. # Navigate to the Query Manager # Create a new Query # Select an "Advanced Query" as the type and give it a name # Copy & paste ...
Other labels:
query, zipcode
|
Helpful Example Queries
See also: Retrieve Data with Queries User's Guide#Retrieve Data with Queries Helpful Query Examples This page lists commonly used queries and will be updated periodically. See the Attachments tabs for reference documents. Microsoft references: http://office.microsoft.com/enus ...
Other labels:
queries, sample, query
|
|
|
