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.

Prefect Community

Hello. Prefect 1. Is there a way in a graphql query to sort nulls last like: `order by column_name nulls last` ? I have this line `order_by: {start_time: desc}` in my query.
More context in comment

image.png

In Prefect 1, I have a graphql query that returns the response in the screenshot. The problem is that the flow_run start_time is `null` (maybe some bug in prefect 1 cloud), and in my request, I'm ordering by start_date (`order_by: {start_time: desc}` ), and I always get this null as the first one, which is breaking my code. I want null to be last, not first.

Have you tried to filter out the nulls? You could potentially create two qraphql calls, one with the nulls filtered out and one filtering just for the nulls and then concat the data with the nulls at the end before processing.