Overview

qSIListView displays data from your external system in a grid, and allows you to:

•	customize the look and feel by using Skin.

•

divide the data into multiple pages to limit their size and render pages faster. This feature is called Paging. There are two Paging Modes available: Numeric Pager and Next Previous. If the number of rows in a table is more than the specified Page Size, the data is divided into multiple pages and a Pager is displayed at the bottom of the listview to enable the user to navigate to different pages

•

retrieve the data from your external system one page at a time using custom paging. In order to use this feature, your external system must provide a method to retrieve one page of data by using the page size and page index parameters. If your external system does not support custom paging, you can still page your date as described in the previous point.

•	define a static filter using Complex Filter (For more information, see Complex Filters). The Complex Filter expression supports time functions (such as AddDays) and time expression (such as [TODAY]) to filter out data based on a moving time window. This feature is called Data Aging.

•	define the initial static sort expression using the Sort Fields property. The listview can sort the data based on multiple fields.

•	sort the data in the listview by clicking the grid headers. Clicking the header repeatedly will change the sort direction for that field from ascending, descending and neutral (no filter). You can sort the data in the listview using multiple fields.

•	create a relationship between parent and child entity.

•	define multiple levels of grouping on the data using the Grouped attribute in the Display Fields property. You can also display the sum or item counts in the group header.

•	show or hide the listview based on the site group membership of the currently logged in user by using the Show User Groups and Hide User Groups properties.

•	display the data in virtually any format that can be achieved with JavaScript and HTML. With this feature, you can create many types of custom reports on the data. The JavaScript and HTML for a custom display is defined in the Results Header, Results Body and the Results Footer properties.

•	consume a filter from another web part that implement IWebPartRow or IWebPartParameter interface.

•	consume a row from another web part that implement IWebPartRow interface. The row that the listview consumed can be passed into the operation to retrieve the data as a parameter or can be used in the custom action.

•	display, create, and edit data in your external systems. Out of the box, this Web Part supports the DAO Provider for:

•	Web Services

•	SQL Server

•

Oracle

•	Domino Server using XML over HTTP

•	Salesforce

•	K2Server (for SharePoint 2010 only)

 

TIP: To better understand SI web parts, read the System Integration Developer Guide.