Hi Why does this GQL query return "empty results"? I expect there to be only one, since the query fi...

Stéphan Taljaard

02/14/2022, 5:22 AM

Hi Why does this GQL query return "empty results"? I expect there to be only one, since the query filters the flow runs by id?

Copy code

query {
  flow(where: { name: { _ilike: "Energy Insight" } }) {
    flow_runs(where: {name: {_eq: "stalwart-ostrich"}}) {
      name
      id
    } 
  }

Copy code

{
  "data": {
    "flow": [
      {
        "flow_runs": []
      },
      {
        "flow_runs": []
      },
      {
        "flow_runs": []
      },
      {
        "flow_runs": []
      },
      {
        "flow_runs": []
      },
      {
        "flow_runs": [
          {
            "name": "stalwart-ostrich",
            "id": "8bca3ab2-05cc-4223-93f0-071813528545"
          }
        ]
      }
    ]
  }
}

Stéphan Taljaard

02/14/2022, 5:26 AM

I see the key is in the name being flow_run_*s*_ This query does return only one:

Copy code

query {
  flow_run(where: {name: {_eq: "stalwart-ostrich"}}){
    name
    id
  }
}

But it still feels strange to me that the former returns those empty ones even if they didn't have a matching ID?

Kevin Kho

02/14/2022, 2:42 PM

I think that is because your first flow query returns previous versions of the Flow as well. You can set

archived=False

to only get the latest one. And then those previous versions don’t have any flow runs with matching names

🙌 1

3 Views

Open in Slack

Previous Next

Prefect Community

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.