Datasources
Last updated
Was this helpful?
Last updated
Was this helpful?
(datasources)
Datasources
in Servoy provide a structured way to interact with various types of data sources, such as database tables, in-memory tables, views, and stored procedures. These datasources
are accessible through the datasources
object and support dynamic code completion based on the solution’s data model, enabling efficient development.
Datasources
include types like DBDataSource
, MemDataSource
, ViewDataSource
, SPDataSource
, and MenuDataSource
, each catering to a specific use case. For example, db
is used for server/table-based data sources, mem
for in-memory tables, and view
for view foundset data sources. Stored procedures are managed under the sp
property, with server-side configuration enabling their use. The menu
property handles menu-related datasources.
For details related to datasources, refer to the specific sections in the Servoy documentation:
,,,,,,,,,
Scope property for server/table based data sources.
Scope property for in-memory data sources.
Scope property for view foundset data sources.
Scope property for stored procedures.
Scope property for view foundset data sources.
Scope getter for a datasource node based on a JSFoundset/JSRecord/ViewFoundset/ViewRecord
Scope getter for a datasource node based on datasource string.
Scope property for server/table based data sources.
Sample
Scope property for in-memory data sources.
Sample
Scope property for view foundset data sources.
Sample
Scope property for stored procedures. This will list the stored procedures of server that have this property enabled (see server editor).
Sample
Scope property for view foundset data sources.
Sample
Scope getter for a datasource node based on a JSFoundset/JSRecord/ViewFoundset/ViewRecord
Parameters
Sample
Scope getter for a datasource node based on datasource string.
Parameters
Sample
Type
Type
Type
Type
Type
datasource ;
Returns: a JSDataSource based on parameter
datasource ;
Returns: a JSDataSource based on parameter