microsoft / microsoft/durabletask-mssql

Retrieve the total number of filtered instances by SqlOrchestrationQuery

Open
#72 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
C#
Stars
105
Forks
36
PR merge metrics
No merged PRs in 30d

Description

Hello,
The GetManyOrchestrationsAsync returns a list of orchestration states. We can set the paging parameters (pageNumber and pageSize) with the SqlOrchestrationQuery object.
My problem is that this method cannot tell us how many instances match the defined query filter.
Can we add a GetOrchestrationsCountAsync method that accepts the same SqlOrchestrationQuery object as input (without paging information) and returns that total number of matching instances.
Thank you

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by locating GetManyOrchestrationsAsync and the SqlOrchestrationQuery type in the durabletask-mssql repository. Review how paging and filtering are applied, then verify that the count operation uses the same filters without paging and returns the total matching orchestration instances.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql
Domain
api, database
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.