how to add a view filter to check if the login user is inside a group,same as for [Me]

Question

I have added the following filter inside a view:-

Which will filter if the “Assigned To” field equals the logn user. But now if the “assigned to” field contain a group which I belong to, then the filter [Me] will not be able to detect this. So is there a way to say something [MYGroups] to check if I am within the inserted assigned to group ?

Edit i tried this query tag :-

<Query><GroupBy Collapse="FALSE" GroupLimit="30"><FieldRef Name="_ModerationStatus" Ascending="FALSE"/></GroupBy><OrderBy><FieldRef Name="Modified" Ascending="FALSE"/><FieldRef Name="FileLeafRef"/></OrderBy><Where><And><Or><Membership Type=\"CurrentUserGroups\">
<FieldRef Name=\"AssignedTo\"/>
</Membership><Eq><FieldRef Name="Assinged_x0020_to"/><Value Type="Integer"><UserID Type="Integer"/></Value></Eq><Eq><FieldRef Name="Assinged_x0020_to"/><Value Type="Text">admin</Value></Eq></Or><Eq><FieldRef Name="_ModerationStatus"/><Value Type="ModStat">pending</Value></Eq></And></Where></Query>

but this have raised an exception when i tried to open the view?

Answer 1

From: http://www.makdeniz.com/how-to-filter-sharepoint-2010-tasks-which-are-assigned-to-you-and-the-group-your-are-member-of/

Step 1:

Open SharePoint designer then open site that you want to study. Select the task list or any list that you want to filter. When you select task list you will see a panel right site of designer called views. Then select the view that we will modify.

Step 2:

If you can not edit file you must select advanced edit mode

Step 3

In source view search for and you will see view query. If you already modify view as filtered by [Me] you are going to see more or less query as shown in picture. Modify this query string with code given below. that’s how user can see tasks which are assigned to him or his group.

Step 4:

The key ingredient is “CurrentUserGroups”. Now you can modify any list and make different types of filter. This query syntax called CAML. If you study little bit, then you can make complex query or what ever you want.

 <Or>
   <Eq>
     <FieldRef Name="AssignedTo"/>
     <Value Type="Text">admin</Value>
   </Eq>
   <Or>
      <Membership Type="CurrentUserGroups">
        <FieldRef Name="AssignedTo"/>
      </Membership>
      <Eq>
        <FieldRef Name="AssignedTo"></FieldRef>
        <Value Type="Integer">
          <UserID/>
        </Value>
      </Eq>
    </Or>

  </Or>