Explain Students’ Course access sources - Creatora

{
  courseById(courseId: "22222222-2222-4222-8222-222222222222") {
    id name
    aggregatedStats { studentsOwningCourse {
      id fullName email
      coursesOwned {
        id ownershipGrantSources {
          sourceName grantedOn
          offerAcquisition {
            source acquiredOn offerSnapshot { name }
            order { id status amountNetCharge }
          }
        }
      }
    } }
  }
}

{
  "data": {
    "courseById": {
      "id": "22222222-2222-4222-8222-222222222222",
      "name": "Drawing Essentials",
      "aggregatedStats": {
        "studentsOwningCourse": [
          {
            "id": "33333333-3333-4333-8333-333333333333",
            "fullName": "Jamie Smith",
            "email": "student@example.com",
            "coursesOwned": [
              {
                "id": "22222222-2222-4222-8222-222222222222",
                "ownershipGrantSources": [
                  {
                    "sourceName": "administrator",
                    "grantedOn": 1788220800000,
                    "offerAcquisition": null
                  }
                ]
              }
            ]
          }
        ]
      }
    }
  }
}

{
  courseById(courseId: "22222222-2222-4222-8222-222222222222") {
    id name
    aggregatedStats { studentsOwningCourse {
      id fullName email
      coursesOwned {
        id ownershipGrantSources {
          sourceName grantedOn
          offerAcquisition {
            source acquiredOn offerSnapshot { name }
            order { id status amountNetCharge }
          }
        }
      }
    } }
  }
}

{
  "data": {
    "courseById": {
      "id": "22222222-2222-4222-8222-222222222222",
      "name": "Drawing Essentials",
      "aggregatedStats": {
        "studentsOwningCourse": [
          {
            "id": "33333333-3333-4333-8333-333333333333",
            "fullName": "Jamie Smith",
            "email": "student@example.com",
            "coursesOwned": [
              {
                "id": "22222222-2222-4222-8222-222222222222",
                "ownershipGrantSources": [
                  {
                    "sourceName": "administrator",
                    "grantedOn": 1788220800000,
                    "offerAcquisition": null
                  }
                ]
              }
            ]
          }
        ]
      }
    }
  }
}

Explain why each current Student has access to a Course. This helps distinguish free acquisitions and direct grants from paid purchases.

Request

{
  courseById(courseId: "22222222-2222-4222-8222-222222222222") {
    id name
    aggregatedStats { studentsOwningCourse {
      id fullName email
      coursesOwned {
        id ownershipGrantSources {
          sourceName grantedOn
          offerAcquisition {
            source acquiredOn offerSnapshot { name }
            order { id status amountNetCharge }
          }
        }
      }
    } }
  }
}

{
  "data": {
    "courseById": {
      "id": "22222222-2222-4222-8222-222222222222",
      "name": "Drawing Essentials",
      "aggregatedStats": {
        "studentsOwningCourse": [
          {
            "id": "33333333-3333-4333-8333-333333333333",
            "fullName": "Jamie Smith",
            "email": "student@example.com",
            "coursesOwned": [
              {
                "id": "22222222-2222-4222-8222-222222222222",
                "ownershipGrantSources": [
                  {
                    "sourceName": "administrator",
                    "grantedOn": 1788220800000,
                    "offerAcquisition": null
                  }
                ]
              }
            ]
          }
        ]
      }
    }
  }
}

Use the result

const course = response.data.courseById;
const rows = course.aggregatedStats.studentsOwningCourse.map(student => ({
  studentId: student.id, email: student.email,
  sources: (student.coursesOwned.find(item => item.id === course.id)?.ownershipGrantSources ?? []).map(grant => ({
    source: grant.sourceName, grantedOn: grant.grantedOn,
    acquisitionSource: grant.offerAcquisition?.source ?? null,
    offer: grant.offerAcquisition?.offerSnapshot.name ?? null,
    orderId: grant.offerAcquisition?.order?.id ?? null,
    orderStatus: grant.offerAcquisition?.order?.status ?? null,
    amountCharged: grant.offerAcquisition?.order?.amountNetCharge ?? null
  }))
}));

One Student may have several access sources. Free claims and direct grants can provide access without an Order. The report shows current grants; a full access history also needs records of removed grants.