[cosmos] continuation Token is not returned with an ORDER BY query node JS SDK

[adeelnaqvisystems]

• Package Name: azure/cosmos

• Package Version: 4.2.0

• Operating system: window

• nodejs: v 20.15.1

  • framework: Nest JS

• typescript

  • version: ^5.1.3

Describe the bug
Continuation tokens are undefined for ORDER BY queries. The query SELECT * FROM a returns a continuation token as expected, however SELECT * FROM a ORDER BY a._ts ASC send undefended

To Reproduce
The following node js script connects to a container and performs the simplest query with ORDER BY, if you've got more than 10 items, it'll return 10 items, but no continuation token. Remove the ORDER BY, and it works fine:

let query =SELECT * FROM students u WHERE u.type = @entityType`;

if (studentsIds && studentsIds.length > 0) {
  query += ` AND u.studentId IN (${studentIds.map((_, i) => `@studentId${i}`).join(', ')})`;
}

if (sorted) {
  query += ` ORDER BY u.studentId ASC`;
}

const querySpec = {
  query,
  parameters: [
    { name: '@entityType', value: 'student' },
    ...studentIds.map((id, i) => ({
      name: `@studentId${i}`,
      value: id
    }))
  ]
};

const options: any = {
  maxItemCount: limit
};

if (continuationToken) {
  options.continuationToken = continuationToken;
}

const result = await this.container.items.query<student>(querySpec, options).fetchNext();

return {
  items: result.resources,
  continuationToken: result.continuationToken
};

// its in my db container where studentId is partition key
@CosmosPartitionKey('studentId')
export class StudnetsContainer {
studentId: string;
}

`

[github-actions]

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @sajeetharan @simorenoh.

[adeelnaqvisystems]

Waiting for the response @sajeetharan @simorenoh