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., ‘&lt;’ rather than ‘<’) yes