Is there a way to search task text with DQL?

[aravindk100]

Instead of doing full match like the code snippet below I want to see if there is a way to do partial match (i.e. cinludes or contains). Is there option to do this in dataview query language? Thanks for the help.

Full match code that works,
TASK
WHERE text = "test"

[blacksmithgu]

Yes - WHERE contains(text, "test") for a "contains" check or WHERE regexmatch(text, ".+") for regexes.

[aravindk100]

Thanks that is helpful and worked for me. To find this information should I be looking anywhere particular? I spent a lot of time in the docs but I did not see how to use contains.

Now I tried to do this to find the date inside task like this,
TASK
WHERE contains(text, this.file.day)

and this does not work. I am able to use this.file.day when I have inline variable defined.

[aravindk100]

I also was able to make it work if I use direct string so it appears somehow the file.day beconverted to string but using the string function is not working for me.

TASK
WHERE contains(text, "2022-03-15")

[mnvwvnm]

this.file.day output something similar to "March 17, 2022" (depends on locale format, etc.).

Deducing that your date in task text have a format similar to "2022-03-17", then you need to format the output of this.file.day to similar "yyyy-MM-dd".

Try this:

TASK
WHERE contains(text, dateformat(this.file.day, "yyyy-MM-dd"))

[aravindk100]

Thank you this was helpful and worked for me.

Is there a way to filter tasks that are under a certain heading ? i have used time blocking in my daily notes and those have temporary tasks that I would like to ignore in my project query. Any suggestions here?