It’s been so long since I’ve worked without these that I forgot that it’s not part an parcel of an implementation if said implementation was done long enough ago. I first got acquainted with TCC in late 2005 and the TCC_Touchpoints weren’t released until November of 2009.
So without further ado, here is the documentation on it as well as an empty touchpoints to get you started.
I’ve had to do this for a couple of reasons, mainly job types and such in the talent user entity and then again in any one to many users like groups and types.
<quer:projection id="listAggJobType" alias="JobType">
<quer:query projectedClass="Application" alias="talentUserJobType">
<quer:projections>
<quer:projection alias="talentUserJobType_list" projectedValueType="string">
<quer:customFunction name="listagg">
<quer:field path="Candidate,TalentUser,JobTypes,Description"/>
<quer:string> ~ </quer:string>
</quer:customFunction>
</quer:projection>
</quer:projections>
<quer:filterings>
<quer:filtering>
<quer:equal>
<quer:field path="Number"/>
<quer:field ownerQuery="MainQuery" path="Number"/>
</quer:equal>
</quer:filtering>
</quer:filterings>
</quer:query>
</quer:projection>
About Me