% PassThrough SqlServer crm1 Adventure_Works_Cycle_MSCRM SSPI false Account AccountNumber View Profile Select * from FilteredAccount where (AccountID LIKE @Accountid) or (Name LIKE @name) or (AccountNumber LIKE @accountnumber) or (AccountCategoryCodeName LIKE @accountcategorycodename) or (TerritoryIDName LIKE @territoryidname) or (IndustryCodeName LIKE @industrycodename) or (OwnershipCodeName LIKE @ownershipcodename) or (Address1_city LIKE @Address1_city) or (EmailAddress1 LIKE @emailaddress1) or (WebsiteUrl LIKE @websiteurl) or (PrimaryContactIDName LIKE @primarycontactidname) or (Telephone1 LIKE @telephone1) Text true % % % % % % % % % % % % Account ID Account Name true Account Number true Modified By true Modified Date true Primary Contact true Shipping method true Address1: Name true Address1: City true Address1: Country true Fax true Main Phone true Email true Website true Category true Territory true Industry true Ownership true Description true Payment Terms true Select * from FilteredAccount where (AccountID LIKE @Accountid) and ((Name LIKE @name) OR (Name IS NULL)) and ((AccountNumber LIKE @accountnumber) OR (AccountNumber IS NULL)) and ((AccountCategoryCodeName LIKE @accountcategorycodename) OR (AccountCategoryCodeName IS NULL)) and ((TerritoryIDName LIKE @territoryidname) OR (TerritoryIDName IS NULL)) and ((IndustryCodeName LIKE @industrycodename) OR (IndustryCodeName IS NULL)) and ((OwnershipCodeName LIKE @ownershipcodename) OR (OwnershipCodeName IS NULL)) and ((Address1_city LIKE @Address1_city) OR (Address1_city IS NULL)) and ((EmailAddress1 LIKE @emailaddress1) OR (EmailAddress1 IS NULL)) and ((WebsiteUrl LIKE @websiteurl) OR (WebsiteUrl IS NULL)) and ((PrimaryContactIDName LIKE @primarycontactidname) OR (PrimaryContactIDName IS NULL)) and ((Telephone1 LIKE @telephone1) OR (Telephone1 IS NULL)) Text true % % % % % % % % % % % % Account ID Account Name true Account Number true Modified By true Modified Date true Primary Contact true Shipping method true Address1: Name true Address1: City true Address1: Country true Fax true Main Phone true Email true Website true Category true Territory true Industry true Ownership true Description true Payment Terms true Text SELECT AccountID FROM FilteredAccount ID Product ProductNumber View Profile Select * from FilteredProduct where (ProductID LIKE @productid) or (Name LIKE @name) or (SubjectIDName LIKE @subjectidname) or (ProductNumber LIKE @productnumber) Text true % % % % Product Id Product Name true Modified By true Modified Date true Subject true Product Type true Product Number true Unit Group true Quantity on hand true Default Unit true Default price list true List Price true Decimals supported true Standard cost true Current cost true Status true Status Reason true Select * from FilteredProduct where (ProductID LIKE @productid) and ((Name LIKE @name) OR ( Name IS NULL)) and ((SubjectIDName LIKE @subjectidname) OR ( SubjectIDName IS NULL)) and ((ProductNumber LIKE @productnumber) OR ( ProductNumber IS NULL)) Text true % % % % Product Id Product Name true Modified By true Modified Date true Subject true Product Type true Product Number true Unit Group true Quantity on hand true Default Unit true Default price list true List Price true Decimals supported true Standard cost true Current cost true Status true Status Reason true Text SELECT ProductID FROM FilteredProduct ID Lead View Profile Select * from FilteredLead where (LeadID LIKE @leadid) or (Subject LIKE @subject) or (FullName LIKE @fullname) or (CompanyName LIKE @companyname) or (EmailAddress1 LIKE @emailaddress1) or (StatusCodeName LIKE @statuscodename) or (TelePhone1 LIKE @telephone1) or (WebsiteUrl LIKE @websiteurl) Text true % % % % % % % % Lead Id Topic true Full Name true Modified By true Modified Date true First Name true Last Name true Salutation true Job Title true Company Name true Rating true Business Phone true E-mail true Web Site true Industry true Lead Source true Owner true Status Reason true Status true Preferred Contact method true Last date included in Campaign true Select * from FilteredLead where (LeadID LIKE @leadid) and ((Subject LIKE @subject) OR (Subject IS NULL)) and ((FullName LIKE @fullname) OR (FullName IS NULL)) and ((CompanyName LIKE @companyname) OR (CompanyName IS NULL)) and ((EmailAddress1 LIKE @emailaddress1) OR (EmailAddress1 IS NULL)) and ((StatusCodeName LIKE @statuscodename) OR (StatusCodeName IS NULL)) and ((TelePhone1 LIKE @telephone1) OR (TelePhone1 IS NULL)) and ((WebsiteUrl LIKE @websiteurl) OR (WebsiteUrl IS NULL)) Text true % % % % % % % % Lead Id Topic true Full Name true Modified By true Modified Date true First Name true Last Name true Salutation true Job Title true Company Name true Rating true Business Phone true E-mail true Web Site true Industry true Lead Source true Owner true Status Reason true Status true Preferred Contact method true Last date included in Campaign true Text SELECT LeadID FROM FilteredLead ID Opportunity View Profile Select * from FilteredOpportunity where (OpportunityID LIKE @opportunityid) or (Name LIKE @name) or (CustomerIDName LIKE @customeridname) or (EstimatedCloseDate LIKE @estimatedclosedate) or (Description LIKE @description) Text true % % % % % Opportunity Id Topic true Modified By true Modified Date true Owner Name true Potential Customer true Probability true Status true Status Reason true Actual Close Date true Description true Created On true Est. Close Date true Select * from FilteredOpportunity where (OpportunityID LIKE @opportunityid) and ((Name LIKE @name) OR (Name IS NULL)) and ((CustomerIDName LIKE @customeridname) OR (CustomerIDName IS NULL)) and ((EstimatedCloseDate LIKE @estimatedclosedate) OR (EstimatedCloseDate IS NULL)) and ((Description LIKE @description) OR (Description IS NULL)) Text true % % % % % Opportunity Id Topic true Modified By true Modified Date true Owner Name true Potential Customer true Probability true Status true Status Reason true Actual Close Date true Description true Created On true Est. Close Date true Text SELECT OpportunityID FROM FilteredOpportunity ID Campaign CodeName View Profile Select * from FilteredCampaign where (CampaignID LIKE @campaignid) or (Name LIKE @name) or (CodeName LIKE @codename) or (Description LIKE @description) Text true % % % % Campaign Id Name true Modified By true Modified Date true Template true Status Reason true Campaign Code true Campaign Type true Expected Response true Price List true Offer true Proposed Begin date true Actual Begin date true Proposed End date true Actual End date true Description true Total Cost of Campaign true Estimated Revenue true Owner true Created On true Created by true Select * from FilteredCampaign where (CampaignID LIKE @campaignid) and ((Name LIKE @name) OR ( Name IS NULL)) and ((CodeName LIKE @codename) OR ( CodeName IS NULL)) and ((Description LIKE @description) OR ( Description IS NULL)) Text true % % %