servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListNGClientservoy sSummary12%30%58%height: 30px;3Methods SummaryAdd a filter parameter that is permanent per user session to limit a specified foundset of records.Can be used to deep copy a custom value.Performs a sql query with a query builder object.This will generate a list of primary keys names for the given data source.This will generate a url from a byte array so that the client can get the bytes from that url.Get select query for dataSourceHide 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.functionservoy sDetail2100%height:30px2Methods DetailsaddFoundSetFilterParamname
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.
prs
Parameters
sIndentfoundsetThe foundset to add the filter param/query toqueryThe query repesenting the filterfilterNamea name given to this foundset filterret
Returns
sIndentclients
Supported Clients
sIndentNGClientsam
Sample
sIdentjavascriptlastDetailRowcopyObjectname
copyObject(value)
dessIndent
Can be used to deep copy a custom value.
prs
Parameters
sIndentvaluethe value to be copiedret
Returns
sIndent a copy of the value object, the same as constructing the object in javascript from scratchclients
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.
prs
Parameters
sIndentqueryQBSelect query.max_returned_rowsThe maximum number of rows returned by the query.ret
Returns
sIndent The JSDataSet containing the results of the query.clients
Supported Clients
sIndentNGClientsam
Sample
sIdentjavascriptlastDetailRowgetDatasourcePKsname
getDatasourcePKs(datasource)
dessIndent
This will generate a list of primary keys names for the given data source.
prs
Parameters
sIndentdatasourcethe data sourceret
Returns
sIndent a list of primary key namesclients
Supported Clients
sIndentNGClientsam
Sample
sIdentjavascriptlastDetailRowgetMediaUrlname
getMediaUrl(bytes)
dessIndent
This will generate a url from a byte array so that the client can get the bytes from that url.
prs
Parameters
sIndentbytesThe value where an url should be created forret
Returns
sIndent the url where the bytes can be downloaded fromclients
Supported Clients
sIndentNGClientsam
Sample
sIdentjavascriptlastDetailRowgetQuerySelectname
getQuerySelect(dataSource)
dessIndent
Get select query for dataSource
prs
Parameters
sIndentdataSourcethe dataSourceret
Returns
sIndent QB select for the dataSourceclients
Supported Clients
sIndentNGClientsam
Sample
sIdentjavascriptlastDetailRowgetViewFoundSetname
getViewFoundSet(name, query)
dessIndentprs
Parameters
sIndentname;query;ret
Returns
sIndentclients
Supported Clients
sIndentNGClientsam
Sample
sIdentjavascriptlastDetailRowhideFormname
hideForm(formName)
dessIndent
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.