load(
  local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: 20,
    sort: a!sortInfo(
      field: "university_id",
      ascending: true
    )
  ),
  with(
    local!datasubset: a!queryEntity(
      entity: cons!APPLICATION_ENTITY,
      query: a!query(
        selection: a!querySelection(
          columns: {
            a!queryColumn(
              field: "status"
            ),
            a!queryColumn(
              field: "primary_major"
            ),
            a!queryColumn(
              field: "secondary_major"
            ),
            a!queryColumn(
              field: "student_id"
            ),
            a!queryColumn(
              field: "university_id"
            ),
            
          }
        ),
        pagingInfo: local!pagingInfo
      )
    ),
    local!pairs: rule!University_getUniversity(
      index(
        local!datasubset.data,
        "university_id",
        null
      )
    ),
    a!gridField(
      totalCount: local!datasubset.totalCount,
      columns: {
        a!gridTextColumn(
          label: "University",
          field: "university",
          data: apply(
            fn!displayvalue(
              _,
              local!pairs.university_id,
              local!pairs.univ_name,
              ""
            ),
            index(
              local!datasubset.data,
              "university_id",
              null
            )
          )/*data: apply(rule!University_getUniversity, index(local!datasubset.data, "university_id", null))*/
          
        ),
        a!gridTextColumn(
          label: "Student",
          field: "student",
          data: index(
            local!datasubset.data,
            "student_id",
            null
          )
        ),
        a!gridTextColumn(
          label: "Status",
          field: "status",
          data: index(
            local!datasubset.data,
            "status",
            null
          )
        ),
        a!gridTextColumn(
          label: "Primary Major",
          field: "primary_major",
          data: index(
            local!datasubset.data,
            "primary_major",
            null
          )
        ),
        a!gridTextColumn(
          label: "Secondary Major",
          field: "secondary_major",
          data: index(
            local!datasubset.data,
            "secondary_major",
            null
          )
        )
      },
      value: local!pagingInfo,
      saveInto: local!pagingInfo
    )
  )
)