创建Web视图与鲜明的列值 [英] Creating SharePoint View with Distinct Column value

问题描述

是否有可能创建一个自定义列表视图（不是列表视图的WebPart）具有独特的列值。我有一个有5个柱像项目编号，项目名称，活动ID，状态，点一个列表。

Is it possible to create a custom list view (Not a list view webpart) with unique column value. I have one list which has 5 column like project ID, Project Name, Activity ID, Status, Points.

我想创建一个自定义列表视图，其中活动ID列只能返回不同的值。我怎样才能实现这个目标呢？请帮助做到这一点。所有的建议和答案将AP preciated。

I want to create a Custom list view where the Activity ID column should be return distinct value only. How Can I achieve this goal? Please help to do this. All suggestions and answers will be appreciated.

在此先感谢..

推荐答案

SharePoint列表视图基于CAML查询和CAML不支持获取不同的值呢。

SharePoint List views are based on CAML queries and CAML does not support retrieving DISTINCT values yet.

你可以做的是使用GROUP BY，这将组中的所有相似的结果一起，你可以随意折叠它为好，看上去像一个不同的行。

What you can do is use GROUP BY, which will group all the similar results together and you can optionally collapse it as well, looking like a distinct rows.

<一个href=\"http://social.technet.microsoft.com/Forums/sharepoint/en-US/c2bbcf13-a53d-4755-87dd-871a51840a4d/select-distinct-in-caml-query-for-list\" rel=\"nofollow\">http://social.technet.microsoft.com/Forums/sharepoint/en-US/c2bbcf13-a53d-4755-87dd-871a51840a4d/select-distinct-in-caml-query-for-list

这篇关于创建Web视图与鲜明的列值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！