https://prefect.io logo
Title
e

Ewerton Henrique Marschalk

04/06/2022, 6:02 PM
hey, someone can help me with a query in graphql api? I wan't to collect all created flows in one query, but I wan't ONLY the LASTEST version of each, how can I do so?
:discourse: 1
k

Kevin Kho

04/06/2022, 6:14 PM
Something like this (archived = False)
query {
  flow(where: {name: {_eq: "schedule_test"}, archived: {_eq: false}}) {
    name
    project{
      name
    }
    version
    archived
  }
}
🙌 1
e

Ewerton Henrique Marschalk

04/06/2022, 6:36 PM
thanks, archved: false did the trick,
{
  flow(where: {archived: { _eq: false}}) {
    id
    name
    version
    flow_runs(where: {state: {_neq: "Scheduled"}} order_by: { start_time: desc }, limit: 1) {
      id
      state
      start_time
      end_time
    }
  }
}
will return the last time each flow run
k

Kevin Kho

04/06/2022, 6:40 PM
Nice!