<externalexpression>

Pulls data from a table within the same board that is unrelated to the current table; returns a calculation on the data. If outside of an <eocrepeatallrecords> tag, calculations are made on all records (aggregate functions).

<externalexpression> attributes
Attribute	Allowed Values	Requirements	Description
name	CDATA	Required	Name of the external expression.
table	%tablename	Required	Name of the table to pull data from.
board	CDATA	Optional	Name of the board that contains the table.
filter	CDATA	Optional	Filter criterion to be applied in SQL query WHERE clause. SQL Variables can be used.

Example

Copy Code

<externalexpression name="extExpr" table="Other Table"/>count(*)</externalexpression>

You can also pull data from another board's table by using the board attribute in conjunction with the existing table attribute.

Example

Copy Code

<externalexpression name="extExpr" board="BoardName" table="TableinBoardName"/>count(*)</externalexpression>

You can also filter data by using the filter attribute.

Example

Copy Code

<externalexpression name="extExpr" board="BoardName" table="TableinBoardName" filter="(title='' OR title=@username OR title=@positionname)"/>count(*)</externalexpression>

Filter data with <filterlistdropdown> or <search> tags by using the <applyfilter> tag.

Example

Copy Code

<filterlistdropdown id="filterlistdropdownid" field="someField" list="someList"/>
<search id="searchid" field="someOtherField" />
<externalexpression name="extExpr" table="Table"/>
    count(*)
    <applyfilter filterid="filterlistdropdownid" field="fieldInTable"/>
    <applyfilter filterid="searchid" field="otherFieldInTable"/>
</externalexpression>