Child pages
  • ServoyApi
Skip to end of metadata
Go to start of metadata

Refresh page Mar 20, 2024 00:15

Supported Clients
NGClient

Methods Summary
Boolean addFoundSetFilterParam(foundset, query, filterName) Add a filter parameter that is permanent per user session to limit a specified foundset of records.
Object copyObject(value) Can be used to deep copy a custom value.
JSDataSet getDataSetByQuery(query, max_returned_rows) Performs a sql query with a query builder object.
Array getDatasourcePKs(datasource) This will generate a list of primary keys names for the given data source.
String getMediaUrl(bytes) This will generate a url from a byte array so that the client can get the bytes from that url.
QBSelect getQuerySelect(dataSource) Get select query for dataSource
JSFoundSet getViewFoundSet(name, query)
Boolean hideForm(formName) Hide a form directly on the server for instance when a tab will change on the client, so it won't need to do a round trip for hiding the form through the browser's component.

Methods Details

addFoundSetFilterParam(foundset, query, filterName)

Add a filter parameter that is permanent per user session to limit a specified foundset of records.
This is similar as calling foundset.js_addFoundSetFilterParam, but the main difference is that this
works also on related foundsets.

Parameters

JSFoundSet foundset The foundset to add the filter param/query to
QBSelect query The query repesenting the filter
String filterName a name given to this foundset filter

Returns

Supported Clients

NGClient

Sample

 

copyObject(value)

Can be used to deep copy a custom value.

Parameters

Object value the value to be copied

Returns

Object a copy of the value object, the same as constructing the object in javascript from scratch

Supported Clients

NGClient

Sample

var eventSourceCopy = servoyApi.copyObject(eventSource);

getDataSetByQuery(query, max_returned_rows)

Performs a sql query with a query builder object.
Will throw an exception if anything did go wrong when executing the query.
Will use any data filter defined on table.

Parameters

QBSelect query QBSelect query.
Number max_returned_rows The maximum number of rows returned by the query.

Returns

JSDataSet The JSDataSet containing the results of the query.

Supported Clients

NGClient

Sample

var dataset = servoyApi.getDataSetByQuery(qbselect, 10);

getDatasourcePKs(datasource)

This will generate a list of primary keys names for the given data source.

Parameters

String datasource the data source

Returns

Array a list of primary key names

Supported Clients

NGClient

Sample

var pkNames = servoyApi.getDatasourcePKs(datasource);

getMediaUrl(bytes)

This will generate a url from a byte array so that the client can get the bytes from that url.

Parameters

Array bytes The value where an url should be created for

Returns

String the url where the bytes can be downloaded from

Supported Clients

NGClient

Sample

var url = servoyApi.getMediaUrl(bytes);

getQuerySelect(dataSource)

Get select query for dataSource

Parameters

String dataSource the dataSource

Returns

QBSelect QB select for the dataSource

Supported Clients

NGClient

Sample

 

getViewFoundSet(name, query)

Parameters

String name ;
QBSelect query ;

Returns

Supported Clients

NGClient

Sample

 

hideForm(formName)

Hide a form directly on the server for instance when a tab will change on the client, so it won't need to do a round trip
for hiding the form through the browser's component.

Parameters

Object formName the form to hide

Returns

Boolean true if the form was hidden

Supported Clients

NGClient

Sample

servoyApi.hideForm(formToHideName)

  • No labels