Hello, I’m not sure how best to explain my problem, so hopefully my example screenshot will help.
I want to track which characters have had which scenes/interactions with other characters. I have a folder, ‘Characters’, with each character profile in a separate document, and a folder, ‘Scenes’, which has a separate document for each scene, and I use dataview as to list in the character profiles which scenes that character has been a part of, and who else is in that scene.
Here’s an example of the properties, the dataview query, and the previewed result.
So, that all works as intended, but I was wondering if there was any way to remove, in this example, ‘Gus Fring’ from the characters list in the dataview, because we already know he’s in those scenes, because we’re looking at it from his character profile. I want to be able to use this.file.name in the query while omitting this.file.name from the displayed results, if it’s at all possible. Or perhaps if there’s another way to achieve what I’m looking for.
It should remove this.file from the
result set, but looking a little more on your result you might want to remove it from the Characters in your second column?
Then try to use TABLE filter(Characters, (c) => c != this.file.name) as "Other characters"
And you could most likely remove my suggested WHERE clause. It was the answer of a related question wifi you didn’t ask…
