< dataSource />
View Element Reference
< dataSource />
An enclosing element used to contain the database table and field elements.
Custom SQL requires all datasource fields to be virtual or for all fields to be not virtual.
<dataSource id="leaseDS">
<table name="ls" role="main"/>
<field table="ls" name="ls_id"/>
<field table="ls" name="bl_id"/>
</dataSource>
Enclosing Element:
This tag is a direct child of the
<view>
element.
Encloses:
This tag encloses the
<table>, <field>, <restriction>,
and
<sortField>
child elements.
Attributes
| Attribute | Description | Valid Values | Optional |
|---|---|---|---|
| id |
Specifies an id for the dataSource. Used by panels'
dataSourceId
to link the panel control to the dataSource
|
a string unique within the view | yes |
| types | Specifies a dataSource type that receives special processing |
grouping
.
|
yes |
| databaseRole | Specifies a role for the defined dataSource |
data, schema, security
, defaulting to
data
|
yes |
| applyVpaRestrictions | Use a value of false to disable the auto-generated VPA (Virtual Private Archibus) restriction. Setting this option to false is not supported in Data Transfer actions as it creates a security hole |
true
,
false
, defaulting to
true
|
yes |
| distinct |
Use a value of
true
to specify a
SELECT DISTINCT
query
|
true, false
, defaulting to
false
|
yes |