Exist function in TCC

Summary

Exist function in TCC

Content

Hi,

We have been trying to understand the logic/syntax of the 'Exists' function in TCC.

Has anyone tried to use the same function as we have got a requirement to check if one field value exists in another field.

Grateful if you could share your experiences/solution in case you have come across using this function.

Thanks,

Mahesh

Version

17.4

Code Snippet

<quer:projection alias="Test" xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:field path="FIELD1"/>
<quer:filtering>
<quer:returnsResults>
<quer:projection alias="subQuery" xmlns:quer="http://www.taleo.com/ws/integration/query">
<quer:field path="FIELD2"/>
</quer:projection>
</quer:returnsResults>
</quer:filtering>
</quer:projection>