I know the UI shows upcoming runs that are late; h...
# prefect-ui
k
I know the UI shows upcoming runs that are late; however, is there any way to find historical runs that were late?
k
I don’t think there is a view in the UI. You would need to use the GraphQL API and check for the start time being later than the scheduled time
👍 1
k
@Kevin Kho I’m kind of new to GraphQL/Hasura/etc. I can’t seem to find/figure out how to compare a field to another. Have you ever done this before by chance?
k
I think you need to bring the query results to Python and then do the comparison there because you can’t in the query. Am looking through the UI code. Let me verify.
k
Gotcha, I could query for flow runs for the past x timeframe, then check the data in memory.
k
I checked and I think I’m right. You can use the
client.graphql
to just do a simple query on flows with something like:
Copy code
query {
  flow {
    flow_runs {
      start_time
      scheduled_start_time
    }
  }
}
and then process the results in Python
🙏 1