Dataview & Templater Query

[remoterocker]

I have two templates, book and author. In the author template, I want to run a query that pulls all books by that author.

An example:
BOOK NOTE: "Waging a Good War" has the YAML entry

author: Thomas E. Ricks

The corresponding AUTHOR NOTE: Thomas E. Ricks has the dataview query:

TABLE summary
FROM "KnowledgeConnection/3. Resources/Book Notes" OR "KnowledgeConnection/3. Resources/Articles"
WHERE author=tp.file.title
SORT title

The WHERE clause should point to the title of the current author file and search across book and articles by that author.

As a bonus help, for books and articles with multiple authors, can I list out the names like this in the book YAML:

author: Chip Heath; Dan Heath

then run the where query in my author note something like this:

WHERE author contains (tp.file.title)

Thanks for the help!