I'm experimenting with Sharepoint 2013. I'd like to set up a structure to store our client and supplier documentation and details. What I've done is to create a main suppliers site (/sites/suppliers) and one subsite for each supplier (/sites/suppliers/SUP0001), where we're storing documents for each supplier. Nothing complicated.
One of the aims is to store all the invoices to eliminate paper. So I also have /sites/suppliers/invoices/ where I have a list which contains scanned invoices. I load these pdfs into the list using a small powershell script, which is working fine.
Now I'd like to display the invoices for each supplier under the suppliers site - just a view of the main invoices list. I'm able to create a data view and display it under a suppliers branch, manually adding a filter for the suppliers code. I would like to have the data view filtered based on the supplier reference extracted from the site name.... but this is limited and I would imagine there is a better way.
Whats the simplest way to achieve this? Can it be done using caml? Are the filter fields able to contain variables or something similar?
This posting filter items by Site name and List Name using SPSiteDataQuery seems to be on the same topic but describes a solution based on coding an extension of some kind, which I want to avoid if possible just to maintain things as simple as possible.
At the moment I'm doing this with Foundation, partly as an exercise to see just how much I can do with it before needing the full sharepoint.