TCC – Candidate Preferred Phone
When building an export and the spec calls for returning the preferred phone, you can use this decode to avoid all the mouse clicks.
<quer:projection alias="PreferredPhone" xmlns:quer="http://www.taleo.com/ws/integration/query"> <quer:decode> <quer:field path="Candidate,PreferredPhone,Number"/> <quer:integer>1</quer:integer> <quer:field path="Candidate,HomePhone"/> <quer:integer>2</quer:integer> <quer:field path="Candidate,WorkPhone"/> <quer:integer>3</quer:integer> <quer:field path="Candidate,MobilePhone"/> <quer:integer>4</quer:integer> <quer:field path="Candidate,PagerPhone"/> <quer:integer>5</quer:integer> <quer:field path="Candidate,Fax"/> </quer:decode> </quer:projection>