Hello Prefect 1 Is there a way in a graphql query to sort nu

Question

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

Mansour Zayer · Answer

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

Kalise Richmond · Answer

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