|
|
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.
|
|
| | | |
|
|
Content
|
|
|
|
|
Query name:
|
Sets the name of the predefined SQL query that should be used to retrieve the data. Queries are specified in format <class name>.<query name>.
|
|
| | | |
|
|
Content filter
|
|
|
|
|
ORDER BY Expression:
|
Sets the value of the ORDER BY clause in the query used to retrieve data. For this property to be applied, the used query must have the ##ORDERBY## macro expression as the value of its ORDER BY clause.
|
|
|
|
Select top N documents:
|
Sets the maximum amount of items to be retrieved by the specified query. For this property to be applied, the used query must contain the ##TOPN## macro expression directly after its SELECT statement.
|
|
|
|
WHERE condition:
|
Sets the value of the WHERE clause in the query used to retrieve data. For this property to be applied, the used query must have the ##WHERE## macro expression as the value of its WHERE clause.
|
|
|
|
Selected columns:
|
Lists the columns (separated by commas) that should be loaded by the specified query. For this property to be applied, the used query must contain the ##COLUMNS## macro expression after its SELECT statement.
|
|
|
|
Filter:
|
Sets the name of the Filter web part that should be connected.
|
|
| | | |
|
|
System settings
|
|
|
|
|
Load pages individually:
|
If checked, the data source loads and caches individual pages from the database instead of loading the complete data of all pages at once. This property is used only if paging is enabled. Using this setting also requires the "Order by" property to be set.
|
|
|
|
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?QueryDataSource_properties.htm
