Please help - using filters

[nbarman2022]

Hi - I'm kind of new to this and looking for some help with writing two types of filters.

First Filter
I currently have a filter written as such:

[!Pending Tasks Across Projects]

not done
filter by function task.file.hasProperty('Project')
group by function task.file.property('Project')

And this works fine. But I want to modify this so that instead of just showing me Tasks that come from a file that has the property 'Project' - I want it to pull Tasks that come from a file that either has a property called 'Project' OR a property called 'Opportunity'. But I can't figure out how to add the OR statement to this filter.

Second filter
I'm trying to create a filter that asks to show me Tasks that come from a file that has a property called 'Project' which is populated with a specific project name. Right now, I did this:

filter by function task.file.property('Project') === '[[Specific Project Name]]'

But if I place this query on the Project page, then I want my filter statement to say "this.file.name" instead of manually typing in the name of the specific project. This way, I could put this query into my Project page template. Is this possible?

[claremacrae]

First Filter I currently have a filter written as such:

...I want it to pull Tasks that come from a file that either has a property called 'Project' OR a property called 'Opportunity'. But I can't figure out how to add the OR statement to this filter.

See Combining Filters.

So try this:

[ filter by function task.file.hasProperty('Project') ] OR  [ filter by function task.file.hasProperty('Opportunity') ]

I like wrapping long lines with \ for readability:

[ filter by function task.file.hasProperty('Project') ] OR \
[ filter by function task.file.hasProperty('Opportunity') ]

Be sure to read the Syntax section to understand why all the following work, and when to use them:

explain

[ filter by function task.file.hasProperty('Project') ] OR \
[ filter by function task.file.hasProperty('Opportunity') ]

{ filter by function task.file.hasProperty('Project') } OR \
{ filter by function task.file.hasProperty('Opportunity') }

" filter by function task.file.hasProperty('Project') "  OR \
" filter by function task.file.hasProperty('Opportunity') " 

( filter by function task.file.hasProperty('Project'); ) OR \
( filter by function task.file.hasProperty('Opportunity'); )

Second filter I'm trying to create a filter that asks to show me Tasks that come from a file that has a property called 'Project' which is populated with a specific project name. Right now, I did this:

filter by function task.file.property('Project') === '[[Specific Project Name]]'

You can access various information about the query file: See Query Properties.

So try these:

explain

# This one gives easier-to-understand/check output in 'explain':
# It uses placeholders: https://publish.obsidian.md/tasks/Scripting/Placeholders
filter by function task.file.property('Project') === '[[{{query.file.filenameWithoutExtension}}]]'

# This one is safer if your filenames might have quotes in:
filter by function task.file.property('Project') === '[[' + query.file.filenameWithoutExtension + ']]'

[nbarman2022]

Thank you for the very clear response on this @claremacrae! I did read the pages for Combining Filters, Syntax and Query Properties, but found them to be a bit too technical to understand, so I appreciate you providing the exact language I could use in my setup. It worked perfectly!

[claremacrae]

Thanks for the swift reply.

[claremacrae]

(I've changed the Category to Q&A)