Filtering by a group in a SharePoint Person or Group column
Filtering by a group in a SharePoint Person or Group column
I recently stumbled across this in a technet site here and modified it for my own use and to help anyone who wants it. I was trying to put multiple people in a SharePoint group, use a person or group column to categorize an item to that group, and then have it automatically filter based on which group you are in when you look at the item. I found the solution but it requires you to create the view that filters the Person or Group column to [Me] but then open the view in SharePoint designer and copy-and-paste the following (I know, it's scary) code. This means that you CANNOT add anything else to that view or attempt to modify it in any way after you change the code in SharePoint Designer because it will break that view and you have to do this all over again. This isn't a great solution because of that limitation but it will do if you absolutely HAVE to do this. Here are the steps:
1. Create the STANDARD view and filter to [Me] on the Person or Group column that contains the sharepoint group in which a person exists. 2. Open this view in SharePoint Designer…if it ever says you do not have permission to do something, simply click ‘Cancel’ and everything will be fine 3. Look in the CODE for the phrase ‘ListViewXml=’ tag and then scroll a LONG ways toward the right (after all the ‘FieldRef Name=blahblah_x0020_blahblah’) and look for ‘<Where’ and it ends a little ways after that with ‘/Where>’ 4. Look at the ‘FieldRef Name=’ and note what it is. 5. Replace the <Where thru the /Where> with the following: <Where><Or><Membership Type="CurrentUserGroups"><FieldRef Name="REPLACEME"/></Membership><Eq><FieldRef Name="REPLACEME"/><Value Type="Integer"><UserID Type="Integer"/></Value></Eq></Or></Where> (NOTE: If there’s a < after the end, DON’T DELETE IT!!) 6. NOTE: TO USE CALENDAR VIEWS – look inside the Where>< statement to find /DateRangesOverlap and then it has a couple of >’s and <’s and then it says EQ followed by the FieldRef Name of the key column you are using. Replace EQ through /EQ>< with the following: Or><Membership Type="CurrentUserGroups"><FieldRef Name="REPLACEME"/></Membership><Eq><FieldRef Name="REPLACEME"/><Value Type="Integer"><UserID Type="Integer"/></Value></Eq></Or>< 7. Replace the REPLACEME’s with the fieldref name that it originally said. For instance, on one form with the Ministry teams the field name was Singing_x0020_Team (the _x0020_ is a space in the field name…and the fieldref name is the name the column was given originally…doesn’t matter if you change it after that, the fieldref name remains).
There ya go. Use only in emergencies ^_^.
1. Create the STANDARD view and filter to [Me] on the Person or Group column that contains the sharepoint group in which a person exists. 2. Open this view in SharePoint Designer…if it ever says you do not have permission to do something, simply click ‘Cancel’ and everything will be fine 3. Look in the CODE for the phrase ‘ListViewXml=’ tag and then scroll a LONG ways toward the right (after all the ‘FieldRef Name=blahblah_x0020_blahblah’) and look for ‘<Where’ and it ends a little ways after that with ‘/Where>’ 4. Look at the ‘FieldRef Name=’ and note what it is. 5. Replace the <Where thru the /Where> with the following: <Where><Or><Membership Type="CurrentUserGroups"><FieldRef Name="REPLACEME"/></Membership><Eq><FieldRef Name="REPLACEME"/><Value Type="Integer"><UserID Type="Integer"/></Value></Eq></Or></Where> (NOTE: If there’s a < after the end, DON’T DELETE IT!!) 6. NOTE: TO USE CALENDAR VIEWS – look inside the Where>< statement to find /DateRangesOverlap and then it has a couple of >’s and <’s and then it says EQ followed by the FieldRef Name of the key column you are using. Replace EQ through /EQ>< with the following: Or><Membership Type="CurrentUserGroups"><FieldRef Name="REPLACEME"/></Membership><Eq><FieldRef Name="REPLACEME"/><Value Type="Integer"><UserID Type="Integer"/></Value></Eq></Or>< 7. Replace the REPLACEME’s with the fieldref name that it originally said. For instance, on one form with the Ministry teams the field name was Singing_x0020_Team (the _x0020_ is a space in the field name…and the fieldref name is the name the column was given originally…doesn’t matter if you change it after that, the fieldref name remains).
There ya go. Use only in emergencies ^_^.
