What I’m trying to do
For each person on the team I have a file in People and similar for each site I have file with the SiteName and YAML of who has access to it in a list. I would like to setup a template in dataview to make a table of all the sites they have access to so I can check either from the site page or the people page if someone has access or not.
Things I have tried
Code:
table SiteNumber, Location
FROM "Sites"
where contains(PersonalAccess, this.file.name)
Doesn’t work but if I call out the persons name then it does. I would just like the ability to put in a common template rather then having to adjust everyone one by one
table SiteNumber, Location
FROM "Sites"
where contains(PersonalAccess, [[Joe Smith]])