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

AttributesAttribute ValuesValue DescriptionComment
TargetN/AUniquely identifies the grid (grid code name)N/A
ListNameN/AName of the list to use as source of values by which to match row.N/A
ColumnIDN/AVariable name from SetVar in listN/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