Basic Query Help

The basic query is meant for quick and simple queries. They will give results for just a single race in a single year similar to what you get from the recent results section.

• First, you select the year of interest.
• With a year selected, the race dropdown will populate with all the races for that year. Select the race you're interested in.
• With a race selected, you will then see one or more events that are selected by default. Most races have only a single event so you will just see the event distance (or time for a fixed time event). Some races will have multiple events, such as different distances to run (eg, Airport Run) or different time durations to run (eg, Alaska Endurance Trail Run).
• You can also select a division, which denotes an age/gender combination. Be aware that many races do not include age and gender information so it might not be practical except for the larger events timed with Chronotrack such as Midnight Sun Run or Equinox Marathon.
• If you are looking for results for a particular person, you can enter a partial or full name for that runner. The search box is case insensitive so you don't need to worry about capitalization. If you enter a single name or partial name, it will search for that string of letters anywhere in the name. For example, you could enter david and it would find all runners with a first name of David. It will also match runners with a last name of Davids or Davidson, but it will not match anyone who registered with the name Dave. You can a full or partial last name to refine your search. And order does not matter, so you could enter something like smith david. If this person sometimes registers as David and other times as Dave, then you might try just the letters in common by entering smith dav. The dav you entered will match both Dave and David.
• You can then do another query by selecting a different year and/or race. If you select a different year and the previously selected race was run in that year, then it will remain selected so you can quickly check results for the same race in multiple years. If the race was not run in the newly selected year, then the dropdown will be reset and you will need to select another race.

Advanced Query Help

The advanced query lets you create very simple or complicated queries. Several more fields are accessible allowing you to build the query you need where you can include or exclude matches or search over a range of years.

• The query is based on an underlying hierarchy where you create a filter on one field and that will limit the available options for fields lower in the hierarchy. For example, once you create a filter for a particular year, that will limit the races you can select to those races that were run in that year.
• You can create a query on any field by selecting a condition (eg, equal to, not equal to) and a value for the field. For example, you can select a single year by creating a query where year = 2025.
• Once you've selected the condition and value, you must click the + Action button to add it to your query. This will create a new row that contains the filter you just created along with a - Action button you can use to delete that filter if you decide it is no longer needed.
• When you add the filter to your query, the dropdowns you used to create the queries will be reset so you can add more filters to the same field if needed. If you do, then you have to select a field operator to combine them. The operator with be either OR or AND.
• Here is an example of multiple filters on a field. You might want to select a range of years. One way to do this would be to add each year separately with a field operator of OR such as year = 2025 OR year = 2024 OR year = 2023. You create a filter for each year separately and set the field operator to OR when you create the second filter. Note that if you used AND, no years would match and your query would return no matches.
• Another way to build the same query is to define a range of years. Consider year >= 2023 AND year <= 2025. Note that in this case, if you used OR as the field operator, then all years would match and you would not have filtered the results at all.
• Continue to build the query to get what you want. Be sure to click the + Action button after each filter to add it to your query.
• If you go back and change any filter higher in the hierarchy, existing filters may remain or they might be deleted, depending on whether the value selected is still and option. For example, you could select a year and a race and then go back and change that year. If the selected race was run in the newly selected year, then that filter will remain. However, if it wasn't, then it will be deleted and you can select another race.
• You also have the option to add filters for division or runner name as described in the basic query help.
• Click the submit button when you're ready to run your query. If the results are not what you expected, look over your individual filters and make sure they are doing what you intended. Be sure to check that you clicked the + Action button to add each filter.
• If you wish to run another query, you can modify the filters you have already created or click the reset button to start over.

Datatables Help

Race results are displayed using Datatables. More than just a table, it gives you added functionality to get what you need from the data. You can search the displayed results without having to run another query. You can sort by one or more columns. You can view or hide columns. You can print or export your query results.

Searching:

• You will find a search box at the top right of the table when displaying data. You can enter what you are looking for and Datatables will filter the displayed results as you type.
• It will search all columns in the table so you might end up with more records showing than you want so try to be as specific as possible with your search string.
• The search is case-insensitive so you don't need to worry about upper and lower case characters.
• You can enter partial words or names. If you're looking for a particular runner, you could start typing the first or last name until you see the person you want.
• If you enter multiple words or partial words separated by spaces, it will search for records containing each item, but not necessarily together. For example, you can enter a person's last name and if there are still too many records, you can add a space and then start typing the first name.
• If you want an exact match including spaces, enter your search term with double quotes around it. An example might be if you ran a query for all Equinox Marathon Relay results and then want to see just the results from Leg 3. If you simply enter Leg 3, then it will match records that include Leg in any column and a 3 in any column. For this you should enter "Leg 3" and it will display just those results.

Viewing/Hiding Columns:

• Some columns are initially hidden by default. For example, many races do not have an age or gender available for each person so those columns are hidden by default.
• Above and to the left of the table you'll find a button for Column visibility. Click that to get a list of all available columns. The currently visible column are identified by shaded buttons and the hidden columns are not shaded.
• Click any column button to toggle between visible and hidden.

Sorting:

• When you submit a query, the default sorting is first by event and then by either the event time or distance.
• To sort by any column, click on any column header. The column will initially be sorted ascending. To sort it descending, click the header again.
• You can also sort by multiple columns. Click the column you want to sort by first, and then hold down the shift key while you click additional columns to sort by second, third, etc. Consider the Equinox Relay again. If you wanted to sort by age within each leg, you would first display the Age column, then click on the Event header to sort by leg, and lastly hold down the shift key while clicking the Age header. While still holding down the shift key, you could then click the Age header again to sort from oldest to youngest.

Printing/Exporting:

• Copy: Click to copy a tab-separated version to your clipboard that contains all columns, even the hidden ones. You can then paste it directly into a spreadsheet, text editor, email, etc.
• CSV: Click to export the results to a CSV (comma separated values) file that you can save to your computer. This can be opened in any spreadsheet or text editor.
• Excel: Click to export the results to a MS Excel .xlsx file on your computer. This can obviously be opened in Excel, but most spreadsheets will also open it.
• PDF: Click to export the results to a PDF file on your computer. This works well if you prefer a version that can't be edited.
• Print: Click to open a print dialog to print a hard copy of the results.