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.
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. |
Example Scripts
<FilterFromList ListName="O365GroupList">
<SetParam ColumnID="displayName" Value="GroupName"/>
</FilterFromList>
<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:
<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>