Query

Tip: Don't see this yet? No need to worry. Expect its wider release in a future update.

Note: Query is a work in progress as we move features from database view to web view. To track details and features, review Query in Web View.

Use Query to search for records that meet certain criteria. For example, you can use a query to find all constituents in your organization who are board members.

While most of your queries are visible in web view, you may not be able to view, edit, or run a query if you don’t have permission to view them or support for the query is coming in a future release.

Note: Some queries don't support View, Edit, or Run and are only visible in the list of queries. Others, such as query lists and Giving Score queries, will not be available in web view.

To access the list of queries, go to Analysis, Query. To change the column headers, select what to include, and choose Apply changes. You can also reorder the columns in the list by dragging and dropping the column headers.

To quickly locate the query you want by name, use search. You can also select to filter queries by category, type, or format or view only merged queries or queries you created .

  1. From the list of queries, select New query.

  2. Under Query type, select the types of fields and records to include in your query. For more information, see Type.

  3. Under Query format, select to create a static or dynamic query to determine which records are included when you run your query. For more information, see Format.

  4. Select OK.

  5. In the query editor, select criteria fields, operators, and the sort order of your query’s output fields to customize your query. For more information, see Query Editor.

  6. Select Save or Save and close.

  7. Enter a query name and description, make changes to the query format or category, and select to allow others to run or modify the query.

  8. Select Save.

To add or remove records from one query to another, you can merge queries into a third static query.

  1. From the list of queries, select New merge query.

  2. Under Query 1 and Query 2, search for and select a primary and secondary query to merge.

  3. Select merge operators to determine how to combine them. For more information, see Merge Operators.

  4. Select OK.

If you have rights to edit a query, Edit is available in the query menu, and you can select its name from the list of queries to open the query editor.

For more information, see Query Editor.

If Run is available from the query menu, you can select it to open the Results tab of the query editor. This allows you to run the query, but you won't be able to view other details.

Note: For queries that support Run, you can also select to export query results to a CSV file.

If you have rights to export query results to a CSV file, select Export from the query menu.

For more information, see Query Security.

To delete a query, select Delete from the query menu.

Query categories help organize queries you create. For example, queries can be grouped by user or by how you intend to use the query.

To assign a category to a query, from the query’s menu, select Edit category.

To manage query categories, select Edit categories from the list of queries. Select New category to create a new category or select the arrow next to the query and drag and drop categories to reorganize how they appear in the Category drop down list.

Tip: You can select a category from the Category drop down list to filter the list of queries to only queries in that category.

To rename or delete a query category, select the category’s menu.

Each query has a query type, and the fields and records included in the query are only those related to that record type. Raiser’s Edge NXT currently supports the following query types:

  • Action

  • Appeal

  • Campaign

  • Constituent

  • Event

  • Fund

  • Gift

  • Individual

  • Job

  • Membership

  • Organization

  • Participant

  • Relationship

Query format determines the records included when you run the query:

  • Static queries – A “snapshot” of your records when the query is run. When you save a static query, it searches and returns records that match the specified criteria. Any records added or updated after you created the static query are not included.

  • Dynamic queries – The query automatically refreshes each time you run it. This is helpful if you routinely run queries to view the latest results.

To filter the list of queries to your favorites, select Favorites only.

Tip: To manage your favorite queries, select Add to Favorites or Remove from Favorites from the query’s menu.

To filter the list of queries to the most recently accessed queries, select Recent queries only.

Note: When you filter to only recent queries, only the 20 most recently accessed queries appear in the list. All other query list filters are disabled.