Single-row query combines query criteria, output fields, filtering, and export workflows in one place, with faster processing and more flexible filtering.
If you use database view Export to create lists with one row per record, you can now build the same type of results in web view Query.
Learn how single-row result layouts work, how single-row query compares with Export, and what’s coming next.
Discover the Flexibility of Single-Row Query
Single-row query introduces a new concept in web view Query: the result layout. The result layout controls how Query arranges your results. When you create a query, choose one of two layouts:
- Single-row: Returns one unique row per record. Related data, such as gifts, addresses, or constituent codes, appears in columns on that row. This layout matches the one-row-per-record layout in database view Export.
- Multi-row: Returns one row for each related item. For example, a constituent with three gifts appears on three rows. This is the existing Query result layout.
Choose the layout based on how you plan to use your results:
- Use single-row when you need one row per record, such as for a mailing, a data file for a vendor, or a workflow you previously completed with Export.
- Use multi-row when you need each related item on a separate row as you do in Query today.
The result layout stays with the query after you create it. To use the same criteria with another layout, open the query, select Save as, and choose the other layout.
Explore the Benefits of Single-Row Query
- Keep query and export work in one place. Build, review, adjust, and export your list in web view without switching to database view or moving between Query and Export.
- Refine results with more flexible filtering. Filter and sort by fields under a node instead of using the smaller set of filters available in Export.
- Work directly with your results. Open records from the results, use the query in query merges, and create control reports just as you do with queries today.
- Process results faster. Single-row queries process faster than database view Export.
Understand How Single-Row Query Differs from Export
If you use Export in database view, you’re familiar with creating lists that contain one row per record. While single-row query provides that result structure through Query, some workflows and settings differ:
- It’s a query. Set criteria, choose a static or dynamic format, use the query in query merges and other functions, and open records directly from the results.
- Filtering works differently. In a single-row query, you can filter and sort by fields under a node or combine fields to refine results. You can also use the Active Dates filter and the In query results of operator.
- Some settings have different locations or names.
- Head of household is under Options in a single-row query. In Export, it’s under General.
- Select from query performs the same function as Include under General in Export.
- Renaming works the same way. As in Export, you can rename individual columns or a node and apply the new name to its related fields.
- The available fields differ. Some fields are available in only one database-view experience. Most Export fields are available in both result layouts of web view Query.
Frequently Asked Questions
Do I have to rebuild my exports?
No. We’re building an Export migration tool that will recreate database view exports as single-row queries later this year. Migrated exports will retain their categories. For example, exports in General will move to the General category in Query.
How do I base an export on an existing query?
In Export, you search for the starting query with Include. When you create a single-row query, search for the starting query with Select from query. You can then change this on the Options tab if you need to start from a different query.
Can I use one query as the starting point for several exports?
Yes. Multiple single-row queries can use the same query with Select from query, and each can contain its own output fields and filters.
Can I turn an existing query into a single-row query?
Yes. Open the query, select Save as, and choose the single-row layout. Your criteria carry over. Output fields do not, because output field filtering works differently between the two layouts.
Can I still use database view Export?
Yes. Export remains available in database view until September 2027, so you can move your workflows to single-row query at your own pace.
Get Started with Single-Row Query
When single-row query becomes available in your environment, Query is renamed Query and export. In web view, go to Analysis, Query and export. From there, you can filter and organize the query list by Result layout and choose a result layout when you create a query.
Single-row queries are available only in web view.
Learn More