Query Design and Results

Criteria applied to fields in a query are usually joined by the “And” conjunction by default, so each criterion that is applied will necessarily narrow the search results.

Axiom features a number of style and display options accessible in the rightmost column of the query design.

Axiom offers a number of advanced query options.

When a school needs to enter or create multiple records at the same time, this can be accomplished using the “Batch Add” queries on the System homepage in Axiom.

You can upload files in batch — using .zip files — to person, household, and organization records in Axiom via three links in the “Batch Add” section of the System homepage.

Here is the new version of this article in the Veracross Community. Overview Use the "batch update" feature to update multiple records at once in a query result.  Batch update records with caution; there is no "undo" o...

Here is the new version of this article in the Veracross Community. Overview A query is a structured question used to retrieve data, or records, from tables. A record can be a person, a household, a class, etc. Queries can be built in Axiom t...

After a query is run, you are able to copy and paste cells directly from the results page to any other program that uses text fields.

Here is the new version of this article in the Veracross Community. Overview Axiom features a number of style and display options accessible in the rightmost column of the query design. Field Style Changing Column Background Color The back...

Here is the new version of this article in the Veracross Community. Overview Query results visualized as a data grid can be exported from either the design or results screen as an Excel or CSV file. To do this, select “Export” fro...

Function fields provide a way for Axiom users to display customizable aggregate data. Conceptually, they are similar to calculated fields, though with the added ability to change the input of the calculation directly in the field's parameters.

Here is the new version of this article in the Veracross Community. Overview Click the right side of the column header to access the Grid Column Menu. The Grid Column Menu allows you to access query design features directly from the qu...

A modified query can be saved to allow the school to regularly access the query without the need to readjust the fields, criteria, and other settings each time

Here is the new version of this article in the Veracross Community. Overview Printing query results or records in Axiom is available from the Action menu option, under the “Print to PDF” section. There are three contexts in which...

The following example illustrates the process of printing name tags while starting from a group record.

Query properties are settings that allow the user to customize how results are shown.

Here is the new version of this article in the Veracross Community. Overview Once you have produced the desired results within the query, there are several actions you can take. Select them by clicking the Action Menu . Different options are av...

Here is the new version of this article in the Veracross Community. Overview A query is a structured question used to retrieve information from data in Veracross. It can be modified and filtered as necessary to produce a specific set of results....

Here is the new version of this article in the Veracross Community. Overview The Query Results Page Toolbar — located directly above the results grid on the query results page — has two features: an Add Record...  button and a...

Here is the new version of this article in the Veracross Community. Saving a Query Once a query has been modified, it is possible to save the query for future use. Saving a query allows the user to choose a name for the saved query, choose the W...

This article lists the available parameters that can be used when creating a query.

Here is the new version of this article in the Veracross Community. You can adjust the field properties and style of a column directly from the query results page by performing the following steps: Click on the Grid Column menu for the column y...