Column list is created automatically from SQL. To add a new column go to SQL tab, add column to query and press Apply.
Columns can be reordered using drag and drop.
Column properties:
Caption Column caption. Caption can contain HTML. When it starts with < symbol, text is treated as HTML and is not encoded.
Alignment text alignment in column cells
Width column width in any CSS unit
Type column data type. Affects sorting and alignment (when set to auto)
Format - display format for date and number fields. F.e. # ##0.## or dd-mm-yyyy
Local timezone - applies to date fields. Value will be converted to client timezone.
Server timezone (offset from UTC) is set at start and stored in TWebUIServer.TimezoneOffset. You can change it after server is created.
Template - column template. For example, to display an image, set template to
<img src="data:image/bitmap;base64,{{{Photo}}}"/>
Value - constant or expression (when starting with =) for calculating cell value. Example: = iif(price = 0, '-', price)
Color - CSS color or expression. Example: =iif(price < 0, 'red', 'black')
Background: CSS color or expression. Example: =iif(disabled='true', 'gray', 'white')
Example of using heatmap function:
Example of progressbar function:
Hint template: cell hint template.
Word wrap: cell text wrapping mode
Style - CSS style
Hidden - column is hidden
Row group - group table by this column (query should be sorted by group column field)
Editable - allow inline editing when pressing Enter.
Total - display column total - sum, min, max, avg.