How to only query incomplete tasks from a folder?

[jasmeetchadha]

I am sure I am incorrectly using where query, but I don't really know how to. This query below pulls all tasks from the folder, including completed ones.

Can you please help write the query for pulling incomplete tasks from the two folders below?

Many Thanks

task from "6 Daily" OR "4 Quarterly"
where completed != 1

[jasmeetchadha]

I saw this solution somewhere. But how do we do this for multiple folders? Sorry I am a non-coder trying to make use of this amazing plugin. Suddenly this starts to compete with Notion.

dv.taskList(dv.pages('"6 Daily" OR "4 Quarterly"').file.tasks.where(t => !t.completed))

[blacksmithgu]

The query you've shown should work - are you having issues?

[jasmeetchadha]

Its working, but now I have another issue. Its not sorting or it was, but somehow its now showing older (created) tasks first and new tasks somewhere in the middle.

```dataviewjs
dv.taskList(dv.pages('"6 Daily" or "4 Quarterly"').file.tasks.where(t => !t.completed))

[blacksmithgu]

You aren't sorting by anything, so the order will be a little arbitary (based on how they show up in the file). You'll want to do

dv.taskList(dv.pages('"6 Daily" or "4 Quarterly"').sort(p => p.file.ctime).file.tasks.where(t => !t.completed))

[jasmeetchadha]

Thanks, I will try that out