Skip to main content
Conga Support

Conditional TableHide using an Operator in Word

Taking the previous Conditional TableHides one step further, you can evaluate whether a specific field value is equal to, not equal to, greater than, or less than a static value or the value of another field. If the evaluation is true, the table will be hidden.  When specifying a detail dataset (report or query), the Conditional TableHide evaluates the first row of data in the specified dataset.

Conditional TableHide does not support null values.

TableHide (using an Operator)

Syntax

Values

DatasetName is the name of the dataset from the Template Builder window.

FieldName is the name of the field you want to evaluate, as it appears in the Template Builder.

Operator specifies if the evaluation should be “equal to,” “not equal to,” ”greater than,” or “less than.” The supported operators are:

= Equals
<> or != Not equal to
> Greater than
< Less than

Value is the value of the field that will force Composer® to hide the table.

Notes

Both Master and detail datasets are supported.

Value must be a number or date field.

Date fields should be formatted as month/day/year (e.g. May 13, 2014 would be 5/13/2014).

Usage

{{TableHide:Pledges:Amount_Pledged:<:200}}

{{TableHide:Contracts:Start_Date:>:5/5/2014}}

{{TableHide:Master:CONTACT_DISPOSITION:=:Satisfied}}

 

This feature is not supported when using nested SOQL queries.