ImportViewInGrid: insert data from a Notes view into any grid
Tag: ImportViewInGrid
ImportViewInGrid allows you to insert the content of any Notes database view or folder into any grid that contains a corresponding set of data.
Detailed Description
When supplied with a pair of keys that joins the content of a Notes view and the content of a grid (eg. user id), ImportViewGrid appends the content of the wanted columns in the Notes view to the grid.
Tag Attributes
Attributes | Value Description |
---|---|
Server | Server name/org - Required |
Database | Database path - Required |
Name | View name - Required |
ImportKey | key column name in the Notes view - Required |
GridKeyUID | key column unique ID in the grid - Required |
Target | The corresponding Grid Code. Sets the target grid panel - Not Required. If no target is set, the default main grid target will be used. |
SetParam attributes
Attribute | Value Description |
---|---|
Value | Column name in source Notes view |
ColumnID | UID of the grid column to be created NB: “_IMPORTED_" will be added as a prefix to the provided ColumnID. |
ColumnTitle | Title of the grid column to be created NB: if not supplied, the column title of the Notes view is used |
Example Script
<ytriaAutomation>
<focus target="tree" category="Documents"/>
<Values KeepAlive="This">
<SetParam Field="ALl" value="True"/>
<ShowTypeColumns value="false"/>
<Select lines="all"/>
<ImportViewInGrid target="GridValues" server='TheServer/TheOrg' database='names.nsf' Name='($Users)' ImportKey='$38' GridKeyUID='GridColID'>
<SetParam Value='ShortName' ColumnID='ShortName' ColumnTitle='IMPORTED SHORTNAME'/>
<SetParam Value='InternetAddress' ColumnID='Email' ColumnTitle='IMPORTED EMAIL'/>
</ImportViewInGrid>
<UnSelect lines="all"/>
</Values>
</ytriaAutomation>