ReportWidget

parasql.widget. ReportWidget

The ReportWidget class is used for reports, selection lists, and pick lists. Note that the object on a pick list panel is also a ReportWiget and selecting it will show its widget ID on the toolbar.

Extends

Methods

clearRecords()

Clears all rows in this.dataTable.

Description:

  • Clears all rows in this.dataTable. If the transaction set is dirty the user is prompted to save before clearing.

Overrides:

clearRecordsDiscardChanges()

Clears all rows in this.dataTable.

Description:

  • Clears all rows in this.dataTable. If the transaction set is dirty the changes are silently discarded.

Overrides:

clearSelection()

Clears the current row selection.

Description:

  • Clears the current row selection.

getActiveQuery() → {parasql.widget.util.Query}

Overrides:
Returns:

The currently active query object, or null if there is no active query.

Type
parasql.widget.util.Query

getDataTable() → {parasql.schema.DataTable}

Overrides:
Returns:

The DataTable containing the data for this object.

Type
parasql.schema.DataTable

getFirstValue(tableName, columnName) → (nullable) {parasql.schema.DataValue}

Overrides:
Parameters:
Name Type Description
tableName string
columnName string
Returns:

The value of the specified field in the first visible record, or null if there is no such record. The first visible record is determined by this object's cursor and may NOT be the first row in the underlying data table if this is a child DataWidget.

Type
parasql.schema.DataValue

getLastRenderedDataCell() → {Object.<tableName:string, columnName:string, dataCellDiv:HTMLElement, dataValue:parasql.schema.DataValue>}

Normally this method is called after receiving a renderCell event.

Description:

  • Normally this method is called after receiving a renderCell event.

Returns:

Info about the last rendered data cell.

Type
Object.<tableName:string, columnName:string, dataCellDiv:HTMLElement, dataValue:parasql.schema.DataValue>

getQueries() → {Array.<parasql.widget.util.Query>}

You can change the active query via the setActiveQuery() method.

Description:

  • You can change the active query via the setActiveQuery() method.

Overrides:
Returns:

The array of Query objects owned by this DataWidget.

Type
Array.<parasql.widget.util.Query>

getQueryById(queryId) → (nullable) {parasql.widget.util.Query}

Overrides:
Parameters:
Name Type Description
queryId string
Returns:

The Query object with the specified queryId, or null if no query with that ID exists.

Type
parasql.widget.util.Query

getQueryByName(queryName) → (nullable) {parasql.widget.util.Query}

Overrides:
Parameters:
Name Type Description
queryName string
Returns:

The Query object with the specified queryName, or null if no query with that name exists.

Type
parasql.widget.util.Query

getSelectedRowIndex() → {number}

Overrides:
Returns:

The index of the currently selected row; if no row is selected returns -1. The first row is 0.

Type
number

getSelectedValue(tableName, columnName) → (nullable) {parasql.schema.DataValue}

Convenience method to return the DataValue in the specified column of the currently selected row.

Description:

  • Convenience method to return the DataValue in the specified column of the currently selected row.

Parameters:
Name Type Description
tableName string

The table name.
columnName string

The column name.
Throws:

If tableName.columnName does not exist in the underlying DataTable.

Type
TypeError
Returns:

A DataValue object or null if no row is selected.

Type
parasql.schema.DataValue

getTransactionSet() → {parasql.schema.TransactionSet}

Overrides:
Returns:
Type
parasql.schema.TransactionSet

getWidgetId() → (non-null) {string}

Overrides:
Returns:

An identifier that uniquely identifies this widget.

Type
string

isDisabled() → {boolean}

Overrides:
Returns:
Type
boolean

printWidget()

Causes this widget to print itself.

Description:

  • Causes this widget to print itself.

Overrides:

redisplay()

Redisplays this widget.

Description:

  • Redisplays this widget.

Overrides:

refreshQuery()

Executes the currently active query.

Description:

  • Executes the currently active query. To change the active query call the setActiveQuery() method.

Overrides:

setActiveQuery(queryObject)

Sets the active query but does not run it.

Description:

  • Sets the active query but does not run it. To run the active query call the refreshQuery() method.

Overrides:
Parameters:
Name Type Description
queryObject parasql.widget.util.Query

A valid query object.

setDisabled(flag)

WARNING: Subclasses overriding this method must not trigger a redisplay (causes an infinite loop).

Description:

  • WARNING: Subclasses overriding this method must not trigger a redisplay (causes an infinite loop).

Overrides:
Parameters:
Name Type Description
flag boolean

If true, this widget will be rendered as disabled.

setSelectedRowIndex(index)

Overrides:
Parameters:
Name Type Description
index number

The index of the row to select; the first row is 0. A value of -1 causes no row to be selected.