Geek Answers Handbook

SharePoint "Group By" crashes when using "Allow Multiple Values" for a column

I want to show documents in my document library, grouped by category. A category is a search column that I added that allows multiple values ​​to be used. Unfortunately, this completely destroys the "band over." Is there a software solution to this problem?

+4
source share
5 answers

There is one way ... It's complicated and ugly - but it should work :)

You can write your own view for the list (HTML, JavaScript and all). The VWSTYLES.xml file in the folder C: \ Program Files \ Common Files \ Microsoft Shared \ Web Server Extensions \ 12 \ TEMPLATE \ GLOBAL \ XML contains HTML and JavaScript for standard SharePoint viewing styles - you can create your own inspiration from this presentation style where you can do whatever you want!

The problem is that SharePoint has no way to expand your custom view style — that’s where the ugly part is — you have two options to deploy your presentation style.

  • Add your code directly to the VWSTYLE.xml file / Edit it and override it using the function

    Pros:

    You can still edit the view from the SharePoint interface.

    Minuses:

    You override the default SharePoint file - your work may be canceled by the upgrade of SharePoint.

    Your presentation style will be available on every list in SharePoint.

  • Create your view programmatically in the list

    Pros:

    You do not override any default SharePoint Files settings.

    You can control which list your view uses.

    Minuses:

    You cannot edit the view through the SharePoint interface.

I used method 2 a couple of times myself - and it works ... but it is not very! :)

+3
source

I do not think that what you are trying to do is possible. When grouping items / documents, you display them in different groups based on the grouping value. I do not think SharePoint supports adding one item to multiple groups. With several values ​​in the grouping field "it is impossible to find out which group the element / document is added to. I am not sure if this is an error or if it is by design.

0
source

Thomas is right, this is by design, because the element must appear several times in different groups. However, it is worth noting that this is possible through web services.

See why I got duplicate strings from the shared name list web service

And no, I don’t know why webservice lists will do this, but there will be no API.

0
source

Check out this link. Access supports this feature without making very ugly code. http://office.microsoft.com/en-us/access/HA012337221033.aspx

0
source

So, here's a bit of a hack that worked for me, but no guarantees. Although your column (Office in my case) allows you to include multiple values, fill in all your details as needed. After that, go to the "List Options" section, click the "Office" column, and turn off a few values. A warning will appear in SharePoint about how this data could be lost (it never happened to me). Calm down and then change the view you want to group, "Office" should now appear when columns appear for grouping. A completed result will result in your groups (and / or subgroups) being displayed just fine.

The only thing I have is that instead of the element being displayed in both groups AB, because both the field A and the field B were marked in the column field X, it simply creates a new group Column X: A; B. Therefore, in my case, I have staff in the Beaufort and Orangeburg offices, instead of having these employees in both groups (preferred), he creates a new group, as shown below:

groups

0
source

More articles:


All Articles