Skip to main content
Skip table of contents

Open 'Columns' Interface

Tag: OpenColumns

The OpenColumns action, along with any grid-compatible child actions, lets you automate the process of opening the Columns by Properties window on a set of selected views and setting the dialog's inner grid configuration.



Example Scripts

XML
<OpenColumns KeepAlive="True">
	<Add ColumnID="C1" Position="2"/>
	<Add ColumnID="C6" Position="3"/>
	<Add ColumnID="C7" Position="4"/>
</OpenColumns>

Within the dialog, general grid automation actions can be used as child actions in order to manipulate the grid configuration, sort and filter data, export data from the grid, etc. (See example script below).

XML
<YtriaAutomation>
	<Load Database="Mailtest.nsf" Server="ACME01/ACME"/>
	<Unselect>
		<SetParam Name="All"/>
	</Unselect>
	<Select>
		<SetParam NoteID="hC9E"/>
		<SetParam NoteID="3254"/>
		<SetParam NoteID="3282"/>
	</Select>
	<OpenColumns KeepAlive="False">
		<Add ColumnID="G8" Position="2"/>
		<Add ColumnID="V3" Position="3"/>
		<Add ColumnID="C10" Position="4"/>
		<filter ColumnID="G8" Mode="Contains" Text="Category"/>
		<Select Lines="All"/>
		<Export>
			<SetParam field="FilePath" value="D:viewEZ-columns.html"/>
			<SetParam field="ExportType" value="HTML"/>
			<SetParam field="SelectedRowsOnly" value="false"/>
		</Export>
	</OpenColumns>
</YtriaAutomation>

In the script above, the viewEZ will be launched on the database "Mailtest.nsf" and three views will be selected. The action OpenColumns will the open the 'Columns by Properties' dialog and the child actions will ensure that columns with the IDs of "G8", "V3", and "C10" are added into the grid and placed in positions 2, 3, and 4 respectively. A filter will be enacted on column G8 to find any text containing the string "Category" , and all remaining lines will be selected and exported to an html file named "viewEZ-columns.html". The 'Columns…' dialog will close.


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.