Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

I don't have any experience with GraphQL so I'm struggling to format my query. How would I get a count of running/submitted flow runs for a specific flow name? I'm a django orm user, so I know it would look this:
```nruns = FlowRuns.objects.filter(flow__name="MyExampleFlow", state__in=["Running", "Submitted"]).count()```
But for graphql... I'm kinda lost. And how would I format this in python for the `client.query()` method?

<https://github.com/PrefectHQ/ui/blob/master/src/graphql/Flow/flow-runs.gql#L1|This> is the source for what the UI uses

```query FlowRuns($flow_run_name: "MyExampleFlow",) {
  Success: flow_run_aggregate(
    where: {
      flow: { name: { _eq: $flow_run_name }}
      state: { _eq: "Success" }
    }
  ) {
    aggregate {
      count
    }
  }```

so would it look something like this? I'm getting errors but honestly have no idea what's wrong

Actually nevermind. I think I'm getting the hang of it. My query is:
```query {
  flow_run_aggregate (where: 
    {flow: {name:{_eq: "MyExampleFlow"}}
    state: { _in: ["Success", "Pending"] }
    })
     {
      aggregate {count}
    }
}```

That looks good. I was expecting you to just use the flow id but this looks like it works