QueryPanelOptions interface

Query panel options

Extends

DataDisplayFormatterOptions

Index

Properties

accentActiveCondition

If true the active condition (the one user clicked on previously) will have accent background color.

● accentActiveCondition?: boolean

activateRootOnStart

If true root predicate row become active at the beginning.

● activateRootOnStart?: boolean

activeCondition

● activeCondition?: null

adjustEntitiesMenuHeight

● adjustEntitiesMenuHeight?: boolean

allowDragDrop

Gets or sets a value indicating whether it’s possible to drag attributes from EntitiesPanel and drop them into QueryPanel to create new conditions.

● allowDragDrop?: boolean

allowInJoinConditions

Gets or sets a value indicating whether query panel allows to place some conditions in to JOIN clause instead of WHERE.

● allowInJoinConditions?: boolean

allowParameterization

Gets or sets a value indicating whether query panel shows “toggle parameterization” button which aloows to mark each condition as parameterized.

● allowParameterization?: boolean

alwaysShowButtonsInConditions

If true QueryPanel widget will always show button in condition rows. Instead of default behaviour when they are shown only on mouse over.

● alwaysShowButtonsInConditions?: boolean

alwaysShowButtonsInGroups

If true QueryPanel widget will always show button in predicate (group) rows. Instead of default behaviour when they are shown only on mouse over.

● alwaysShowButtonsInGroups?: boolean

attrElementFormat

The format of entity attributes used in query panel conditions. You can set it to {attr} to shown only attribute part (without entity name)

● attrElementFormat?: string

attrPlacement

Defines where to display attributes in the tree: 0 - attributes are displayed after entities 1 - attributes are displayed before entities 2 - attributes and entities are mixed, and displayed in alphabetical order. In this case the sortEntities option value dosn’t matter.

● attrPlacement?: number

autoEditNewCondition

If true the QueryPanel will automaticall show value editor for any new (just added) condition

● autoEditNewCondition?: boolean

buttons

Defines which buttons should be shown in the condition/predicate when the mouse is over. Possible values are:

"addCondition" - the button that allows to add new condition. Is shown in predicates only.
"addPredicate" - the button that allows to add new predicate. Is shown in predicates only.
"enable" - the button that allows to enable or disable certain condition.
"delete" - the button that allows to delete certain condition.
"menu" - the button that shows menu with all available actions for the condition/predicate, including the actions that are not available using other buttons. By default the option is not set, it actually means

{
condition: ["enable", "delete"]
predicate: ["addCondition", "addPredicate", "enable", "delete"]
}

● buttons?: any

dateFormatDisplay

The format of date values used in condition rows.

● dateFormatDisplay?: string

dateFormatValue

A string that represents the format of date values used in date/time picker widget.

● dateFormatValue?: string

defaultQuery

● defaultQuery?: Query

dialogZIndex

Sets or gets the ZIndex property of the different dialogs used in QueryPanel (including the sub-query dialog)

● dialogZIndex?: number

domWriteItemsId

● domWriteItemsId?: boolean

emptyTextAttribute

● emptyTextAttribute?: string

emptyTextList

● emptyTextList?: string

emptyTextOperator

● emptyTextOperator?: string

emptyTextValue

● emptyTextValue?: string

entitiesListFilter

● entitiesListFilter?: any

entitiesPopupHandler

● entitiesPopupHandler?: any

isSubQuery

● isSubQuery?: boolean

localeId

● localeId?: string

localeSettings

● localeSettings?: LocaleSettings

menuContainer

● menuContainer?: HTMLElement

menuOptions

Contains different options for popup menu that appears for selecting attributes, operators or values in condition.

● menuOptions?: any

numberDecimalSeparatorDisplay

Sets or gets the symbol which is used as decimal separator

● numberDecimalSeparatorDisplay?: string

numberListSeparators

Sets or gets the symbols which are recognized as list items separators (for example when user is supposed to enter a list of values in a text box).

● numberListSeparators?: string[]

onConditionRendered

The callback that is called when the condition’s row has been rendered. It allows you to make any changes you need to the markup of the row. Parameters: condition - Condition object slot - HTMLDivElement object that represents the condition’s div

● onConditionRendered?: (condition: Condition, slot: HTMLDivElement) => void

Example:

conditionRenderedHandler: function (condition, slot) {
     slot.addClass("some-cool-class");
}

onExpressionRendered

● onExpressionRendered?: (expression: Expression, slot: HTMLDivElement) => void

onGetAddRowRenderer

● onGetAddRowRenderer?: (slot?: HTMLDivElement) => BaseElementRenderer | null

onGetConditionRenderer

● onGetConditionRenderer?: (condition: Condition, slot?: HTMLDivElement) => ConditionRenderer | null

onGetExpressionRenderer

● onGetExpressionRenderer?: (expression: Expression, slot?: HTMLDivElement) => ExpressionRenderer | null

onGetOperatorRenderer

● onGetOperatorRenderer?: (condition: Condition, text: string, slot?: HTMLDivElement) => BaseElementRenderer | null

onOperatorRendered

● onOperatorRendered?: (condition: Condition, text: string, slot: HTMLDivElement) => void

oneClickDateSelection

If true and no timepicker is displayed, calendar will be closed after click on some date. Default is true

● oneClickDateSelection?: boolean

showAddRow

Gets or sets a value indicating whether query panel must show a special [add condition] link at the bottom

● showAddRow?: boolean

showCheckboxes

Gets or sets a value indicating whether query panel must show a checkbox at the beginning of each condition row. User will be able to use these checkboxes to enable/disable corresponding query conditions

● showCheckboxes?: boolean

showConjunctions

If true QueryPanel widget will show conjunction elements (and or or) at the beginning of each condition.

● showConjunctions?: boolean

showPoweredBy

Allows to turn off “Powered by EasyQuery” link shown in the bottom right cornder of query panel. Works only in the full version of the script.

● showPoweredBy?: boolean

showRootRow

Gets or sets a value indicating whether query panel must show a root row which represents the main group of conditions

● showRootRow?: boolean

sortEntities

Defines whether entities and attributes should be sorted alphabetically. If false, they are displayed as listed in the model.

● sortEntities?: boolean

subQueryDialogHeight

Sets or gets the height of sub-query dialog

● subQueryDialogHeight?: number

subQueryDialogWidth

Sets or gets the width of sub-query dialog

● subQueryDialogWidth?: number

useCustomLocaleSettings

● useCustomLocaleSettings?: boolean

yearRange

The range of years displayed in the year drop-down: either relative to today’s year (“-nn:+nn”), relative to the currently selected year (“c-nn:c+nn”), absolute (“nnnn:nnnn”), or combinations of these formats (“nnnn:-nn”).

● yearRange?: string