%ZEN.Component.tablePane
deprecated class %ZEN.Component.tablePane extends %ZEN.Component.simpleTablePane
This component draws an HTML table based on the contents of a query.The data for the table can come from a pre-built class query, an SQL statement, or the tablePane can create an SQL query automatically.
The properties of the tablePane, as well as the auxiliary classes, %ZEN.Auxiliary.column, %ZEN.Auxiliary.condition, and %ZEN.Auxiliary.parameter, let you control the behavior and appearance of the tablePane.
Many of the characteristics of the tablePane are inherited from its superclass, %ZEN.Component.simpleTablePane. Refer to it for more details.
Property Inventory
- autoExecute
- bodyHeight
- caption
- cellSpacing
- clearSnapshot
- columns
- conditions
- currColumn
- currPage
- dataSource
- extraColumnWidth
- filtersDisabled
- fixedHeaders
- headerLayout
- invalidMessage
- lastUpdate
- msgNoResult
- nowrap
- onheaderClick
- onkeypress
- pageSize
- parameters
- permitClientSQL
- refreshRequired
- rowCount
- showFilters
- showQuery
- showValueInTooltip
- sortOrder
- suppressExceptionOnClientSQL
- unlockSession
- useKeys
- useSnapshot
- valueColumn
Method Inventory
- %AddColumn()
- %AddParameter()
- %CreateSnapshot()
- %DrawCell()
- %DrawFilter()
- %DrawHTML()
- %DrawTable()
- %IsTypeNumeric()
- %OnAddToPageAfter()
- %OnZENDeserialize()
- %ResetQuery()
- FetchRowFromSnapshot()
- addNavigator()
- appendColumn()
- applyFilters()
- disableColumnFilters()
- executeQuery()
- filterChanged()
- filterKeyPressed()
- firstPage()
- focus()
- getColumnFilters()
- getFilterValue()
- getInsideWidth()
- getPageCount()
- getRenderedRowData()
- getRowData()
- gotoPage()
- headerClick()
- lastPage()
- nextPage()
- onPopupAction()
- onloadHandler()
- packRows()
- packRowsIE()
- previousPage()
- removeNavigator()
- resetColumnFilters()
- resizeHeaders()
- setColumnFilters()
- setDateFilter()
- setFilterValue()
- setOffsetWidth()
- setProperty()
- showColumnFilters()
- showDateSelector()
- tpKeyDownHandler()
- tpKeyPressHandler()
Parameters
parameter DOMAIN = %ZEN;
parameter SYSMODULE = table;
Inherited description: If set, this indicates that this system component should be
placed in the given "module". A module is a grouping of components
within the same class package that share common include (js or css) files.
Note that certain root classes are implicitly placed within the "core"
module.
Classes outside of the Zen library should not set this, they should use the MODULE instead.
Classes outside of the Zen library should not set this, they should use the MODULE instead.
Properties
property autoExecute as %ZEN.Datatype.boolean [ InitialExpression = 1 ];
If true (the default), automatically re-execute the query for this
table when the user changes the value of a column filter.
If false, the query will only be re-executed when the executeQuery() is called.
If false, the query will only be re-executed when the executeQuery() is called.
Property methods: autoExecuteDisplayToLogical(), autoExecuteGet(), autoExecuteIsValid(), autoExecuteLogicalToDisplay(), autoExecuteLogicalToOdbc(), autoExecuteLogicalToXSD(), autoExecuteNormalize(), autoExecuteSet(), autoExecuteXSDToLogical()
property bodyHeight as %ZEN.Datatype.length;
If present, this specifies the height
of the body section of the table.
Property methods: bodyHeightDisplayToLogical(), bodyHeightGet(), bodyHeightIsValid(), bodyHeightLogicalToDisplay(), bodyHeightLogicalToOdbc(), bodyHeightNormalize(), bodyHeightSet()
Caption displayed for this table using the HTML caption element.
This is a localized value.
This is a localized value.
Property methods: captionDisplayToLogical(), captionGet(), captionIsValid(), captionLogicalToDisplay(), captionLogicalToOdbc(), captionNormalize(), captionSet()
property cellSpacing as %ZEN.Datatype.integer [ InitialExpression = 0 ];
Amount of spacing around cells in the table. The default is 0 (no extra space around table cells).
For a slight but noticeable separation, a useful value is 2.
Property methods: cellSpacingDisplayToLogical(), cellSpacingGet(), cellSpacingIsValid(), cellSpacingLogicalToDisplay(), cellSpacingLogicalToOdbc(), cellSpacingNormalize(), cellSpacingSet()
property clearSnapshot as %ZEN.Datatype.boolean (XMLPROJECTION = "none", ZENSETTING = 0) [ InitialExpression = 0 ];
Client-side, run-time flag that is set when client wants to force
re-execution of the table query when the table is in "snapshot" mode.
Property methods: clearSnapshotDisplayToLogical(), clearSnapshotGet(), clearSnapshotIsValid(), clearSnapshotLogicalToDisplay(), clearSnapshotLogicalToOdbc(), clearSnapshotLogicalToXSD(), clearSnapshotNormalize(), clearSnapshotSet(), clearSnapshotXSDToLogical()
property columns as list of %ZEN.Auxiliary.column (XMLPROJECTION = "ELEMENT", XMLREF = 1, XMLTYPECONSTRAINT = "CHOICE");
List of column information objects.
Each object specifies additional details about a column in the table.
Each object specifies additional details about a column in the table.
Property methods: columnsBuildValueArray(), columnsCollectionToDisplay(), columnsCollectionToOdbc(), columnsDisplayToCollection(), columnsGet(), columnsGetObject(), columnsGetObjectId(), columnsGetSwizzled(), columnsIsValid(), columnsOdbcToCollection(), columnsSet(), columnsSetObject(), columnsSetObjectId()
property conditions as list of %ZEN.Auxiliary.condition (XMLPROJECTION = "ELEMENT", XMLREF = 1, XMLTYPECONSTRAINT = "CHOICE");
A list of conditions. These are special expression objects that
are evaluated to add data-dependent styles to the table.
Property methods: conditionsBuildValueArray(), conditionsCollectionToDisplay(), conditionsCollectionToOdbc(), conditionsDisplayToCollection(), conditionsGet(), conditionsGetObject(), conditionsGetObjectId(), conditionsGetSwizzled(), conditionsIsValid(), conditionsOdbcToCollection(), conditionsSet(), conditionsSetObject(), conditionsSetObjectId()
property currColumn as %ZEN.Datatype.string (ZENEXPRESSION = 1);
This is the logical name of the most recently selected column
header. Typically this is used for sorting.
Property methods: currColumnDisplayToLogical(), currColumnGet(), currColumnIsValid(), currColumnLogicalToDisplay(), currColumnLogicalToOdbc(), currColumnNormalize(), currColumnSet()
property currPage as %ZEN.Datatype.integer [ InitialExpression = 1 ];
For snapshot mode, this is the number (1-based) of the current "page" within the snapshot
that is displayed.
Property methods: currPageDisplayToLogical(), currPageGet(), currPageIsValid(), currPageLogicalToDisplay(), currPageLogicalToOdbc(), currPageNormalize(), currPageSet()
property dataSource as %ZEN.Datatype.string (VALUELIST = ",query,columns") [ InitialExpression = "query" ];
Specifies where the data columns of the table come from.
"query" (the default)- columns are displayed for each column in the data source query.
"columns" - only columns explicitly defined in the columns list are displayed.
"query" (the default)- columns are displayed for each column in the data source query.
"columns" - only columns explicitly defined in the columns list are displayed.
Property methods: dataSourceDisplayToLogical(), dataSourceGet(), dataSourceIsValid(), dataSourceLogicalToDisplay(), dataSourceLogicalToOdbc(), dataSourceNormalize(), dataSourceSet()
property extraColumnWidth as %ZEN.Datatype.length [ InitialExpression = 30 ];
Width used for extra columns, such as row number, row selector, etc.
Property methods: extraColumnWidthDisplayToLogical(), extraColumnWidthGet(), extraColumnWidthIsValid(), extraColumnWidthLogicalToDisplay(), extraColumnWidthLogicalToOdbc(), extraColumnWidthNormalize(), extraColumnWidthSet()
property filtersDisabled as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
If true, disable column filters (if any).
Property methods: filtersDisabledDisplayToLogical(), filtersDisabledGet(), filtersDisabledIsValid(), filtersDisabledLogicalToDisplay(), filtersDisabledLogicalToOdbc(), filtersDisabledLogicalToXSD(), filtersDisabledNormalize(), filtersDisabledSet(), filtersDisabledXSDToLogical()
property fixedHeaders as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
If true, then the header of the table will stay in position when the body
of the table is scrolled.
Property methods: fixedHeadersDisplayToLogical(), fixedHeadersGet(), fixedHeadersIsValid(), fixedHeadersLogicalToDisplay(), fixedHeadersLogicalToOdbc(), fixedHeadersLogicalToXSD(), fixedHeadersNormalize(), fixedHeadersSet(), fixedHeadersXSDToLogical()
property headerLayout as %ZEN.Datatype.string (VALUELIST = ",filtersOnTop,headersOnTop") [ InitialExpression = "filtersOnTop" ];
This property controls how to display the table header when
column filters are used.
- "filtersOnTop" - (the default) Display column filters above column headers.
- "headersOnTop" - Display column headers above filters.
Property methods: headerLayoutDisplayToLogical(), headerLayoutGet(), headerLayoutIsValid(), headerLayoutLogicalToDisplay(), headerLayoutLogicalToOdbc(), headerLayoutNormalize(), headerLayoutSet()
property invalidMessage as %ZEN.Datatype.caption [ InitialExpression = $$$Text("Invalid Date","%ZEN") ];
Localized "invalid date" message displayed by control.
Property methods: invalidMessageDisplayToLogical(), invalidMessageGet(), invalidMessageIsValid(), invalidMessageLogicalToDisplay(), invalidMessageLogicalToOdbc(), invalidMessageNormalize(), invalidMessageSet()
property lastUpdate as %ZEN.Datatype.string (XMLPROJECTION = "none");
Time, in ODBC timestamp format, that the query for this table
was last executed. This is set on the server whenever the query is
for the tablePane is executed.
Property methods: lastUpdateDisplayToLogical(), lastUpdateGet(), lastUpdateIsValid(), lastUpdateLogicalToDisplay(), lastUpdateLogicalToOdbc(), lastUpdateNormalize(), lastUpdateSet()
property msgNoResult as %ZEN.Datatype.caption [ InitialExpression = $$$Text("No Results","%ZEN") ];
Property methods: msgNoResultDisplayToLogical(), msgNoResultGet(), msgNoResultIsValid(), msgNoResultLogicalToDisplay(), msgNoResultLogicalToOdbc(), msgNoResultNormalize(), msgNoResultSet()
property nowrap as %ZEN.Datatype.boolean [ InitialExpression = 1 ];
If a browser does not support CSS nowrap correctly, this flag provides
a way to control whether table cells allow word wrapping or not.
Property methods: nowrapDisplayToLogical(), nowrapGet(), nowrapIsValid(), nowrapLogicalToDisplay(), nowrapLogicalToOdbc(), nowrapLogicalToXSD(), nowrapNormalize(), nowrapSet(), nowrapXSDToLogical()
property onheaderClick as %ZEN.Datatype.eventHandler;
onheaderClick event handler:
This event is fired when the user clicks on a column header.
The name of the column will be in the currColumn property.
Property methods: onheaderClickDisplayToLogical(), onheaderClickGet(), onheaderClickIsValid(), onheaderClickLogicalToDisplay(), onheaderClickLogicalToOdbc(), onheaderClickNormalize(), onheaderClickSet()
property onkeypress as %ZEN.Datatype.eventHandler;
onkeypress event handler:
If useKeys is true, then this event handler
code is run when the user presses a key within the tablePane.
Property methods: onkeypressDisplayToLogical(), onkeypressGet(), onkeypressIsValid(), onkeypressLogicalToDisplay(), onkeypressLogicalToOdbc(), onkeypressNormalize(), onkeypressSet()
property pageSize as %ZEN.Datatype.integer [ InitialExpression = 0 ];
This is the number of items to display on
a single "page" of the table.
0, the default, means show all data on first page.
This can only be set to a non-zero value when the table
is in snapshot mode.
Property methods: pageSizeDisplayToLogical(), pageSizeGet(), pageSizeIsValid(), pageSizeLogicalToDisplay(), pageSizeLogicalToOdbc(), pageSizeNormalize(), pageSizeSet()
property parameters as list of %ZEN.Auxiliary.parameter (XMLNAME = "parameter", XMLPROJECTION = "ELEMENT", XMLREF = 1);
User-defined list of parameters. These values are passed on
to the user callback function that provides the query for this table.
Property methods: parametersBuildValueArray(), parametersCollectionToDisplay(), parametersCollectionToOdbc(), parametersDisplayToCollection(), parametersGet(), parametersGetObject(), parametersGetObjectId(), parametersGetSwizzled(), parametersIsValid(), parametersOdbcToCollection(), parametersSet(), parametersSetObject(), parametersSetObjectId()
property permitClientSQL as %ZEN.Datatype.boolean (ZENENCRYPT = 1, ZENEXPRESSION = 1) [ InitialExpression = 0 ];
Flag for backwards compatibility.
If permitClientSQL is set to true, query parameters
may be set programatically through javascript on the client, depending on
site and application settings this may constitute a security risk. If set
to false (the default), the parameters may only be set on the server. This
property is encrypted and any attempt to modify it on the client will result
in an error.
Property methods: permitClientSQLDisplayToLogical(), permitClientSQLGet(), permitClientSQLIsValid(), permitClientSQLLogicalToDisplay(), permitClientSQLLogicalToOdbc(), permitClientSQLLogicalToXSD(), permitClientSQLNormalize(), permitClientSQLSet(), permitClientSQLXSDToLogical()
property refreshRequired as %ZEN.Datatype.boolean (XMLPROJECTION = "none", ZENSETTING = 0) [ InitialExpression = 0 ];
This property should be set to 1 by server-side methods that want to force
the query associate with the tablePane to be re-executed.
Property methods: refreshRequiredDisplayToLogical(), refreshRequiredGet(), refreshRequiredIsValid(), refreshRequiredLogicalToDisplay(), refreshRequiredLogicalToOdbc(), refreshRequiredLogicalToXSD(), refreshRequiredNormalize(), refreshRequiredSet(), refreshRequiredXSDToLogical()
property rowCount as %ZEN.Datatype.string (XMLPROJECTION = "none", ZENSETTING = 0);
If present, this is the number of rows returned by the current
query. This is calculated by the built-in query or the
automatic query.
Note: this is a string as it could be set to "" or "100+".
Note: this is a string as it could be set to "" or "100+".
Property methods: rowCountDisplayToLogical(), rowCountGet(), rowCountIsValid(), rowCountLogicalToDisplay(), rowCountLogicalToOdbc(), rowCountNormalize(), rowCountSet()
property showFilters as %ZEN.Datatype.boolean [ InitialExpression = 1 ];
If true, display column filters (if any).
Property methods: showFiltersDisplayToLogical(), showFiltersGet(), showFiltersIsValid(), showFiltersLogicalToDisplay(), showFiltersLogicalToOdbc(), showFiltersLogicalToXSD(), showFiltersNormalize(), showFiltersSet(), showFiltersXSDToLogical()
property showQuery as %ZEN.Datatype.boolean (ZENENCRYPT = 1, ZENEXPRESSION = 1) [ InitialExpression = 0 ];
Server-side diagnostic flag. If true, display the query used
to get data for this table.
This is an encrypted value and cannot be set on the client.
This is an encrypted value and cannot be set on the client.
Property methods: showQueryDisplayToLogical(), showQueryGet(), showQueryIsValid(), showQueryLogicalToDisplay(), showQueryLogicalToOdbc(), showQueryLogicalToXSD(), showQueryNormalize(), showQuerySet(), showQueryXSDToLogical()
property showValueInTooltip as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
If true, then the tooltip (HTML title attribute) displayed
for cells within the table will display the current value of the cell.
Property methods: showValueInTooltipDisplayToLogical(), showValueInTooltipGet(), showValueInTooltipIsValid(), showValueInTooltipLogicalToDisplay(), showValueInTooltipLogicalToOdbc(), showValueInTooltipLogicalToXSD(), showValueInTooltipNormalize(), showValueInTooltipSet(), showValueInTooltipXSDToLogical()
property sortOrder as %ZEN.Datatype.string (VALUELIST = ",asc,desc", ZENEXPRESSION = 1);
For sortable tables, this is the order to sort values within the
current column. Values can be "", "asc" (ascending), or "desc" (descending).
Property methods: sortOrderDisplayToLogical(), sortOrderGet(), sortOrderIsValid(), sortOrderLogicalToDisplay(), sortOrderLogicalToOdbc(), sortOrderNormalize(), sortOrderSet()
property suppressExceptionOnClientSQL as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
Flag for less intrusive remedial action when Client-side SQL modification is forbidden.
If permitClientSQL is set to false (the default), this flag controls
the rendering of the table if client side modification of the query parameters is detected.
By default, a Zen Exception will be raised, warning of the security risk. If this flag is set
to true, however, the exception will be suppressed and the table will re-render using the last
known (server-side) values for the query parameters. In this case the client-side modifications
are simply ignored. The default value is "false" indicating that the exception should be raised.
Property methods: suppressExceptionOnClientSQLDisplayToLogical(), suppressExceptionOnClientSQLGet(), suppressExceptionOnClientSQLIsValid(), suppressExceptionOnClientSQLLogicalToDisplay(), suppressExceptionOnClientSQLLogicalToOdbc(), suppressExceptionOnClientSQLLogicalToXSD(), suppressExceptionOnClientSQLNormalize(), suppressExceptionOnClientSQLSet(), suppressExceptionOnClientSQLXSDToLogical()
property unlockSession as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
Flag to control whether session is unlocked during updates to the table.
Property methods: unlockSessionDisplayToLogical(), unlockSessionGet(), unlockSessionIsValid(), unlockSessionLogicalToDisplay(), unlockSessionLogicalToOdbc(), unlockSessionLogicalToXSD(), unlockSessionNormalize(), unlockSessionSet(), unlockSessionXSDToLogical()
property useKeys as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
If true, then the tablePane will capture user keystrokes and use them
for simple table navigation.
Property methods: useKeysDisplayToLogical(), useKeysGet(), useKeysIsValid(), useKeysLogicalToDisplay(), useKeysLogicalToOdbc(), useKeysLogicalToXSD(), useKeysNormalize(), useKeysSet(), useKeysXSDToLogical()
property useSnapshot as %ZEN.Datatype.boolean [ InitialExpression = 0 ];
If true, create a temporary snapshot of the query results.
This allows for paging and sorting without re-executing the query.
Property methods: useSnapshotDisplayToLogical(), useSnapshotGet(), useSnapshotIsValid(), useSnapshotLogicalToDisplay(), useSnapshotLogicalToOdbc(), useSnapshotLogicalToXSD(), useSnapshotNormalize(), useSnapshotSet(), useSnapshotXSDToLogical()
property valueColumn as %ZEN.Datatype.string;
If defined, this is the name of the data column that provides
a logical value for a selected row.
Property methods: valueColumnDisplayToLogical(), valueColumnGet(), valueColumnIsValid(), valueColumnLogicalToDisplay(), valueColumnLogicalToOdbc(), valueColumnNormalize(), valueColumnSet()
Methods
method %AddColumn(pColumn As %ZEN.Auxiliary.column = "") as %ZEN.Auxiliary.column
Add a new column definition to this tablePane.
If pColumn is not provided, this method will create
a new column object.
method %AddParameter(pParm As %ZEN.Auxiliary.parameter = "") as %ZEN.Auxiliary.parameter
Add a new parameter definition to this tablePane.
If pParm is not provided, this method will create
a new parameter object.
method %CreateSnapshot(pTempID As %String, pRS As %ResultSet) as %Status
Create a temporary snapshot file from a result set.
Assumes that result set has been created and executed.
Users should not call this method.
Invoke user method to provide contents for a cell
method %DrawFilter(pMethod As %String, pName As %String, pColInfo As %ZEN.Auxiliary.column) as %Status
Invoke user method to provide contents for a column filter.
method %DrawHTML()
Draw innerHTML for this component (without enclosing div).
method %DrawTable(pRS As %ResultSet) as %Status
Draw the table.
Tests if a column type is a numeric type.
Zen uses the CLIENTDATATYPE value, not ODBCTYPE. Client types are defined as:
Returns the type of column n in the result set where type is an integer associated with
the client datatype. If the type cannot be determined, 0 (zero) is returned.
1 | BINARY | |
2 | DATE | |
3 | DOUBLE | |
4 | HANDLE | |
5 | INTEGER | |
6 | LIST | |
7 | LONGVARCHAR | |
8 | TIME | |
9 | TIMESTAMP | |
10 | VARCHAR | |
11 | STATUS | |
12 | BINARYSTREAM | |
13 | CHARACTERSTREAM | |
14 | NUMERIC | |
15 | CURRENCY | |
16 | BOOLEAN | |
17 | OID | |
18 | BIGINT | |
19 | FDATE | |
20 | FTIMESTAMP |
method %OnAddToPageAfter() as %Status
Inherited description: If implemented, this callback method is called at page render-time
after this component has been added to a page and after any of its children
have been created but before the %DrawHTML methods are called.
method %OnZENDeserialize() as %Status
This callback is invoked by the %ZENDeserialize method.
method %ResetQuery() as %Status
This method is used (server-side only) to set the refreshRequired
property when changing the underlying query from ObjectScript at
run time. Client-side code should not "wrap" and call this
function. Instead, JavaScript code should make use of the
refreshTable() method.
classmethod FetchRowFromSnapshot(pIndex As %Integer, pID As %String, pRow As %Integer, pCurrColumn As %String = "", pSortOrder As %String = "") as %Boolean [ ZenMethod ]
Internal method.
Fetch data from snapshot global and package up as a client object. pIndex is index of client component.
pID is internal ID of snapshot global.
pRow is row number to fetch.
Fetch data from snapshot global and package up as a client object. pIndex is index of client component.
pID is internal ID of snapshot global.
pRow is row number to fetch.
Associate a navigator component with this tablePane.
This is called by the navigator component.
clientmethod appendColumn(colName) [ Language = javascript ]
Appends new column object to this table with the given
column name. Returns the new column object.
Call the executeQuery() method after calling this to update the table.
Call the executeQuery() method after calling this to update the table.
clientmethod applyFilters() [ Language = javascript ]
If we are in autoExecute mode, then re-execute the query
for this table using the current value of any column filters.
If we are not in autoExecute mode, then do nothing.
clientmethod disableColumnFilters(flag) [ Language = javascript ]
Disable (or enable) the column filters for this table.
clientmethod executeQuery(remember, sync) [ Language = javascript ]
Force query for this table to be executed on the server.
If the table is in snapshot mode, then a new snapshot will
be created.
If remember is true, then the table will stay on the same page after the new results are displayed. If sync is defined and is true, the refresh will be executed synchronously (unless we are in deferred mode).
If remember is true, then the table will stay on the same page after the new results are displayed. If sync is defined and is true, the refresh will be executed synchronously (unless we are in deferred mode).
clientmethod filterChanged(filterName, refresh, type, index) [ Language = javascript ]
User has changed the value of a filter.
filterName is the name of the filter.
refresh indicates if the query should be re-executed.
type (optional) is type of filter.
index (optional) is control index for filters with multiple controls.
refresh indicates if the query should be re-executed.
type (optional) is type of filter.
index (optional) is control index for filters with multiple controls.
clientmethod filterKeyPressed(evt, filterName, type, index) [ Language = javascript ]
User has pressed a key within a filter.
clientmethod firstPage() [ Language = javascript ]
For multi-page display, go to the first page.
clientmethod focus() [ Language = javascript ]
Client-side method to input focus to this control.
clientmethod getColumnFilters() [ Language = javascript ]
Get column filters (if there are any).
Returns an associative array containing the current
values of the filter controls indexed by column name.
clientmethod getFilterValue(cname) [ Language = javascript ]
Get current value of column filter associated with column cname.
clientmethod getInsideWidth(element) [ Language = javascript ]
clientmethod getPageCount() [ Language = javascript ]
For multi-page display, calculate the number of pages.
clientmethod getRenderedRowData(row) [ Language = javascript ]
Explore the DOM and extract the data for the specified phyiscal table row
(0-based) from the rendered table data (not to be confused with
the logical row number of the data itself in a multi-page table).
This data is packaged into a JavaScript object whose properties correspond to the names of the columns in the table. If showRowNumbers is true the object will also contain a property called rowNum and will be contain the logical, enumerated row of the result set record
This is a client-side only call and can query only the values of the current page of the current table. The full, logical contents of the table (in snapshot mode) resides at the server and logical rows may be accessed using getRowData()
If there are not data columns to report or if the requested row is greater than the page size for the table, this function returns null.
This data is packaged into a JavaScript object whose properties correspond to the names of the columns in the table. If showRowNumbers is true the object will also contain a property called rowNum and will be contain the logical, enumerated row of the result set record
This is a client-side only call and can query only the values of the current page of the current table. The full, logical contents of the table (in snapshot mode) resides at the server and logical rows may be accessed using getRowData()
If there are not data columns to report or if the requested row is greater than the page size for the table, this function returns null.
clientmethod getRowData(row) [ Language = javascript ]
For tables in snapshot mode only.
Go to the server and fetch the data for the specified row (0-based) from the table snapshot data. This data is packaged into a JavaScript object whose properties correspond to the names of the columns in the snapshot table.
For non-snapshot tables or out of range row numbers, returns null.
Go to the server and fetch the data for the specified row (0-based) from the table snapshot data. This data is packaged into a JavaScript object whose properties correspond to the names of the columns in the snapshot table.
For non-snapshot tables or out of range row numbers, returns null.
clientmethod gotoPage(page) [ Language = javascript ]
For multi-page display, go to specified page (1 is first page), if possible.
clientmethod headerClick(name) [ Language = javascript ]
User has clicked on a column header.
clientmethod lastPage() [ Language = javascript ]
For multi-page display, go to the last page.
clientmethod nextPage(giveFocus) [ Language = javascript ]
For multi-page display, go to next page, if possible.
clientmethod onPopupAction(popupName, action, value) [ Language = javascript ]
Inherited description: This client event, if present, is fired when a popup page has specified
this component as its parent and fires an action.
popupName is the name of the popup window sending the action.
action is the name of the action.
value is the value associated with the action.
popupName is the name of the popup window sending the action.
action is the name of the action.
value is the value associated with the action.
clientmethod onloadHandler() [ Language = javascript ]
When the page is loaded, check for alignment issues between the table header
and the table body.
clientmethod packRows() [ Language = javascript ]
clientmethod packRowsIE() [ Language = javascript ]
clientmethod previousPage(giveFocus) [ Language = javascript ]
For multi-page display, go to previous page, if possible.
If giveFocus is true, then give focus back to
the hidden control.
Remove the navigator component with this tablePane.
This is called by the navigator component.
clientmethod resetColumnFilters() [ Language = javascript ]
Reset the values of the column filters (if there are any).
clientmethod resizeHeaders() [ Language = javascript ]
clientmethod setColumnFilters(state) [ Language = javascript ]
Set the value of all column filters (if there are any).
state is an associative array containing the current
values of the filter controls indexed by column name (as
returned by getColumnFilters().
clientmethod setDateFilter(group) [ Language = javascript ]
Set value of date filter box. index is 0 or 1 to indicate
which date box to set.
clientmethod setFilterValue(cname, value) [ Language = javascript ]
Set the value of column filter associated with column cname.
clientmethod setOffsetWidth(element, width) [ Language = javascript ]
clientmethod setProperty(property, value, value2) [ Language = javascript ]
Set the value of a named property.
clientmethod showColumnFilters(flag) [ Language = javascript ]
Show or hide columns filters (if there are any).
Users should use setProperty('showFilters',true) instead.
clientmethod showDateSelector(cname, index, type, minDate, maxDate) [ Language = javascript ]
Display date selector for a date filter box.
clientmethod tpKeyDownHandler(evt) [ Language = javascript ]
Process key down event within the table's invisible edit control.
clientmethod tpKeyPressHandler(evt) [ Language = javascript ]
Process key press event within the table's invisible edit control.
Inherited Members
Inherited Properties
- %condition
- %import
- %includeFiles
- %page
- %resource
- OnCreateResultSet
- OnExecuteResultSet
- align
- aux
- columnName
- composite
- containerStyle
- countRows
- dragEnabled
- dropEnabled
- enableToggleSelect
- enclosingClass
- enclosingStyle
- error
- groupByClause
- height
- hidden
- hint
- hintClass
- hintStyle
- id
- index
- initialExecute
- label
- labelClass
- labelDisabledClass
- labelStyle
- maxRows
- multiSelect
- name
- onafterdrag
- onbeforedrag
- ondblclick
- ondrag
- ondrop
- onhide
- onmouseoverClass
- onmultiselect
- onrefresh
- onselectrow
- onshow
- onunselectrow
- onupdate
- orderByClause
- parent
- queryClass
- queryName
- rowSelect
- selectedIndex
- selectedRows
- showLabel
- showRowNumbers
- showRowSelector
- showZebra
- slice
- sql
- tableName
- title
- tuple
- valign
- value
- visible
- whereClause
- width
- window
Inherited Methods
- %AddToSaveSet()
- %Attr()
- %BindExport()
- %ClassIsLatestVersion()
- %ClassName()
- %ConstructClone()
- %CreateResultSet()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %DrawComponentHTML()
- %DrawJSStrings()
- %EnclosingDivId()
- %Eval()
- %EvalC()
- %Extends()
- %ForceClientRender()
- %GetEventHandlers()
- %GetParameter()
- %GetXMLName()
- %IsA()
- %IsModified()
- %MakeId()
- %New()
- %NormalizeObject()
- %ObjectModified()
- %OnAddToPageBefore()
- %OnCreateResultSet()
- %OnDrawEnclosingDiv()
- %OnDrawObjectProperties()
- %OnExecuteResultSet()
- %OnObjectSynch()
- %OriginalNamespace()
- %PackageName()
- %QuoteValue()
- %QuoteValueL10N()
- %RemoveFromSaveSet()
- %Self()
- %SerializeObject()
- %SetModified()
- %ValidateObject()
- XMLDTD()
- XMLExport()
- XMLExportToStream()
- XMLExportToString()
- XMLNew()
- XMLSchema()
- XMLSchemaNamespace()
- XMLSchemaType()
- dragFinishHandler()
- dragHandler()
- dragNotifyHandler()
- dragStartHandler()
- dropHandler()
- dropStartHandler()
- exposeComponent()
- findElement()
- fireOnUpdateEvent()
- getEnclosingDiv()
- getHidden()
- getHintElement()
- getLabelElement()
- getProperty()
- getSettings()
- getType()
- getValue()
- invokeSuper()
- isOfType()
- isRowSelected()
- makeId()
- onCreate()
- onDelete()
- onEndModalHandler()
- onSerialize()
- onStartModalHandler()
- onmouseHandler()
- onunloadHandler()
- refreshContents()
- render()
- renderContents()
- renderSVG()
- selectAllMultiRows()
- selectMultiRow()
- selectRow()
- setHidden()
- setOverlayMode()
- startProgressBar()
- stopProgressBar()