FilterFromList: Filter Values from List

Tag: FilterFromList

The FilterFromList function adds value filters to columns from values in a list of SetVar actions.

Detailed Description

The list must contain SetVar actions only.

SetVar actions

Tag Attributes

Attributes

Value Description

Target

Uniquely identifies the grid (grid code name)

ListName

Name of the list to use as source of values by which to match row.

SetParam (child)

One <SetParam ColumnID="…" Value="…"/> child per column to filter: ColumnID is the unique ID of the column, Value the name of the list variable that holds the filter values.

At least one SetParam child is required, and only SetParam children are allowed. Column / variable pairs written as attributes of FilterFromList are rejected.

value-filters-set


Example Scripts

XML
<FilterFromList ListName="O365GroupList">
	<SetParam ColumnID="displayName" Value="GroupName"/>
</FilterFromList>


XML
<ytriaAutomation Console="True" KeepAlive="True">
	<List name="O365GroupList" Action="SetVar" GroupName="Executives"/>
	<List name="O365GroupList" Action="SetVar" GroupName="newsecgroup"/>
	<List name="O365GroupList" Action="SetVar" GroupName="Tailspin Toys"/>
	<FilterFromList ListName="O365GroupList">
		<SetParam ColumnID="displayName" Value="GroupName"/>
	</FilterFromList>
</ytriaAutomation>


More than one SetParam child can be used. Each column is then set with its own list of value filters. A list generated by SetVarListFromGridSelection. Can be used and combined with hard-coded entries:

XML
<ytriaAutomation Console="True" KeepAlive="True">
	<Select Lines="ByValue">
		<SetParam ColumnID="groupType" Value="Security Group"/>
	</Select>
	<SetVarListFromGridSelection ListName="O365GroupList" GroupName="displayName" Type="groupType"/>
	<List name="O365GroupList" Action="SetVar" Type="Distribution list"/>
	<List name="O365GroupList" Action="SetVar" GroupName="Executives"/>
	<List name="O365GroupList" Action="SetVar" GroupName="newsecgroup"/>
	<List name="O365GroupList" Action="SetVar" GroupName="Tailspin Toys"/>
	<UnSelect/>
	<FilterFromList ListName="O365GroupList">
		<SetParam ColumnID="displayName" Value="GroupName"/>
		<SetParam ColumnID="groupType" Value="Type"/>
	</FilterFromList>
</ytriaAutomation>


automation-filter-values-from-list