Hi! I am looking for a way in prefect cloud to report on successful/failed flow runs over the last week, month etc. What do you recommend? I want to filter by label and date range. Any suggestions? Thanks!
j
Jenny
01/18/2021, 2:51 PM
Hey @Adam Roderick - for now you're probably best using the interactive API and a query for flow runs like this:
Copy code
query {
flow_run (where: {state: {_eq: "Success"}, start_time: {_gte: "2020-01-10"}, labels: {_eq: ["label-name"]} }) {
id
name
}
}
You'll need to replace "label-name" with your labels and the "gte" means greater than or equal so you can update the date as needed. (You can also switch success to failed and add what other fields you need.) If it's a feature you think you'd use often and would like in the UI, please add a ticket in the UI repo
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.