I've installed the Excel add-in and can do basic queries, but I don't know how to do the following:
1. Return the field that contains the defect number
2. Boolean queries, such as (Name contains "data") and (Name contains "viewer"). I get an error at "and"
3. How to find fields that aren't listed in the field drop-down, such as created by or date accepted