Overview of Infinity Data Lists
Data lists are used to display a list of data in a tabular format. The rows that comprise a data list typically come from a database; but, you can display data from virtually data source. There are two different types of specs to create a data list: Data List Spec (SP) and Data List Spec (CLR)
The table below provides a high level overview of each type and when they should be used.
| Spec Template Name | Description |
|---|---|
| Data List Spec (SP) | This spec defines the stored procedure that returns the data for the data list. Use this spec type when a stored procedure is sufficient to pull all the needed data for your data list. |
| Data List Spec (CLR) | This spec type defines the server-side catalog implementation that will fetch the data for the list. A Data list Spec (CLR) requires an XML element named CLRDataList which describes a data list based on CLR code. The CLR code is implemented within a .NET class that resides within a .NET CLR assembly hosted in the web service layer. The .NET class should inherit Blackbaud.AppFx.Server.AppCatalog.AppDataList. The CLRDataList XML element can contain a list of parameters that match a set of public variables within the .NET CLR class file. When the Infinity user interface calls upon the CLR data list to display a list of data, the GetListResults() function is called on the .NET CLR class file. GetListResults() is responsible for gathering the data for the data list and returning the data as type Blackbaud.AppFx.Server.AppCatalog.AppDataListResult. Use this spec type when complex logic is required or when you need to pull data together from atypical data sources. |