Page History

Div

style	display:none

DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR. Enter additional information related to this 'class' inside the {div} macro with 'id=description'

Div

id	description

HTML Table

id
class	servoy sSummary

Colgroup Tag

Col

width	80px

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Property Summary

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
abs Create abs(column) expression

Table Row (tr)

Table Cell (td)
QBSort

Table Cell (td)
asc Create an ascending sort expression

Table Row (tr)

Table Cell (td)
QBAggregate

Table Cell (td)
avg Create an aggregate expression.

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
bit_length Create bit_length(column) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
ceil Create ceil(column) expression

Table Row (tr)

Table Cell (td)
QBAggregate

Table Cell (td)
count Create an aggregate expression.

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
day Extract day from date

Table Row (tr)

Table Cell (td)
QBSort

Table Cell (td)
desc Create an descending sort expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
floor Create floor(column) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
hour Extract hour from date

Table Row (tr)

Table Cell (td)
QBCondition

Table Cell (td)
isNull Compare column with null.

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
len Create length(column) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
lower Create lower(column) expression

Table Row (tr)

Table Cell (td)
QBAggregate

Table Cell (td)
max Create an aggregate expression.

Table Row (tr)

Table Cell (td)
QBAggregate

Table Cell (td)
min Create an aggregate expression.

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
minute Extract minute from date

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
month Extract month from date

Table Row (tr)

Table Cell (td)
QBColumn

Table Cell (td)
not Create a negated condition.

Table Row (tr)

Table Cell (td)
QBTableClause

Table Cell (td)
parent Get query builder parent table clause, this may be a query or a join clause.

Table Row (tr)

Table Cell (td)
QBSelect

Table Cell (td)
root Get query builder parent.

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
round Create round(column) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
second Extract second from date

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
sqrt Create sqrt(column) expression

Table Row (tr)

Table Cell (td)
QBAggregate

Table Cell (td)
sum Create an aggregate expression.

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
trim Create trim(column) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
upper Create upper(column) expression

Table Row (tr)

Table Cell (td)
QBFunction

Table Cell (td)
year Extract year from date

...

Child pages

Versions Compared

Old Version 12

New Version 13

Key