Screen Datatable
axScreenDataTable
Description
axScreenDataTable allows to embed a datatable into your screen. With axScreenDataTable , multiple pages of subfile records can be loaded into the screen datatable therefore allowing the user to view more records at the same time. Using the properties described below, the user can customize how the subfile records can be loaded.
By using this extension you will be subject to the Terms of Service as outlined in https://datatables.net/faqs/index#Licensing
Usability
|
Context |
Supported |
|---|---|
|
Input screen fields |
No |
|
Output screen fields |
No |
|
Input subfile fields |
No |
|
Output subfile fields |
No |
|
New screen elements |
Yes |
Properties
headerHeightRows
The number of rows in the subfile header.
Yes. Must be 1 - 24
1
|
Name |
Description and Comments |
JavaScript |
Shipped default |
|---|---|---|---|
| autoWidth | control DataTables' smart column width handling | No | False |
|
baseStyle |
Set base style using avaialable base style for datatable (display, hover,compact,stripe,order-column) |
No |
display hover compact stripe order-column. |
|
bodyFirstRow |
The first row of the subfile body. If 0, this means automatically determine the first row of the subfile body. |
Yes. Must be 1 - 24 |
0 |
|
bodyLastRow |
The last row of the subfile body. If 0, this means automatically determine the last row of the subfile body. |
Yes. Must be 1 - 24 |
0 |
|
buttons |
Define the buttons to show in the Datatable. Values can be 'copy', 'pdf', 'excel' |
Yes. Must retun an array of String. |
ENV.returnValue = []; |
| columnDefs |
Column definitions |
Yes |
ENV.returnValue=[]; |
| columnFirst |
The first column of the subfile |
Yes |
1 |
| columnLast |
The last column of the subfile |
Yes |
79 |
|
dom |
Define the table control elements to appear on the page and in what order. |
No |
Blftip |
|
initialNoOfPages |
The number of pages that will be loaded on the first display of the screen. |
Yes |
1 |
| language | Language configuration options for DataTables | Yes | ENV.returnValue = []; |
| lengthChange | control the end user's ability to change the paging display length of the table. | No | False |
| lengthMenu | Change the options in the page length select list. | Yes | ENV.returnValue = [ 10, 25, 50, 75, 100 ]; |
|
linesPerRow |
The number of screen lines that represent a row in the subfile. A value of 0 tells the eXtension to attempt to automatically determine the value. |
Yes |
0 |
|
loadFromFirstPage |
Indicates whether to load from the first page when the current page in the screen is not the first page. |
No |
False |
| order | Initial order (sort) to apply to the table. | Yes | ENV.returnValue = []; |
| ordering | control ordering (sorting) abilities in DataTables. | No. | False |
| paging | Enable or disable table pagination. | No | False |
| removeBlankColumns | Automatically remove blank or space only column | No | True |
| searching | control search (filtering) abilities | No | False |
| showinfo | Show information | No | False |
Notes, Comments and Warnings
To use this extension you must be familiar with Datatables. Information about Datatables can be found at: https://datatables.net/
