add query for search pins and reports