Aggregation, filtering and grouping

The Quest List View eases site maintenance and introduces the concept of Cross Site Lookup, which implies that information can be looked up from lists in different sites. Using the Quest List View WebPart, it is very easy to aggregate data from multiple lists to display that information in a grid. The lists do not even have to exist in the same sites as the current site. This allows for a lot of flexibility in quickly managing information in different lists/sites.

Cross site data viewing - Screen cast

The Quest List View has many capabilities. Each capability is described below:
Very intuitive configuration UI Quest List View WebPart comes with an intuitive configuration interface which can be used to configure many complex aspects of he WebPart. The user interface can be accessed from the Configure item on the WebPart menu display.

Capability to display hierarchical data - The List View provides the capability to surface hierarchical data. For example, information can be displayed from the Customers list and the Sales list in the same view.

Capability to display data from lists associated with multiple content types - The List View can display the data from lists that are associated with multiple content types. The List View contains a New button for each content type to enable the creation of object with different content types from te list view.

Ensures referential integrity of the records in the dependent lists - The List View ensures the referential integrity of the records in the dependent lists by preventing the deletion of the parent ecord. The dependent lists are defined in the Viewed Lists property.

Divides the data into multiple pages to limit size and render pages faster - Dividing the data into multiple pages for better display is called Paging. The List View supports two different types of paging: Numeric paging and Prev Next paging. This allows the user to easily skip the other pages to view more results. The Pager control is displayed at the bottom of the page when page results exceed allowed results on page.

Capability to add static or dynamic filters - Static filters are defined using the CAML filter expression or Complex filter expression. The List View also allows the user to enter a dynamic filter using the Find panel. The WebPart author can decide which fields will be shown to the users using the Searched Fields property.

Sorting the data based on multiple fields, as well as sorting by clicking on the grid headers - The List View allows users to sort the data based on grid headers. Clicking the header repeatedly will cycle the sort order between ascending, descending and no sort. The List View also allows sorting the data using multiple fields.

Ability to manage folders from one or more lists or document libraries - The List View provides capability to manage folders from one or more list or document libraries. This is accomplished using the folder panel, which lists out all the folders in each document library with the ability to drill down into each folder to view its contents. Users can manipulate folders in the folder panel using a context menu that is available by right clicking the folder. This feature will be further explained in a later module.

List of features

Aggregations or Rollups	Aggregate information from multiple lists within and across multiple sites into the list view, with on-the-fly sorting and filtering.
Aggregations Calendar data	Aggregate calendar or date related information
Centralized data structure	Create centralized lists of data, documents or forms. By using rich meta data, security and filtering allow users to access some or parts of the content from there My Sites, Team sites, Department or Workgroup sites.
Dashboards	Dashboards provide a visual representation of your data in the form of Pie, Line, Bar, Area, Bubble, Point, and Spline chart. It is able to aggregate data from multiple lists into one chart.
Reporting	Create reports that represent the status of content from one or across many sites.
Distributed data structure	Create master lists of content that resides in one or many My Sites, Team sites, Department or Workgroup sites and virtual servers.
Exporting to Excel	Export content into Excel for further analysis and or distribution
Content publishing	Publish content up or across your SP implementation. Publishing can happen across virtual servers.