(9)-b-1. Light Data Table

  

Here are all the properties and their detail. 

Property Name

Detail

Common Property



ID

Component ID defined in SkyVisualEditor

Object Label

Shows label name and API name of object

Relation Field Label

Shows label name of parent child object and lookup relation field

Relation Field API Name

Shows API name of parent-child object and lookup relation field

varVariable used within the Visualforce to show Table Data Collection

Layout









Adjust Page

Set the table wide to the page width. This property is active when Output Tag is set as DataTable.

Left(X)

Set horizontal position on the screen on the free layout.

Top(Y)

Set vertical position on the screen on the free layout.

Width[px]

Set the width of the DataTable in pixels.

“Adjust page” should be set to off to use this property.

Height[px]

Select to define a row height for the table.
When unchecked, the table will stretch to dynamically meet the necessary height of the contained values.

Appearance

    

Columns

Set the number of columns in the table.

Selectable from 1 to 40

Max Record Count

Shows the maximum record number. (input range: 1~1000)

Defaulted at 500 rows.

Table FeaturesShow RowCountSet to show or hide a number of records in the table. 
Sort

Activate the sorting feature for tables.

Default setting: Checked on (Activated)

Paging

Allow the user to page through many results

We recommend you to use paging for DataTables with very large numbers of records.

Show Rows

When paging is active, select the number of records to show in one page from below.

5,10,25,50,100

This property is only available when paging is active.

Reorder ColumnAllow users to swap rows after deploying a page.
Add Button Location

Set active or Inactive for add row function  and the location of button

The button appears when it is set as ‘Top&Bottom’ , ‘Top’ or ‘Bottom’ and the user has the permission to edit the page of Salesforce (the Visible column checked, the Read Only column unchecked)

Add Row PageSet Visualforce page to add row
Auto Close

The dialog of "Add Row Page" automatically closes after save.

Add Row Page Size Setting

Set Dialog page size on opening Add Row Page

Add Row Page Width

It is changeable when ‘Add Row page size setting’ is checked.  

Pixel can be set when no unit is set. (Exapmle: 800) Set unit to define size on the unit (Exapmle: 90%, 130em )

Add Row Page Size Width

It is changeable when ‘Add Row page size setting’ is checked.  

Pixel can be set when no unit is set. (Exapmle: 800) Set unit to define size on the unit (Exapmle: 90%, 130em )

Edit Add Row Button Value

Select to edit ‘Add Row button value’

Add Row Button Value

Value will be changeable when ‘Edit Add Row Button Value’ checked. Default Value is ‘Add Row’

Delete Row Button True


Set to show Delete Row Button

 This enables to delete record data shown in the Salesforce page.

Delete Confirm

Set to show a confirm dialog when delete button is clicked

  • Checked:show
  • Non-checked :not show
Edit Delete Button ValueSelect to edit Delete Button Value
Delete Button Value

Value will be changeable when 'Edit Delete Button Value' is checked. Default Value is 'Delete'

Show Detail Button True

Setting to show Detail Button

This enables to edit record data in the Salesforce page

Detail Page

Set Visualforce page to use on the detail

Detail Page Size Setting

Set a size of dialog page on opening the detail page

Detail Page Width

Value will be changeable when ‘Set Detail Page Size’ is checked
Pixel can be set when no unit is set. (Example:800) Define unit to set a size (Eample:90%, 130em)

Detail Page Height

Value will be changeable when ‘Set Detail Page Size’ is checked
Pixel can be set when no unit is set. (Example:800) Define unit to set a size (Eample:90%, 130em)

Edit Show Detail Button Value

Select to edit ‘Detail Show Button Value’

Show Detail Button Value

Value can be changeable when ‘ Edit Detail Show Button Value’ is checked. The Default Value is ‘Show Detail’.

Client Side FilterSearch Textbox will be added to the table for partial match search. Refer to < (5) Search box for Table >

This property appears when ‘Retain Search Result’ is Server Side

Advanced Table FeaturesWhere Clause FilterWhere Clause Filter can be set to the table
Refer to (1) Table Condition Setting for more information