5-1-3-2. Interface to Tables

DataTable classes can be extended by the page.ClassName, which can be changed by setting the property value in SkyVisualEditor Studio. For more details, please refer to the interface details.

Interface of data table class (ListItemHolder derivation class)

Name	Detail	Type
Items	List of column information	List<Data table column class>
add()	Add column

Interface of data-table column class (ListItem derivatation class)

Name	Detail	Type
Record	Actual data	sObject selected in data-table
Selected	Check box pressing Flag	Boolean
Remove	Delete column

The "where" and "order by" clauses in SOQL can be set to filter the table items. （Data-table, Multi column data-table）. However, this can also be achieved without resorting to advanced customization and we highly recommend utilizing the standard way of applying filters to a table.

The query information is stored in the Query class in a Map（MapVariable name：queryMap）. Thus, to change the table search condition, we need to retrieve the Query object from the Map.

Class having Query information

Name space	Class name
SkyEditor2	Query

The interface for the Query object is stated below. Search and filter conditions can be set with these interfaces.

Interface of data table class (Query derivation class)

Name	Argument		Content
addWhere	String Object WhereOperator	Field ID to add condition Value to add condition Operator to add condition	Set Where clause to add. See below for more details.
addWhereIfNotFirst	String	String to add	The string to combine where clauses. "AND" needs to be given as the adding string if the search condition is selected from SkyVisualEditor Studio's standard function.
addSort	String Boolean Boolean	Field ID for sort select sort order (true：ascending, false：descending) Null value position (true：top、false：end)	Select sort order for search result.