In my subwebs I have a 1 row list called "Details" that contains various bits of data that are meant to be web-level metadata. Image field, AssignedTo field, couple of string columns, etc.
On top of that at the root level I have a Content Query Web Part that grabs all subweb lists of type Details and displays this metadata in a grid.
What I would like to do is add a column to this list that returns the Title and Url of the site, however I don't want to duplicate data by creating a field to store it. I just want to return data that's already available at the web level.
Does anyone know if it's possible to add a Lookup column (or calculated) that will lookup a property in the web property bag?