Have you ever been faced a challenge where you need to use TCC to export a list that pulls data from two separate groups? Standard drag and drop filtering in a TCC export file specifies a logical AND, meaning that all filters must be true for a result to be retrieved. In the example below, both Filter 1 and Filter 2 would need to evaluate to true:
In cases where you need to specify multiple filter items, you can use a complex filter with an OR statement.
If there are only two elements needed, an OR statement may be the way to go. Referring to the example above, say you are looking to pull users that are in one group OR another. In this sample, we are filtering in a user export to only export users in Group1 and Group2:
<quer:filtering xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:or>
<quer:equal>
<quer:field path="UserAccount,Groups,Name"/>
<quer:string>Group1</quer:string>
</quer:equal>
<quer:equal>
<quer:field path="UserAccount,Groups,Name"/>
<quer:string>Group2</quer:string>
</quer:equal>
</quer:or>
</quer:filtering>
Simply copy the above XML snippet and add a new complex filter, remove the default text and adjust the groups for your situation. This is very useful when you need to select more than one element in your filter.
Please let us know if there are other items that you would like us to discuss in future blogs! Our next TCC how-to will review using ‘included in’ to list values.