https://prefect.io logo
a

Adam Roderick

01/18/2021, 12:42 PM
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
upvote 2
a

Adam Roderick

01/18/2021, 5:59 PM
This will work. Thanks, Jenny!