Class: 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.
Copyright:
  • ParaSQL LLC 2014-2022. All rights reserved.
License:

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.
Parameters:
Name Type Description
whereClause string A valid WHERE clause (without the keyword WHERE).
Since:
  • v119
Throws:
If this is not a Power Filter.
Type
TypeError