Evaluate and Display Custom Column Values
Tag: Evaluate
The self-closing tag Evaluate emulates clicking the 'Evaluate Columns' button found within the Values dialog in scanEZ; it is a required command in order to process the values in a custom column within the values grid.
Detailed Description
At least one custom column must have been created before using Evaluate.
This action triggers the evaluation of all custom columns.
Example Scripts
<Evaluate/>
<YtriaAutomation>
<load server="ACME01/ACME" database="Mailtest.nsf"/>
<focus target="tree" category="Documents" type="Memo"/>
<Values KeepAlive="false">
<SetParam Target="SelectDocumentItems" Field="AddItem" value="Form"/>
<SetParam Target="SelectDocumentItems" Field="AddItem" value="From"/>
<SetParam Target="SelectDocumentItems" Field="AddItem" value="DeliveredDate"/>
<ShowTypeColumns value="false"/>
<AddCustomColumn Name="Created By">
<SetParam Field="TitleOptionType" Value="System"/>
<SetParam Field="TitleOptionSystem" Value="Created By"/>
</AddCustomColumn>
<Evaluate/>
<Export>
<SetParam field="FilePath" value="D:scanEZ-Values.html"/>
<SetParam field="ExportType" value="HTML"/>
<SetParam field="SelectedRowsOnly" value="False"/>
</Export>
</Values>
</YtriaAutomation>
In the script above, the database "Mailtest.nsf" will be loaded into scanEZ and the selection tree focus will be placed on the document category Memo. The Values operation will be launched on these documents and the Values grid's columns will be set to the items "Form", "From", and "Delivered Date". A custom column will then be added using the Note Info value "Created By". The Evaluate action will then trigger the custom column to populate with the individual values of this Note information. All rows within this grid will then be exported to an HTML file, and the Values dialog will close.