Datasource
What they are¶
Datasources are logical definitions (Views) based on queries that retrieve data at runtime, the values of which are not therefore saved in the database. Datasource queries can refer to any data in the database, not just dataset field data. Queries can be on the database (current connection), or on other DBs if the necessary permission is possessed.
Datasources are not available for data entry. However, datasources can only be called up in read only mode in forms that modify other data, run in data entry mode.
If the query refers to dataset partitions that the user cannot view, the system does not apply the user restrictions related to the partition. Datasources which refers to a dataset will not inherit its properties.