Lookup Control Not Returning Campaigns in SalesLogix

Question: I have created Campaigns in SalesLogix, but the lookup control is not returning Campaigns.  The control is on a bound user control that has a contact lookup, and the contact lookup works.  Here is how the lookup is defined:

LookupEntityTypeName=”Sage.Entity.Interfaces.ICampaign, Sage.Entity.Interfaces, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null”
AutoPostBack=”true” >
PropertyName=”CampaignName” PropertyFormat=”None” UseAsResult=”True” ExcludeFromFilters=”False”>
PropertyName=”CampaignCode” PropertyFormat=”None” UseAsResult=”True” ExcludeFromFilters=”False”>
PropertyName=”AccountManager.UserInfo.UserName” PropertyFormat=”None” UseAsResult=”True” ExcludeFromFilters=”False”>
PropertyName=”StartDate” PropertyFormat=”None” UseAsResult=”True” ExcludeFromFilters=”False”>
PropertyName=”EndDate” PropertyFormat=”None” UseAsResult=”True” ExcludeFromFilters=”False”>
PropertyName=”Status” PropertyFormat=”None” UseAsResult=”True” ExcludeFromFilters=”False”>

Why won’t the lookup control return Campaigns?

Answer: To troubleshoot your issue you should try the following:

• Run SLX Profiler on the Web Server.

• Open up the Web Client and Execute the Lookup.

The Profiler will give the SQL statement that was executed against the database, and this might give you a clue as to why no data is returned.