Skip to content

mssqlTopLevelDescendants

Paginated list of top-level Microsoft SQL hierarchy descendants: the direct children of the Microsoft SQL hierarchy root, spanning every top-level Microsoft SQL managed object type.

Arguments

Argument Type Description
first Int Returns the first n elements from the list.
after String An opaque cursor returned from a previous query's endCursor field. Pass this value verbatim to retrieve the next page of results.
last Int Returns the last n elements from the list.
before String An opaque cursor returned from a previous query's startCursor field. Pass this value verbatim to retrieve the previous page of results.
sortBy HierarchySortByField Sort hierarchy objects according to the hierarchy field.
sortOrder SortOrder Sorts the order of results.
typeFilter [HierarchyObjectTypeEnum!] Types of objects to include.
filter [Filter!] Hierarchy object filter.

Returns

MssqlTopLevelDescendantTypeConnection!

Sample

query {
  mssqlTopLevelDescendants(first: 10) {
    nodes {
      authorizedOperations
      cdmPendingObjectPauseAssignment
      id
      isReplica
      legallyHeldSnapshotCount
      name
      numWorkloadDescendants
      objectType
      replicatedObjectCount
      slaAssignment
      slaPauseStatus
    }
    pageInfo {
      hasNextPage
      endCursor
    }
  }
}
{}
{
  "data": {
    "mssqlTopLevelDescendants": {
      "nodes": [
        [
          {
            "authorizedOperations": [
              "ACCESS_CDM_CLUSTER"
            ],
            "cdmPendingObjectPauseAssignment": "NO_PENDING_PAUSE_ASSIGNMENT"
          }
        ]
      ],
      "pageInfo": {
        "endCursor": "example-string",
        "hasNextPage": true,
        "hasPreviousPage": true,
        "startCursor": "example-string"
      }
    }
  }
}