Custom table data source

  Previous topic Next topic Print this topic Mail us feedback on this topic!

  Default  
  Web part control ID: Serves as an identifier for the web part. This ID must be unique within the context of each page template. The value of this property may only contain alphanumeric characters and the underscore character ( _ ).  
  Web part title: Title of the web part displayed on the Design tab of CMS Desk. If empty, the value of the Web part control ID property is used for this purpose.  
  Disable view state: Indicates if view state should be disabled for this web part.  
  Disable macros: If checked, macros contained in the values of the web part's properties will no longer be resolved.  
   

  Data filter  
  Custom table name: Allows the selection of the custom table from which data should be loaded.  
  ORDER BY condition: Sets the value of the ORDER BY clause in the SELECT statement used to retrieve the content.  
  Select Top N items: Specifies the maximum amount of items to be selected. If empty, all possible items are selected.  
  WHERE condition: Sets the value of the WHERE clause in the SELECT statement used to retrieve the content.  
  Selected columns: Lists the database columns that should be loaded along with the given objects, separated by commas (,). If empty, all columns will be loaded. Specifying a list without unnecessary columns may significantly improve performance.  
  Filter: Sets the name of the Filter web part that should be connected.  
   

  Selection options  
  Enable selected item: Indicates if the data source should support the selection of individual records from the custom table for viewing in detail mode.  
  Selected item querystring key name: Sets the name of the URL query string parameter used to determine which custom table record should be selected for detail view mode.  
  Selected item database column name: Sets which custom table field should be used to identify records for selection. This field must be a unique identifier.  
  Selected item validation type: Allows the selection of the type of validation that should be applied to the input of the query string parameter that determines custom table record selection.  
   

  System settings  
  Cache item name: Sets the name of the cache key used for the content of the web part. If not specified, this name is generated automatically based on the site, document path, Web part control ID and current user. A cache key can be shared between multiple web parts with the same content on different pages in order to avoid keeping redundant data in the memory.  
  Cache minutes: Sets the number of minutes for which the content of the web part should remain cached before its latest version is reloaded from the database. If left empty, the value entered into the Site Manager -> Settings -> System -> Performance -> Cache content (minutes) setting will be used instead. If set to 0, caching will be disabled for the web part.  
  Cache dependencies: Contains a list of cache keys on which the partial cache of the web part depends. When the specified cache items change, the partial cache of the web part is deleted. Each line may only contain a single item. If the Use default cache dependencies box is checked, the default dependencies will be used, which include all possible object changes that could affect the specific web part.  
   

Help URL: http://devnet.kentico.com/docs/webparts/index.html?CustomTableDataSource_properties.htm