Thread
#prefect-community
    Fabrice Toussaint

    Fabrice Toussaint

    1 year ago
    Hi everyone! Is there a way to get the total amount of flow runs with the GraphQL API? When I want to retrieve the results there is a limit of 100 but I have more flow runs than that and want to loop over them. My goal is to delete all flows that are not scheduled.
    Michael Adkins

    Michael Adkins

    1 year ago
    Hey @Fabrice Toussaint -- to get the aggregate may be covered by the limit as well; is there a reason you can't just loop until you have deleted them all and you get nothing back in your query?
    Fabrice Toussaint

    Fabrice Toussaint

    1 year ago
    I currently query the database directly because GraphQL is not making a lot of sense to me
    I just delete the flow_run table & the logs table