Ad-hoc Query: Protocols for a Grant Number ------------------------------------------ Old Version =========== select q.doc_id FROM query_Term q WHERE q.path = '/InScopeProtocol/FundingInfo/NIHGrantContract/GrantContractNo' AND q.value like'%CA08748' New Version =========== SELECT q.doc_id FROM query_Term q WHERE (q.path = '/InScopeProtocol/FundingInfo' + '/NIHGrantContract/GrantContractNo' OR q.path = '/CTGovProtocol/PDQAdminInfo' + '/FundingInfo/NIHGrantContract/GrantContractNo' ) AND q.value LIKE '%CA08748'