---
title: "Querying for Athletic Recruits"
slug: "querying-for-athletic-recruits"
status: "new"
updated: 2026-06-18T22:08:21Z
published: 2026-06-18T22:08:21Z
canonical: "knowledge.technolutions.net/querying-for-athletic-recruits"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://knowledge.technolutions.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Querying for Athletic Recruits

You can query for athletic recruits to give admissions and coaching staff a shared view of recruited students, where they are from, their application status, and athletic feedback. Use this approach to monitor recruited applicants, coordinate follow-up, and review sport-specific recruitment activity.

#### Try a Slate example 💼

Copy this [Suitcase](/docs/suitcase-import) ID and paste it in **Database → Suitcase Import** to import a pre-made example query:

```SuitcaseID
fb2758f3-c0fb-4568-a6f7-5939c0e3cbfe:slate-admissions-showcase
```

> [!NOTE]
> 💡 Tip
> 
> Find this query and other importable examples in the [Admissions Showcase environment](/v1/docs/showcase-environments).

## Reviewing athletic recruits

Use the **Person** base so each row represents one person record. Add joins to make address, application, school, and sport information available, then filter by sport so the results include only recruited students with athletic information on their records.

The resulting list can help coaching staff review their recruits while giving admissions staff visibility into application status, territory, school, sport, position, rating, and notes.

![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Querying for Athletic Recruits.png)

## Building the query

### Create the query

1. Go to **Queries / Reports**.
2. Select **New Query**.
3. Configure the following settings:
  - **Name:** Athletic Recruitment
  - **Folder:** Admissions / Recruitment
  - **Type:** Configurable Joins
  - **Base:** Person
4. Select **Save**.

### Add joins

Create joins for the related records that provide location, application, school, and athletic recruitment details.

1. Select **Join**.
2. Create a join to **Address by Rank Overall**.
  - **Rank:** 1
  - **Name:** Address 1
3. Select **Join**.
4. Create a join to **Application by Rank**.
  - **Rank:** 1
  - **Name:** Application 1
5. Select **Join**.
6. Create a join to **School by Level of Study, Rank**.
  - **Level of Study:** No Level of Study
  - **Rank:** 1
7. Select **Join**.
8. Create a join to **Schools**.
9. Select **Join**.
10. Create a join to **Sport**.
  - **Rank:** 1
  - **Name:** Sport 1

### Add the sport filter

The sport filter determines which recruited students appear in the results. Include the sports that your staff wants to monitor.

1. Select **Filter**.
2. Select **Sport 1 / Sport**.
3. Set the filter to include the relevant sports. The imported example includes:
  - Baseball
  - Basketball
  - Football
  - Ice Hockey
  - Lacrosse
  - Soccer
  - Softball
  - Tennis
  - Volleyball
  - Wrestling
4. Select **Save**.

### Add exports

Add exports similar to these so staff can identify each recruit and review the related application and athletic context. Export names and field labels may differ by database.

- Person Reference ID
- Person Name
- Address 1 City
- Address 1 Region
- Address 1 Country
- Address 1 Geomarket
- Person Staff Assigned
- Schools Name
- Application 1 Status
- Person Entry Term
- Application 1 Application Major
- Sport 1 Sport
- Sport 1 Position
- Sport 1 Rating
- Sport 1 Notes

## Using the query

Run the query to review recruited students by sport, location, assigned staff member, school, application status, position, rating, and notes. The results can support coordination between admissions and athletics staff without requiring each team to maintain a separate list.

## Customizing the query

- Change the sport filter to focus on one sport, one team, or a smaller group of sports.
- Add entry term, application round, or application status filters to focus on a specific recruitment cycle.
- Add exports for email, phone, territory, coach assignment, or additional sport fields if the results will support outreach.
- Adjust the sport rank if staff need to review secondary or additional athletic interests.
- Add sorts by sport, staff assigned, application status, or geomarket to make the results easier to scan.

> [!WARNING]
> 📝 Note
> 
> Test the query before using it for production communications. Sport values, ratings, and recruitment workflows can vary by database.