Query

parasql.widget.util. Query

A Query object has a name, id and an internal tree of Filter objects that implement its query structure. Within the Design environment, a Query object corresponds to a named filter for a Report, Record or Chart object. Each DataWidget has its own array of Query objects. See parasql.widget.DataWidget#getQueries for more info.

Extends

  • Object

Methods

getQueryId() → {string}

Since:
  • v101
Returns:
Type
string

getQueryName() → {string}

Since:
  • v101
Returns:
Type
string

getWhereClause() → {string}

Since:
  • v119
Throws:

If this is not a Power Filter.

Type
TypeError
Returns:

Returns the WHERE clause used by this PowerFilter, otherwise null.

Type
string

isPowerFilter() → {boolean}

Since:
  • v119
Returns:
Type
boolean

setWhereClause(whereClause)

For this method to work the Query mode must be set to Power Filter.

Description:
  • For this method to work the Query mode must be set to Power Filter.

Since:
  • v119
Parameters:
Name Type Description
whereClause string

A valid WHERE clause (without the keyword WHERE).

Throws:

If this is not a Power Filter.

Type
TypeError