Filter Tasks Where Query Property "Projects" Shares Value With Task Property "Projects"

[23426356587]

Hello - I have a similar situation from this item but different enough I think it needs its own discussion.

I'm trying to get a query that compares a property in the query file with the same property in the task file. I'll include the queries I've tried but honestly it's just me throwing spaghetti at the problem and not getting anywhere with AI.

I think (fingers crossed) this should be a straight forward query, but I can't figure out why I can't compare the values. Is it an issue with how the property is being onto the file?

Thank you :)

The properties on both files look like this:

Projects:
  - "[[Shared Note]]"

filter by function task.file.property('Projects') === query.file.property('Projects')
ignore global query
explain

filter by function task.file.property('Projects') === {{query.file.property('Projects')}}
ignore global query
explain

filter by function task.file.property('Projects') === '{{query.file.property('Projects')}}'
ignore global query
explain

filter by function return task.file.property("{{task.file.property('Projects')}}").includes({{query.file.property('Projects')}})

filter by function query.file.property('Projects') === task.file.property('Projects')
ignore global query
explain

filter by function return query.file.property('Projects')?.includes(task.file.property('Projects')) ?? false
explain
ignore global query

[claremacrae]

The properties on both files look like this: Projects:

• "[[Shared Note]]"

That is not a property that I can copy.

I realised there was actually a whole property there, but it wasn't in a fenced code block, so wasn't visible as a property sample.

I have fixed formatting in the original post.

[claremacrae]

@23426356587 - I realised it was a formatting issue in the question, which I have fixed - so you can ignore my message above, which I have edited to remove the question.

[claremacrae]

Failing query

This fails, because it is asking if the two files are the same object in memory, which they are not, because they were read at different times:

filter by function \
    task.file.property('Projects') === \
    query.file.property('Projects')

Working query

This works because the two properties are converted to strings, which can then easily be compared for equality:

filter by function task.file.hasProperty('Projects')
filter by function \
    JSON.stringify(task.file.property('Projects')) === \
    JSON.stringify(query.file.property('Projects'))
full mode

The JSON.stringify() call stringifies the query property for every task that is searched, which is a bit wasteful, but I doubt you will get measurable performance problems.

However, putting the hasProperty() check first ensures that only tasks in files with that property ever reach the second filter, which seems like a good idea.

[claremacrae]

I have corrected a pretty major copy-paste error which initially said the same thing for the second query as the first one... when in fact, the second one does work.

Apologies for the confusion.

[huw-sinc]

Thank you for your explanation of why one fails and the workaround, this was very educational for writing my own queries.