I think you’ll be more successful using a combination of not showing completed tasks, and then limit to only showing 1 task.
Not sure how to translate that into multiple tasklist (from different notes/projects), whether you then could group on a single note and select only the first.
Can’t test right now, but I think either limit or group by should be able to help you accomplish your goal.