<relatedlist>

Displays data contained in relational tables; allowed in input views or single record display views; nested <eocfield> tags must have table and type set.

<relatedlist> attributes
Attribute	Allowed Values	Requirements	Description
table	%tablename	Required	Name of the table. Use the table and type attributes on any <eocfields> within the <relatedlist>.
sort	%tablename	Optional	What field to sort by.
applyIncidentFilter	(false\|true\|) false	Optional	Applies incident validation for record retrieval. By default, due to backwards compatibility, validation is not performed.
filter	SQL	Optional	Filter criteria to be applied in SQL query WHERE clause.

Example

Copy Code

<relatedlist table="Deployments">
<eocfield name="FieldName" table="Deployments" type="rl" /> <br />
</releatedlist>

<rlid> Attribute and IAP

If a <relatedlist> is repeated within an <eocrepeatallrecords> tag and not contained by a second tag, use <rlid>. <rlid> attributes are given to <relatedlists> to avoid repetition when a <relatedlist> is used twice in one view.

There is no set <rlid> value for a <relatedlist>. The <rlid> value for a particular <relatedlist> does not have to be the same in all views it appears in. The <rlid> is strictly a user-defined unique identifier for a <relatedlist> in a particular view.

Copy Code

<eocrepeatallrecords>

    <h1>Display ICS 203 Personnel Information</h1>
    The branches are as follows:
    <relatedlist table="ICS 203 Branch Table" rlid="1">
        <relatedlist table="ICS 204 Division Table">
            Display Division info
        </relatedlist>
    </relatedlist>
    
    <h1>Display ICS 207 Org Chart</h1>
    The org chart is as follows:
    <relatedlist table="ICS 203 Branch Table" rlid="2">
        <relatedlist table="ICS 204 Division Table">
            Display Division info
        </relatedlist>
    </relatedlist>
    
</eocrepeatallrecords>

In the example above, note that the only use of <rlid> is for the repeated table, ICS 203 Branch Table. Repetition occurs when a <relatedlist> is repeated inside an <eocrepeatallrecords> tag and the <relatedlist> is not enclosed in a parent <relatedlist>.

To illustrate this, look at the user of ICS 204 Division Table and note that it is repeated within the overall scope of the <eocrepeatallrecords> tag. However, each of the 204 related lists are contained in a 203 related list. They do not see each other, so there is no repetition. Similarly, the ICS 203 related lists are only in the <eocrepeatallrecords> tag. Therefore, the <rlid> attribute is not required to avoid repetition.