Filter Values from List

Tag: FilterFromList

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

<FilterFromList ListName="O365GroupList" displayName="GroupName"/>

XML

Tag Attributes

Attributes	Attribute Values	Value Description	Comment
Target	N/A	Uniquely identifies the grid (grid code name)	N/A
ListName	N/A	Name of the list to use as source of values by which to match row.	N/A
ColumnID	N/A	Variable name from SetVar in list	N/A

Detailed Description

The list must contain SetVar actions only.

Example Script 1

<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" displayName="GroupName"/>
</ytriaAutomation>

XML

More than one pair of column ID / variable name can be used. Each column is then set wit its own list of value filters. A list generated by SetVarListFromGridSelection. Can be used and combined with hard-coded entries:

Example Script 2

<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" displayName="GroupName" groupType="Type"/>
</ytriaAutomation>

XML