When you try to open an account form (for example) and to view Activities and then to apply the feature "Filter On", this feature doesn't filter activities... For example if you create a task with Start Date on 2012-01-01 and then you try to apply "Filter On Next 7 days" it shows the task!

This is the query extracted by profile. There are not filter applied!!.



"exec sp_executesql N'select
COUNT(*) as [#TotalRecordCount]
from
(select
DISTINCT top 5001 "activitypointer0".Subject as "subject"
, "activitypointer0".ActivityId as "activityid"
, "activitypointer0".ScheduledStart as "scheduledstart"
, "activitypointer0".RegardingObjectId as "regardingobjectid"
, "activitypointer0".PriorityCode as "prioritycode"
, "activitypointer0".ScheduledEnd as "scheduledend"
, "activitypointer0".ActivityTypeCode as "activitytypecode"
, "activitypointer0".InstanceTypeCode as "instancetypecode"
, "activitypointer0".RegardingObjectIdYomiName as "regardingobjectidyominame"
, "activitypointer0".RegardingObjectTypeCode as "regardingobjecttypecode"
, "activitypointer0".RegardingObjectIdName as "regardingobjectidname"
from
ActivityPointer as "activitypointer0" (NOLOCK) join ActivityParty as "aa" (NOLOCK) on ("activitypointer0".ActivityId = "aa".ActivityId and (("aa".PartyId = @PartyId0))) join ActivityParty as "activityparty1" (NOLOCK) on ("activitypointer0".ActivityId = "activityparty1".ActivityId and (("activityparty1".PartyId = @PartyId1)))
where
((("activitypointer0".StateCode in (@StateCode0
, @StateCode1)) and "activitypointer0".IsRegularActivity = @IsRegularActivity0))) as #SubQuery',N'@StateCode0 int,@StateCode1 int,@IsRegularActivity0 bit,@PartyId0 uniqueidentifier,@PartyId1 uniqueidentifier',@StateCode0=0,@StateCode1=3,@IsRegularActivity0=1,@PartyId0='62565ED6-484E-E011-B03A-0050568D000A',@PartyId1='F614AE06-7C7C-E011-90FE-0050568D000B'"


Any solutions?

Thank you,

Alberto