--- title: "Querying Gifts Associated With Pledges for Advancement" slug: "associating-gifts-to-pledges" updated: 2026-07-16T23:30:37Z published: 2026-07-16T23:30:37Z canonical: "knowledge.technolutions.net/associating-gifts-to-pledges" --- > ## 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. # Associating Gifts to Pledges for Advancement When a gift is applied towards a particular pledge, the gift inherits the unique ID (called the GUID) of the pledge. Slate stores this unique ID in a field on the gift table called Parent GUID. This association allows two primary conclusions to be drawn: - Gifts with a value in the Parent GUID field are gifts that have been made in fulfillment of a pledge - Slate knows which gifts are specifically associated with any given pledge Utilizing this knowledge and the one-to-one join of **Received to Pledged**, a query can be created to return one row per gift that is associated with a pledge and the details of the original pledge will be listed as exports. ## Querying on gifts with pledges While this type of querying can occur from the Person base, it is better demonstrated by starting with the Gift configurable joins base. To start: 1. Click **Queries / Reports** in the top navigation bar. Click New Query and enter the following in the popup: - **Name** - Provide a name for the query, such as "Associating Gifts to Pledges" - **Type** - Select "Configurable Joins" - **Category** - Select "Related" - **Base** - Select "Gift." This will return one row per gift in the query. 2. Add a base join to **Person**. Once added, add a few person exports to identify to whom each gift is associated. Add any other person-scoped filters as desired. In this example, the results have been limited to the gifts of Alexander Hamilton. 3. Add several **Gift Exports**, such as the date, amount, and status category of each gift. Add format masks, as necessary. [![Associating_Gifts_to_Pledges_-_Setup.PNG](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044419532.png?sv=2026-02-06&spr=https&st=2026-10-12T12%3A12%3A43Z&se=2026-10-12T13%3A12%3A43Z&sr=c&sp=r&sig=%2B2vlvD38rMUurfOPKKCc6KMbaRbtrAC%2FVBedTLTKhsU%3D)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044419532.png?sv=2026-02-06&spr=https&st=2026-10-12T12%3A12%3A43Z&se=2026-10-12T13%3A12%3A43Z&sr=c&sp=r&sig=%2B2vlvD38rMUurfOPKKCc6KMbaRbtrAC%2FVBedTLTKhsU%3D) 4. Add the following **Filters** to return only those gifts that have been received and are associated with a pledge: - **Status Category** - IN Received - **Subquery Filter** - **Name** - Name the filter something descriptive, such as "Associated with a Pledge" - **Aggregate** - Exists - **Exports** - Add the "Parent GUID" export. [![Associating_Gifts_to_Pledges_-_Subquery_Filter.PNG](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044499251.png?sv=2026-02-06&spr=https&st=2026-10-12T12%3A12%3A43Z&se=2026-10-12T13%3A12%3A43Z&sr=c&sp=r&sig=%2B2vlvD38rMUurfOPKKCc6KMbaRbtrAC%2FVBedTLTKhsU%3D)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044499251.png?sv=2026-02-06&spr=https&st=2026-10-12T12%3A12%3A43Z&se=2026-10-12T13%3A12%3A43Z&sr=c&sp=r&sig=%2B2vlvD38rMUurfOPKKCc6KMbaRbtrAC%2FVBedTLTKhsU%3D) The total number of rows being returned in the query should now be equal to the number of gifts that have been received and have been applied towards a pledge. 5. To return details on the original pledge, a new join must be added. Because each received gift can only ever be associated with one pledge, a one-to-one join can be added that connects each received gift to the correct pledge. **Add** the **Received to Pledged** join off of the gift base. [![Associating_Gifts_to_Pledges_-_Join.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044420572.png?sv=2026-02-06&spr=https&st=2026-10-12T12%3A12%3A43Z&se=2026-10-12T13%3A12%3A43Z&sr=c&sp=r&sig=%2B2vlvD38rMUurfOPKKCc6KMbaRbtrAC%2FVBedTLTKhsU%3D)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044420572.png?sv=2026-02-06&spr=https&st=2026-10-12T12%3A12%3A43Z&se=2026-10-12T13%3A12%3A43Z&sr=c&sp=r&sig=%2B2vlvD38rMUurfOPKKCc6KMbaRbtrAC%2FVBedTLTKhsU%3D) 6. Once the join has been added, click **Export** to return the details of the originating pledge, such as the pledge date and amount pledged. Format the exports, as desired. [![Associating_Gifts_to_Pledges_-_Exports.PNG](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044500511.png?sv=2026-02-06&spr=https&st=2026-10-12T12%3A12%3A43Z&se=2026-10-12T13%3A12%3A43Z&sr=c&sp=r&sig=%2B2vlvD38rMUurfOPKKCc6KMbaRbtrAC%2FVBedTLTKhsU%3D)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044500511.png?sv=2026-02-06&spr=https&st=2026-10-12T12%3A12%3A43Z&se=2026-10-12T13%3A12%3A43Z&sr=c&sp=r&sig=%2B2vlvD38rMUurfOPKKCc6KMbaRbtrAC%2FVBedTLTKhsU%3D) The final output should resemble the following, with the details of the received gift alongside the original details of the pledge: [![Associating_Gifts_to_Pledges_-_Output.PNG](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044500491.png?sv=2026-02-06&spr=https&st=2026-10-12T12%3A12%3A43Z&se=2026-10-12T13%3A12%3A43Z&sr=c&sp=r&sig=%2B2vlvD38rMUurfOPKKCc6KMbaRbtrAC%2FVBedTLTKhsU%3D)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/360044500491.png?sv=2026-02-06&spr=https&st=2026-10-12T12%3A12%3A43Z&se=2026-10-12T13%3A12%3A43Z&sr=c&sp=r&sig=%2B2vlvD38rMUurfOPKKCc6KMbaRbtrAC%2FVBedTLTKhsU%3D)