How to return subtasks with non task parent?

[sinewave]

Just getting started and I'm having a hard time figuring out how to return subtasks that don't have a parent task e.g.:

• regular task item
  • subtask with task parent
  • list item with task parent
• regular bulleted list item
  • this is a subtask with non-task parent that doesn’t return

If I do the simplest of queries of just "TASK SORT BY file.mtime DESC" Dataview returns everything except the subtask with a non-subtask parent.

Is there any way to query these as well? I often use this format when taking meeting notes..

[wenlzhang]

What if you add !fullyCompleted to the where part of the query?

[sinewave]

That did it, tku for your help 👍 !

[sinewave]

One more follow-up question if you're willing. Do you know if there's a way to only return tasks and not the regular list item e.g. "iist item with task parent"?

Tried this with no luck:

TASK
WHERE !fullyCompleted AND subtasks = real
SORT file.mtime DESC

[sinewave]

Last question 😄

Is there an easy way to sort the tasks by most recently modified?

[wenlzhang]

You may try to put .sort(p => p.file.mtime, 'desc') after .where.

[sinewave]

Trying this:

gives me this error:

[wenlzhang]

I think I made a mistake. Moving the sort part a little might work, like the following. This way, the sort is applied to pages/notes.

const pages = dv.pages("").sort(p => p.file.mtime, 'desc').file.tasks.where(t => !t.fullyCompleted)

[sinewave]

TKU 🙏 🎉 !!!

Just wish that this plugin was easier to use / understand for non-technical folks as I know there's so much more it can do.