You can choose OrderSort or Hyperlink as sort controls. The OrderSort control is a dropdown list consisting of all the sortable column names preceded by the keyword “Asc” or “Desc”, which is used to sort the current table. The blank entry will only be available when there are blank or null values. The filter will show all the names of companies in the database and if there are some records that do not have a Company Name, then a blank line will be inserted in the filter so that you can display those records that have a blank/null company name in the database. For example, you may have a Customer table and showing a filter of Company Names.
This value is only shown when there are NULL values in the underlying database field to which the filter applies. You may see a blank line shown in various dropdown list filters in your application. This option, if enabled, ads various filter controls to the panel. Application users may regard this behavior as unexpected data loss, and you may consider disabling column sorting if this behavior is not desirable. However, sorting an Edit Table panel containing unsaved data will cause that data to be lost. You can selectively enable sorting in Edit Table panels as well as Table Report panels. In particular, Microsoft SQL Server columns of type “text” and “ntext” cannot be sorted. Certain underlying database field types, such as very large object fields and binary fields are not sortable. This option, available for Table Report and Edit Table panels, enables or disables column sorting for the designated column. Table Filtering and Sorting Configuration Table FilteringĪdd table component filtering and sorting.
0 kommentar(er)
