Datalist with custom query

  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 and in on-site editing mode. If empty, the value of the Web part control ID property is used for this purpose.  
   

  Visibility  
  Visible: Indicates if the web part should be displayed.  
  Hide on subpages: Indicates if the web part should be hidden on sub-pages. If checked, the web part will not be displayed on documents that inherit the web part from a parent document.  
  Show for document types: Contains a list of document types on which the web part should be displayed. If the currently selected document uses the page template containing this web part, but its type is not specified by this property, the web part will be hidden. The document types in the list must be specified by their code names and separated by semicolons (;). If empty, the web part will be displayed on all document types.  
  Display to roles: Contains a list of roles to which the web part should be displayed. This may be used to implement documents with specific functionality for different types of users. The roles in the list must be specified by their code names and separated by semicolons (;). If empty, the web part will be displayed to all users.  
   

  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: 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 name: Sets the name of the Filter web part that should be connected.  
   

  Transformations  
  Transformation: Sets the transformation used for the displayed content in list view mode. Transformations are specified in format <class name>.<transformation name>.  
  Alternating transformation: Sets the transformation used to display even items in list view mode. Transformations are specified in format <class name>.<transformation name>.  
   

  Layout  
  Repeat columns: Sets the number of columns into which the displayed items will be divided.  
  Repeat direction: Determines the direction in which items should be displayed when multiple columns are used - can be either vertical or horizontal.  
  Repeat layout: Allows the selection of the layout that should be used when displaying items. The available options are table or flow (no predefined structure).  
   

  Paging  
  Enable paging: Indicates if the displayed data should be paged.  
  Paging mode: Determines which method is used to pass information about the currently selected page - it can be passed either as a parameter in the URL (Query string) or through postback (Postback).  
  Navigation buttons: Indicates if the buttons used for navigating to the previous and next page should be displayed.  
  Pager position: Determines if the pager is displayed above or below the content displayed by the web part.  
  Page size: Determines the maximum number of records displayed per page.  
  Query string key: Sets the name of the URL parameter used to pass information about the current page number (used if the Paging mode property is set to Query string).  
  Show first and last buttons: Indicates if the buttons used for navigating to the first and last page should be displayed.  
  HTML before: Contains the HTML code placed on the page before the pager.  
  HTML after: Contains the HTML code placed on the page after the pager.  
  Results position: Allows the position of the paging results summary text to be selected.  
  Numbers separator: Contains the HTML code of a separator to be placed between the page number links.  
   

  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 contain a single item only. 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.  
   

  No data behavior  
  Hide if no record found: Indicates if the web part should be hidden when no items to be displayed are retrieved.  
  No record found text: Text that should be displayed if no records are found. This text will not be visible if the Hide if no record found property of the web part is enabled.  
   

  Editing buttons  
  Show edit and delete buttons: If enabled, the web part offers edit and delete buttons for each item when displaying the page in edit mode. You can set the exact position of the buttons by adding the ##editbuttons## macro into the code of the used item transformation (must be of the ASCX type).  
   

  Web part container  
  Web part container: Specifies the name of the container (box) to be displayed around the web part. Only containers defined in Site Manager -> Development -> Web part containers can be selected. The selected container can be edited directly by using the Edit button.  
  Container title: Sets a title for the container. This title is displayed only if the {%ContainerTitle%} macro is used in the code of the container.  
  Container CSS class: CSS class used for the container. Applied only if the {%ContainerCSSClass%} macro is used as the value of the Class attribute in the code of the container.  
  Container custom content: Custom content to be used in the container. Applied only if the {%ContainerCustomContent%} macro is used in the code of the container.  
  Hide container on subpages: Indicates if the web part container should be hidden on sub-pages.  
   

  HTML Envelope  
  Content before: HTML content placed before the web part. Can be used to display a header or add some encapsulating code, such as <div> or <table> elements to achieve the required layout.  
  Content after: HTML content placed after the web part. Can be used to display a footer or close the tags contained in the ContentBefore value, such as </div> or </table> elements.  
   

  AJAX  
  Use update panel: Indicates if an AJAX UpdatePanel container should be used for this web part.  
   

  Time zones  
  Time zone: Specifies the type of time zone used for the content of the web part.  
  Custom time zone: May be used to assign a custom time zone specifically for the content of this web part. If selected, the time zone will be used regardless of current user or website time zone settings.  
   

  Performance  
  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.  
  Partial cache minutes: Sets the number of minutes for which the output HTML code of the web part should remain cached. This process is similar to full-page caching, but only for the code of the web part specifically. If left empty or set to 0, partial caching will be not be used for the web part.  
  Partial 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 contain a single item only. 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.  
   

  Output filter  
  Filter output HTML of web part: If checked, the output code of this web part is processed by the output filters  
  Resolve URLs: If checked, the filter removes the "~" character in relative URLs and replace it with the root URL of the website.  
  Fix attributes: If checked, the filter ensures that all HTML tag attributes are in valid XHTML format.  
  Fix Javascript: If checked, the filter ensures that the type and language attributes are included in all <script> tags.  
  Fix lower case: If checked, the filter ensures that all HTML tags and attributes are generated in lower case.  
  Fix self closing tags: If checked, the filter ensures that HTML tags without end tags are properly closed.  
  Fix tags: If checked, the filter replaces tags that are not XHTML valid with appropriate equivalents (<strong> instead of <b>, <em> instead of <i>).  
  Fix HTML5: If checked, the filter replaces attributes that are obsolete in HTML5 with CSS classes named in format <attribute name>_<attribute value>. The affected attributes are: cellpadding, cellspacing, width, height, border, align, valign  
  Convert TABLE tags to DIV tags: If enabled, the TABLE tags in the output are automatically converted to DIV tags with CSS class corresponding to the tag name (table, tr, td, etc.) Blocks of HTML code can be optionally marked with class="_divs" or class="_nodivs" to allow or disable conversion for that particular block of code.  
   

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