< restriction />
View Element Reference
< restriction />
This element specifies one piece of an implicit SQL WHERE clause used to filter the records retrieved from the data source.
<restriction
type="sql" sql="mo_id is null"/>
<restriction
type="parsed">
<clause op="=" value="0" table="wr" name="wr_id"/>
</restriction>
Enclosing Element: This tag is a direct child of the <dataSource> element.
Encloses: This tag encloses zero or more <clause> child elements.
Attributes
Attribute | Description | Valid Values | Optional |
---|---|---|---|
type |
Specifies the form of the restriction text, either as explicit SQL text or composed of individual attributes in one or more child
clause
elements
|
sql, parsed | yes |
sql | Specifies the exact text of the WHERE clause (minus the text ‘WHERE’). | text containing valid SQL, using the table name-dot-column name combinations from the database element and HTML character sequences for less than and greater than signs (e.g., ‘<’ rather than ‘<’) | yes |