Joins
If you're in an Application based query and need to insert someone's name, this join will get you there
Join to Person
These 2 query bases are the most common starting points for queries
Application and Person
What is the name of the "Output" function that combines different exports together in a Subquery Export?
Concatenate
This is section of the filter tool is where you can find pre-made Filters that will add multiple parts to your query at once
Library Filters
Forms, Events, and all Templates are found inside of this Join. It's available from both Person and Application
Form Response
This query base category contains bases like Messages, Inbox, and Interactions
Related
Send the web page that Slate hosts that explains what Ranks are and how they are calculated
Database Structure and Determination of Table Ranks
True or False!
When a filter for a field is set to "IN", it is the same as making a subquery filter that says "Exists"
True!
You're building an Application based query and have been asked to remove any People who applied in Fall 2025. Build the filter that will remove those people from your query.
HINT: This requires 2 joins
Use Example Query! (https://gradase.admissions.tufts.edu/manage/query/build?id=b3ee8801-187e-4460-8e9b-576dccf29381)
In a subquery filter, Application -> Person -> Applications.
Then, you can do "Exists" or "Not Exists" with filters.
Start a query that will only show people registered for the Graduate Application 101 event on July 21.
HINT: There is a button in Slate that will build this query for you in one click!
Form Response Base; OR New Query from the event
Build a subquery export that exports "Yes" when an Application has an Application Term of Fall 2026
Subquery Export set to "Existence"
"Value if Exists" = Yes
Filter on Application Term
Build a subquery filter that will include records who are missing a certain field.
Said a different way: find records for which a certain field (any field!) does NOT exist.
When a subquery filter is set to Does Not Exist, you can add any Export to it to check.