Skip to main content

How do I view the results of the query?

Describes how to view results of a report query and details what actions can be done on this data.

You will need the Reporting permission to run a query. What the results include also depends on the read permission for what the query reads: Limited Read People for people, Full Read Groups for groups, and Full Read Contributions for giving.

Once the filters and columns are set, run the query by clicking the blue Run Query button. The results appear in a table below that button.

Query results in a table below the Run Query button.

To export the results to CSV, click the Export All Results button as shown above, or select Export from the Actions menu.

The Export All Results button and the Actions menu above the query results.

Tip: When a report was built with the AI Assistant, there is no Run Query button. The results run automatically as soon as the report arrives and after every refinement. Use Refresh to run it again and Export All Results to download every row. Row clicks and drilldowns are turned off in AI mode, and Generate report is not offered in the bulk actions. When you select rows for a bulk action, the confirmation count is the number of distinct people, which can be smaller than the number of rows. How do I build a report with the AI Assistant? explains more.


Why two people can see different results

The results only include records you're allowed to see. Your access and your campus selector are applied outside your filters, so no filter can lift a row past them.

  • People queries - include people you can see with Limited Read People, narrowed by your campus selector.

  • Groups queries - include groups you can see with Full Read Groups, narrowed by your campus selector.

  • Contributions queries - include gifts at campuses where you hold Full Read Contributions, narrowed by your campus selector. This is checked line by line, so a gift split across campuses shows only the lines you can see.

For example, a query for people who are members or who gave last month can't bring back a person at a campus you can't see, even though the "or" would otherwise match them. That is why a colleague with wider access can get 400 rows from the same saved query while you get 230. Neither result is wrong.

  • If a saved query uses a permission you don't have, you get the query with those statements removed, and the missing permissions are listed.

  • A shared query that names a campus outside your access doesn't widen what you see, and no error is shown.

What is the campus selector? explains how the selector narrows lists.

The Organization column

If your account has two or more organizations, queries offer an Organization filter and column.

  • The column shows only organizations you can reach. A record whose organizations are all outside your access shows a blank. A record available to All shows All Organizations.

  • A person or group belongs to the organizations of its campuses. If it has no campuses, it belongs to the organizations it is assigned to, and if it has neither, it belongs to all of them. A gift always belongs to exactly one organization.

How does a record get a campus or an organization? explains how records get their campuses and organizations.


Actions

The Actions menu contains actions on the resulting data. These articles explain each one:

If your account keeps separate giving for each organization and your query is tied to one organization, actions run from its results, such as mass changes, mail merge, giving statements and labels, keep that organization.


Resetting

Click the Clear all filters button to reset filters and construct a new query. The default query is shown below, the same view you see when you first visit the Query Builder.

The Query Builder after Clear all filters, showing the default query.
Did this answer your question?