Advanced use of WHERE clause...

[MartynKeigher]

Hey all,
I'm stuck on the syntax\query for this scenario, and wondered if anyone has already accomplished it, or... if it is not currently possible for the plugin to do...

• I have a folder of 150+ tech docs.
• They all have a mix of tags on them. (linux, powershell, networking, nginx, docker, etc...)
• I'm looking to add a 'Related notes' section at the bottom of each tech doc, populated by a dataview query, which goes something like (in my head) this...

TABLE file.cday AS "Date Created" FROM "Technical Guides"
WHERE 'other files in this current folder have 2 MATCHING tags with this (currently being viewed) file'
SORT file.name 

Is this possible? and if so.. how? - Thanks.

://mk

[clotodex]

I don't know if this is possible with dataview SQL.
But you could try dataviewjs. It works the same way, but you can write custom javascript functions e.g. to go through all files in the folder and check if they have matching tags. You can then add these files to an array and render your array with dataviewjs again. I have not tried it, but I think it should be possible.
Hope this helps :)

[jaroet]

file.tags and this.file.tags show the needed data ... You would need something like "like" to looks if file.tags are like this.file.tags or so ... but like is not part of the syntax I think.