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

Hi again, what would be the easiest way to programmtically get the tasks that failed and those that trigger failed given a flow run id ?

Yes - probably - but I am not sure how the query would look

Hey <@U0141PE1A84>,
An augment of this query will be useful:
```query {
  task_run(
      where: {
          state: {_eq: "Failed"},
          flow_run_id: {_eq: "YOUR_FLOW_RUN_ID"},
        }
    ) {
    cache_key,
    created,
    end_time,
    ...
  }
}```

Not sure on the trigger failed part, looking into that - will likely be looking for those task runs that ended in a `TriggerFailed` state.

Hi <@UUDFU628J> - thank you for your suggestion:
I would like to know the task names that failed - so following your template I wrote up this query:
```query {
  task_run(
      where: {
          state: {_eq: "Failed"},
          flow_run_id: {_eq: &lt;flow_id&gt;},
        }
    ) {
    name,
  }
}```
and here is what I get -
```{
  "task_run": [{
    "name": null,
    "__typename": "task_run"
  }, {
    "name": null,
    "__typename": "task_run"
  }, {
    "name": null,
    "__typename": "task_run"
  }, {
    "name": null,
    "__typename": "task_run"
  }]
}```
but I see `null`  values not the task names ...

ah nevermind this is the task run name not the task name

```query {
  task_run(
      where: {
          state: {_eq: "Failed"},
          flow_run_id: {_eq: "&lt;flow_id&gt;"},
        }
    ) {
    task{
      name
    },
  }
}```