hey, someone can help me with a query in graphql a...
# prefect-community
e
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
Something like this (archived = False)
Copy code
query {
  flow(where: {name: {_eq: "schedule_test"}, archived: {_eq: false}}) {
    name
    project{
      name
    }
    version
    archived
  }
}
🙌 1
e
thanks, archved: false did the trick,
Copy code
{
  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
Nice!