Table Head (thead) |
---|
Table Row (tr) |
---|
| Table Head (th) |
---|
| Method Details |
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create abs(column) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynum.abs.eq(query.functions.abs(myval)))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
bit_length |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create bit_length(column) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.bit_length.eq(query.functions.bit_length('Sample')))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters Div |
---|
| {Object} value - object to cast {String} type - type see QUERY_COLUMN_TYPES |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/ |
|
|
|
| order_details> subqueryquery = databaseManager.createSelect('db:/example_data/ |
|
|
|
| order_details
/**@type {QBSelect<db:example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.add(query
.or
/$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns. |
|
|
|
| orderid.not.isin([1, 2, 3]))
.add(query.exists(
subquery.where.add(subquery.columns.orderid.eq(query.columns.order_id)).root
))
)
foundset.loadRecords(query)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\
{table:id=function|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=abs|class=node}{tr:id=name}{td}h6.abs{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}abs{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:abs_des|trigger=button|text=}{sub-section}{sub-section:abs_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:abs_snc|trigger=button|text=}{sub-section}{sub-section:abs_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:abs_prs|trigger=button|text=}{sub-section}{sub-section:abs_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:abs_ret|trigger=button|text=}{sub-section}{sub-section:abs_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:abs_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:abs_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:abs_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:abs_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:abs_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:abs_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynum.abs.eq(query.functions.abs(myval)))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=bit_length|class=node}{tr:id=name}{td}h6.bit_length{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}bit_length{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:bit_length_des|trigger=button|text=}{sub-section}{sub-section:bit_length_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:bit_length_snc|trigger=button|text=}{sub-section}{sub-section:bit_length_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:bit_length_prs|trigger=button|text=}{sub-section}{sub-section:bit_length_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:bit_length_ret|trigger=button|text=}{sub-section}{sub-section:bit_length_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:bit_length_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:bit_length_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:bit_length_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:bit_length_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:bit_length_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:bit_length_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.bit_length.eq(query.functions.bit_length('Sample')))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=cast|class=node}{tr:id=name}{td}h6.cast{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}cast{span}{span:id=iets|style=float: left;}\(value, type){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:cast_des|trigger=button|text=}{sub-section}{sub-section:cast_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:cast_snc|trigger=button|text=}{sub-section}{sub-section:cast_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:cast_prs|trigger=button|text=}{sub-section}{sub-section:cast_prs|trigger=none|class=sIndent}\{[Object]} value -- object to cast
\{[String]} type -- type see QUERY\_COLUMN\_TYPES
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:cast_ret|trigger=button|text=}{sub-section}{sub-section:cast_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:cast_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:cast_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:cast_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:cast_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:cast_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:cast_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=ceil|class=node}{tr:id=name}{td}h6.ceil{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}ceil{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:ceil_des|trigger=button|text=}{sub-section}{sub-section:ceil_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:ceil_snc|trigger=button|text=}{sub-section}{sub-section:ceil_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:ceil_prs|trigger=button|text=}{sub-section}{sub-section:ceil_prs|trigger=none|class=sIndent}\{[Object]} arg -- number object
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:ceil_ret|trigger=button|text=}{sub-section}{sub-section:ceil_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:ceil_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:ceil_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:ceil_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:ceil_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:ceil_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:ceil_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.ceil.eq(query.functions.ceil(myvar))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=coalesce|class=node}{tr:id=name}{td}h6.coalesce{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}coalesce{span}{span:id=iets|style=float: left;}\(args){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:coalesce_des|trigger=button|text=}{sub-section}{sub-section:coalesce_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:coalesce_snc|trigger=button|text=}{sub-section}{sub-section:coalesce_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:coalesce_prs|trigger=button|text=}{sub-section}{sub-section:coalesce_prs|trigger=none|class=sIndent}\{[Object]...} args -- arguments to coalesce
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:coalesce_ret|trigger=button|text=}{sub-section}{sub-section:coalesce_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:coalesce_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:coalesce_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:coalesce_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:coalesce_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:coalesce_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:coalesce_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mycol.coalesce('defval').eq(query.functions.coalesce(myvar, 'defval'))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=concat|class=node}{tr:id=name}{td}h6.concat{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}concat{span}{span:id=iets|style=float: left;}\(arg1, arg2){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:concat_des|trigger=button|text=}{sub-section}{sub-section:concat_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:concat_snc|trigger=button|text=}{sub-section}{sub-section:concat_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:concat_prs|trigger=button|text=}{sub-section}{sub-section:concat_prs|trigger=none|class=sIndent}\{[Object]} arg1
\{[Object]} arg2
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:concat_ret|trigger=button|text=}{sub-section}{sub-section:concat_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:concat_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:concat_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:concat_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:concat_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:concat_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:concat_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/udm/contacts>} */
var query = databaseManager.createSelect('db:/udm/contacts') //$NON-NLS-1$
query.result.add(query.columns.name_first.concat(' ').concat(query.columns.name_last))
var ds = databaseManager.getDataSetByQuery(query, -1)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=day|class=node}{tr:id=name}{td}h6.day{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}day{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:day_des|trigger=button|text=}{sub-section}{sub-section:day_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:day_snc|trigger=button|text=}{sub-section}{sub-section:day_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:day_prs|trigger=button|text=}{sub-section}{sub-section:day_prs|trigger=none|class=sIndent}\{[Object]} arg -- date object
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:day_ret|trigger=button|text=}{sub-section}{sub-section:day_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:day_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:day_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:day_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:day_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:day_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:day_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.day.eq(query.functions.day(mydatevar))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=divide|class=node}{tr:id=name}{td}h6.divide{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}divide{span}{span:id=iets|style=float: left;}\(arg1, arg2){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:divide_des|trigger=button|text=}{sub-section}{sub-section:divide_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:divide_snc|trigger=button|text=}{sub-section}{sub-section:divide_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:divide_prs|trigger=button|text=}{sub-section}{sub-section:divide_prs|trigger=none|class=sIndent}\{[Object]} arg1
\{[Object]} arg2
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:divide_ret|trigger=button|text=}{sub-section}{sub-section:divide_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:divide_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:divide_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:divide_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:divide_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:divide_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:divide_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.divide(2).eq(query.functions.divide(myvar, 2))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=floor|class=node}{tr:id=name}{td}h6.floor{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}floor{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:floor_des|trigger=button|text=}{sub-section}{sub-section:floor_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:floor_snc|trigger=button|text=}{sub-section}{sub-section:floor_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:floor_prs|trigger=button|text=}{sub-section}{sub-section:floor_prs|trigger=none|class=sIndent}\{[Object]} arg -- number object
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:floor_ret|trigger=button|text=}{sub-section}{sub-section:floor_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:floor_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:floor_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:floor_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:floor_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:floor_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:floor_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.floor.eq(query.functions.floor(myvar))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=hour|class=node}{tr:id=name}{td}h6.hour{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}hour{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:hour_des|trigger=button|text=}{sub-section}{sub-section:hour_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:hour_snc|trigger=button|text=}{sub-section}{sub-section:hour_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:hour_prs|trigger=button|text=}{sub-section}{sub-section:hour_prs|trigger=none|class=sIndent}\{[Object]} arg -- date object
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:hour_ret|trigger=button|text=}{sub-section}{sub-section:hour_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:hour_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:hour_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:hour_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:hour_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:hour_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:hour_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.hour.eq(query.functions.hour(mydatevar))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=len|class=node}{tr:id=name}{td}h6.len{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}len{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:len_des|trigger=button|text=}{sub-section}{sub-section:len_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:len_snc|trigger=button|text=}{sub-section}{sub-section:len_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:len_prs|trigger=button|text=}{sub-section}{sub-section:len_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:len_ret|trigger=button|text=}{sub-section}{sub-section:len_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:len_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:len_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:len_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:len_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:len_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:len_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.len.eq(query.functions.len('Sample')))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=locate-Object_Object|class=node}{tr:id=name}{td}h6.locate{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}locate{span}{span:id=iets|style=float: left;}\(string1, string2){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:locate-Object_Object_des|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:locate-Object_Object_snc|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:locate-Object_Object_prs|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_prs|trigger=none|class=sIndent}\{[Object]} string1 -- string to locate
\{[Object]} string2 -- string to search in
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:locate-Object_Object_ret|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:locate-Object_Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:locate-Object_Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:locate-Object_Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.locate('amp').eq(query.functions.locate('Sample', 'amp')))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=locate-Object_Object_Number|class=node}{tr:id=name}{td}h6.locate{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}locate{span}{span:id=iets|style=float: left;}\(string1, string2, start){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:locate-Object_Object_Number_des|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:locate-Object_Object_Number_snc|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:locate-Object_Object_Number_prs|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_Number_prs|trigger=none|class=sIndent}\{[Object]} string1 -- string to locate
\{[Object]} string2 -- string to search in
\{[Number]} start -- start pos
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:locate-Object_Object_Number_ret|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_Number_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:locate-Object_Object_Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_Object_Number_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:locate-Object_Object_Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_Object_Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:locate-Object_Object_Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_Object_Number_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.locate('amp', 1).eq(query.functions.locate('Sample', 'amp', 1)))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=lower|class=node}{tr:id=name}{td}h6.lower{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}lower{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:lower_des|trigger=button|text=}{sub-section}{sub-section:lower_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:lower_snc|trigger=button|text=}{sub-section}{sub-section:lower_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:lower_prs|trigger=button|text=}{sub-section}{sub-section:lower_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:lower_ret|trigger=button|text=}{sub-section}{sub-section:lower_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:lower_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:lower_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:lower_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:lower_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:lower_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:lower_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.lower.eq(query.functions.lower('Sample')))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=minus|class=node}{tr:id=name}{td}h6.minus{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}minus{span}{span:id=iets|style=float: left;}\(arg1, arg2){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:minus_des|trigger=button|text=}{sub-section}{sub-section:minus_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:minus_snc|trigger=button|text=}{sub-section}{sub-section:minus_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:minus_prs|trigger=button|text=}{sub-section}{sub-section:minus_prs|trigger=none|class=sIndent}\{[Object]} arg1
\{[Object]} arg2
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:minus_ret|trigger=button|text=}{sub-section}{sub-section:minus_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:minus_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minus_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:minus_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minus_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:minus_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minus_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.minus(2).eq(query.functions.minus(myvar, 2))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=minute|class=node}{tr:id=name}{td}h6.minute{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}minute{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:minute_des|trigger=button|text=}{sub-section}{sub-section:minute_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:minute_snc|trigger=button|text=}{sub-section}{sub-section:minute_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:minute_prs|trigger=button|text=}{sub-section}{sub-section:minute_prs|trigger=none|class=sIndent}\{[Object]} arg -- date object
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:minute_ret|trigger=button|text=}{sub-section}{sub-section:minute_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:minute_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minute_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:minute_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minute_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:minute_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minute_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.minute.eq(query.functions.minute(mydatevar))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=mod|class=node}{tr:id=name}{td}h6.mod{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}mod{span}{span:id=iets|style=float: left;}\(dividend, divisor){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:mod_des|trigger=button|text=}{sub-section}{sub-section:mod_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:mod_snc|trigger=button|text=}{sub-section}{sub-section:mod_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:mod_prs|trigger=button|text=}{sub-section}{sub-section:mod_prs|trigger=none|class=sIndent}\{[Object]} dividend
\{[Object]} divisor
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:mod_ret|trigger=button|text=}{sub-section}{sub-section:mod_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:mod_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:mod_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:mod_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:mod_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:mod_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:mod_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.mod(2).eq(query.functions.mod(myvar, 2))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=month|class=node}{tr:id=name}{td}h6.month{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}month{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:month_des|trigger=button|text=}{sub-section}{sub-section:month_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:month_snc|trigger=button|text=}{sub-section}{sub-section:month_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:month_prs|trigger=button|text=}{sub-section}{sub-section:month_prs|trigger=none|class=sIndent}\{[Object]} arg -- date object
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:month_ret|trigger=button|text=}{sub-section}{sub-section:month_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:month_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:month_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:month_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:month_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:month_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:month_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.month.eq(query.functions.month(mydatevar))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=multiply|class=node}{tr:id=name}{td}h6.multiply{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}multiply{span}{span:id=iets|style=float: left;}\(arg1, arg2){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:multiply_des|trigger=button|text=}{sub-section}{sub-section:multiply_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:multiply_snc|trigger=button|text=}{sub-section}{sub-section:multiply_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:multiply_prs|trigger=button|text=}{sub-section}{sub-section:multiply_prs|trigger=none|class=sIndent}\{[Object]} arg1
\{[Object]} arg2
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:multiply_ret|trigger=button|text=}{sub-section}{sub-section:multiply_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:multiply_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:multiply_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:multiply_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:multiply_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:multiply_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:multiply_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.multiply(2).eq(query.functions.multiply(myvar, 2))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=nullif|class=node}{tr:id=name}{td}h6.nullif{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}nullif{span}{span:id=iets|style=float: left;}\(arg1){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:nullif_des|trigger=button|text=}{sub-section}{sub-section:nullif_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:nullif_snc|trigger=button|text=}{sub-section}{sub-section:nullif_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:nullif_prs|trigger=button|text=}{sub-section}{sub-section:nullif_prs|trigger=none|class=sIndent}\{[Object]} arg1
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:nullif_ret|trigger=button|text=}{sub-section}{sub-section:nullif_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:nullif_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:nullif_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:nullif_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:nullif_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:nullif_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:nullif_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.nullif('none').eq(query.functions.nullif('Sample', 'none')))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=plus|class=node}{tr:id=name}{td}h6.plus{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}plus{span}{span:id=iets|style=float: left;}\(arg1, arg2){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:plus_des|trigger=button|text=}{sub-section}{sub-section:plus_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:plus_snc|trigger=button|text=}{sub-section}{sub-section:plus_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:plus_prs|trigger=button|text=}{sub-section}{sub-section:plus_prs|trigger=none|class=sIndent}\{[Object]} arg1
\{[Object]} arg2
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:plus_ret|trigger=button|text=}{sub-section}{sub-section:plus_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:plus_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:plus_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:plus_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:plus_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:plus_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:plus_sam|trigger=none}{code:language=javascript}
discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML()) |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create ceil(column) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters Div |
---|
| {Object} arg - number object |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol. |
|
|
|
| plus(2)plus, 2
foundset.loadRecords(query); |
|
|
|
|
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=round|class=node}{tr:id=name}{td}h6.round{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}round{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:round_des|trigger=button|text=}{sub-section}{sub-section:round_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:round_snc|trigger=button|text=}{sub-section}{sub-section:round_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:round_prs|trigger=button|text=}{sub-section}{sub-section:round_prs|trigger=none|class=sIndent}\{[Object]} arg -- number object
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:round_ret|trigger=button|text=}{sub-section}{sub-section:round_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:round_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:round_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:round_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:round_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:round_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:round_sam|trigger=none}{code:language=javascript}
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create year(date) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters Div |
---|
| {Object...} args - arguments to coalesce |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mycol.coalesce('defval').eq(query.functions.coalesce(myvar, 'defval'))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create concat(args, arg2) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/udm/contacts>} */
var query = databaseManager.createSelect('db:/udm/contacts') //$NON-NLS-1$
query.result.add(query.columns.name_first.concat(' ').concat(query.columns.name_last))
var ds = databaseManager.getDataSetByQuery(query, -1) |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create day(date) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns. |
|
|
|
| mynumcolroundroundmyvar loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=second|class=node}{tr:id=name}{td}h6.second{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}second{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:second_des|trigger=button|text=}{sub-section}{sub-section:second_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:second_snc|trigger=button|text=}{sub-section}{sub-section:second_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:second_prs|trigger=button|text=}{sub-section}{sub-section:second_prs|trigger=none|class=sIndent}\{[Object]} arg -- date object
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:second_ret|trigger=button|text=}{sub-section}{sub-section:second_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:second_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:second_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:second_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:second_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:second_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:second_sam|trigger=none}{code:language=javascript}
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create divide(args, arg2) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.divide(2).eq(query.functions.divide(myvar, 2))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create floor(column) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters Div |
---|
| {Object} arg - number object |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.floor.eq(query.functions.floor(myvar))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create hour(date) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol. |
|
|
|
| secondsecond
foundset.loadRecords(query); |
|
|
|
|
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=sqrt|class=node}{tr:id=name}{td}h6.sqrt{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}sqrt{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:sqrt_des|trigger=button|text=}{sub-section}{sub-section:sqrt_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:sqrt_snc|trigger=button|text=}{sub-section}{sub-section:sqrt_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:sqrt_prs|trigger=button|text=}{sub-section}{sub-section:sqrt_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:sqrt_ret|trigger=button|text=}{sub-section}{sub-section:sqrt_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:sqrt_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sqrt_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:sqrt_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sqrt_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:sqrt_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sqrt_sam|trigger=none}{code:language=javascript}
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create length(column) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.len.eq(query.functions.len('Sample')))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create locate(str1, str2) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters Div |
---|
| {Object} string1 - string to locate {Object} string2 - string to search in |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns. |
|
|
|
| mynum.sqrtshipname.locate('amp').eq(query.functions |
|
|
|
| .sqrt(myval)))
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=substring-Object_Number|class=node}{tr:id=name}{td}h6.substring{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}substring{span}{span:id=iets|style=float: left;}\(arg, pos){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:substring-Object_Number_des|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:substring-Object_Number_snc|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:substring-Object_Number_prs|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_prs|trigger=none|class=sIndent}\{[Object]} arg -- column name
\{[Number]} pos -- position
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:substring-Object_Number_ret|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:substring-Object_Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Object_Number_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:substring-Object_Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Object_Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:substring-Object_Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Object_Number_sam|trigger=none}{code:language=javascript}
.locate('Sample', 'amp')))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
id | locate-Object_Object_Number |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
(string1, string2, start) |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create locate(str1, str2, start) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters Div |
---|
| {Object} string1 - string to locate {Object} string2 - string to search in {Number} start - start pos |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.locate('amp', 1).eq(query.functions.locate('Sample', 'amp', 1)))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create lower(column) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.lower.eq(query.functions.lower('Sample')))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create minus(args, arg2) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.minus(2).eq(query.functions.minus(myvar, 2))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create minute(date) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns. |
|
|
|
| shipname.substring(3)mydatecol.minute.eq(query.functions. |
|
|
|
| substring('Sample', 3) query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=substring-Object_Number_Number|class=node}{tr:id=name}{td}h6.substring{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}substring{span}{span:id=iets|style=float: left;}\(arg, pos, len){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:substring-Object_Number_Number_des|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:substring-Object_Number_Number_snc|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:substring-Object_Number_Number_prs|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_Number_prs|trigger=none|class=sIndent}\{[Object]} arg -- column name
\{[Number]} pos -- position
\{[Number]} len -- length
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:substring-Object_Number_Number_ret|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_Number_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:substring-Object_Number_Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Object_Number_Number_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:substring-Object_Number_Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Object_Number_Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:substring-Object_Number_Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Object_Number_Number_sam|trigger=none}{code:language=javascript}
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create mod(dividend, divisor) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.mod(2).eq(query.functions.mod(myvar, 2))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create month(date) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.month.eq(query.functions.month(mydatevar))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create multiply(args, arg2) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.multiply(2).eq(query.functions.multiply(myvar, 2))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create nullif(arg1, arg2) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname. |
|
|
|
| substring(3, 2nullif('none').eq(query.functions. |
|
|
|
| substring3, 2
foundset.loadRecords(query); |
|
|
|
|
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=trim|class=node}{tr:id=name}{td}h6.trim{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}trim{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:trim_des|trigger=button|text=}{sub-section}{sub-section:trim_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:trim_snc|trigger=button|text=}{sub-section}{sub-section:trim_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:trim_prs|trigger=button|text=}{sub-section}{sub-section:trim_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:trim_ret|trigger=button|text=}{sub-section}{sub-section:trim_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:trim_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:trim_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:trim_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:trim_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:trim_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:trim_sam|trigger=none}{code:language=javascript}
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create plus(args, arg2) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.plus(2).eq(query.functions.plus(myvar, 2))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create round(column) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters Div |
---|
| {Object} arg - number object |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.round.eq(query.functions.round(myvar))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create second(date) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns. |
|
|
|
| shipnametrimsecond.eq(query.functions. |
|
|
|
| trim('Sample')
foundset.loadRecords(query); |
|
|
|
|
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=upper|class=node}{tr:id=name}{td}h6.upper{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}upper{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:upper_des|trigger=button|text=}{sub-section}{sub-section:upper_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:upper_snc|trigger=button|text=}{sub-section}{sub-section:upper_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:upper_prs|trigger=button|text=}{sub-section}{sub-section:upper_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:upper_ret|trigger=button|text=}{sub-section}{sub-section:upper_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:upper_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:upper_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:upper_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:upper_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:upper_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:upper_sam|trigger=none}{code:language=javascript}
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create sqrt(column) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynum.sqrt.eq(query.functions.sqrt(myval)))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
id | substring-Object_Number |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create substring(column, pos) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.substring(3).eq(query.functions.substring('Sample', 3)))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
id | substring-Object_Number_Number |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create substring(column, pos, len) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname. |
|
|
|
| uppersubstring(3, 2).eq(query.functions. |
|
|
|
| uppersubstring('Sample', 3, 2)))
|
|
|
|
|
foundset.loadRecords(query); |
|
|
|
|
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=year|class=node}{tr:id=name}{td}h6.year{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}year{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:year_des|trigger=button|text=}{sub-section}{sub-section:year_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:year_snc|trigger=button|text=}{sub-section}{sub-section:year_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:year_prs|trigger=button|text=}{sub-section}{sub-section:year_prs|trigger=none|class=sIndent}\{[Object]} arg -- date object
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:year_ret|trigger=button|text=}{sub-section}{sub-section:year_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:year_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:year_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:year_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:year_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:year_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:year_sam|trigger=none}{code:language=javascript}
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create trim(column) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.trim.eq(query.functions.trim('Sample')))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create upper(column) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.upper.eq(query.functions.upper('Sample')))
foundset.loadRecords(query); |
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Create year(date) expression |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| /** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.year.eq(query.functions.year(mydatevar)) |
|
|
|
|
foundset.loadRecords(query); |
|
|
|
|
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table} |