Fetch status information of most recent execution of a particular workflow

[najoshi7]

Hello prefect community,

I want to fetch the state of most recent (i.e. last) execution of a particular workflow- name and a particular project-name. I tried following query, but it returns all executions for a given workflow:

project_name = 'user1'
workflow_name = 'workflow-1'
query = {
    "query": {
        with_args(
            "flow",
            {
                "where": {
                    "_and": {
                        "project": {
                            "name": {"_eq": project_name},
                        },
                        "name": {"_eq": workflow_name}
                    }
                }
            }
        ): 
        {
            "name": True, 
            "id": True,
            "project": {
                "name": True
            },
            "flow_runs(order_by: { start_time: desc }, limit: 1)": {
                "state": True,
                "id": True
            }
        }
    }
}

The above query returns information about all executions instead of the latest one.

Please help.

[cicdw]

Hi @najoshi7 - your query should work as you expect but note that it will return data for all versions of your Flow. In general, it's best practice to use hyper-focused queries instead of loose queries that involve multiple nested where clauses and nested sorts. A much more performant and intuitive query would be:

query = {
    "query": {
        with_args(
            "flow_by_pk",
            {
                "id": "1b5cf8da-a36f-40ad-ab76-93aee908a3ac" # your Flow ID here
            }
        ): 
        {
            "flow_runs(order_by: { start_time: desc }, limit: 1)": {
                "state": True,
                "id": True
            }
        }
    }
}