Page History

...

HTML Table

id
class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#dateFormat dateFormat(date, format) Format a date object to a text representation.

tbody

Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)
#hasRecords hasRecords(foundset) Returns true if the (related)foundset exists and has records.

tbody

Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)
#hasRecords hasRecords(record, relationString) Returns true if the (related)foundset exists and has records.

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#numberFormat numberFormat(number, digits) Format a number to have a defined fraction.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#numberFormat numberFormat(number, format) Format a number to specification.

HTML Table

id	function
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Method Details

Table Body (tbody)

id	dateFormat-Date_String

Table Row (tr)

id	name

Table Cell (td)
dateFormat

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

String

Span

style	font-weight: bold;

dateFormat

Span
(date, format)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Format a date object to a text representation.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Date} date

...

- the date
{String} format

...

- the format to output

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

...

- the date as text

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

var formattedDateString = utils.dateFormat(dateobject,'EEE, d MMM yyyy HH:mm:ss');

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	hasRecords-JSFoundSet

Table Row (tr)

id	name

Table Cell (td)
hasRecords

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

Boolean

Span

style	font-weight: bold;

hasRecords

Span
(foundset)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Returns true if the (related)foundset exists and has records.
Another use is, to pass a record and qualified relations string to test multiple relations/foundset at once

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{JSFoundSet} foundset

...

- the foundset to be tested

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Boolean

...

- true if exists

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

//test the orders_to_orderitems foundset

...


if (elements.customer_id.hasRecords(orders_to_orderitems))
{
	//do work on relatedFoundSet
}
//test the orders_to_orderitems.orderitems_to_products foundset to be reached from the current record

...


//if (elements.customer_id.hasRecords(foundset.getSelectedRecord(),'orders_to_orderitems.orderitems_to_products'))
//{
//	//do work on deeper relatedFoundSet
//}

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	hasRecords-JSRecord_String

Table Row (tr)

id	name

Table Cell (td)
hasRecords

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

Boolean

Span

style	font-weight: bold;

hasRecords

Span
(record, relationString)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Returns true if the (related)foundset exists and has records.
Another use is, to pass a record and qualified relations string to test multiple relations/foundset at once

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{JSRecord} record

...

- A JSRecord to test.
{String} relationString

...

- The relation name.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Boolean

...

- true if the foundset/relation has records.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

//test the orders_to_orderitems foundset

...


if (elements.customer_id.hasRecords(orders_to_orderitems))
{
	//do work on relatedFoundSet
}
//test the orders_to_orderitems.orderitems_to_products foundset to be reached from the current record

...


//if (elements.customer_id.hasRecords(foundset.getSelectedRecord(),'orders_to_orderitems.orderitems_to_products'))
//{
//	//do work on deeper relatedFoundSet
//}

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	numberFormat-Number_Number

Table Row (tr)

id	name

Table Cell (td)
numberFormat

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

String

Span

style	font-weight: bold;

numberFormat

Span
(number, digits)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Format a number to have a defined fraction.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Number} number

...

- the number to format
{Number} digits

...

- nr of digits

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

...

- the resulting number in text

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

var textalNumber = utils.numberFormat(16.749, 2); //returns 16.75

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	numberFormat-Number_String

Table Row (tr)

id	name

Table Cell (td)
numberFormat

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

String

Span

style	font-weight: bold;

numberFormat

Span
(number, format)

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Format a number to specification.

Table Row (tr)

id	prs

Table Cell (td)

Parameters

Div

class	sIndent

{Number} number

...

- the number to format
{String} format

...

- the format

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

...

- the resulting number in text

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

...

var textalNumber2 = utils.numberFormat(100006.749, '#,###.00'); //returns 100,006.75

...

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Child pages

Versions Compared

Old Version 9

New Version 10

Key

dateFormat

hasRecords

hasRecords

numberFormat

numberFormat