We are tracking down a problem where users register with Dynamic Registration and check a series of values in a group checkbox (which is stored in the DNN Profile table as "value, value, value")
When I do a search based on the values using the "contains" it never shows the correct number of results. This problem appear to be limited to that feld search.
Doing a SQL profile trace I get the following commands
exec dbo.DataSprings_RetrieveDNNUserProfileData3 @PortalID=0,@RoleFilter=N' Where UserID In (Select UserID from dbo.UserRoles Where (ExpiryDate >= GetDate() OR ExpiryDate Is Null) AND (EffectiveDate <= GetDate() OR EffectiveDate Is Null) AND RoleID IN (4,3,5 ))',@LimitResults=N' TOP 1000',@Authonly=0
which returns 769 records. based on that recordset the filter for "Field contains value X" should then filter down to about 30 records . It's returning 2.
Apparently this filtering is done inside the module based on the total records returned from the above stored proc. Is there anyway to see what is *actualy* being filtered so we can determine the real problem?