TCC – Exporting Attached File Content Using Subqueries (Doc ID 1900597.1)
I saw this while I was digging for some other information and it made me wonder if it will work with exporting issues we see with descriptions and qualifications.
Will have that answer soon…
Goal
When executing the sub-query result of a CLOB or BLOB projection, TCC returns the signature of the underlying object (e.g.: oracle.sql.BLOB@334693be), rather than the actual content.
To get the actual content the projections must use a data type cast, but the lob cast in Oracle has a 4000 characters limit, which is insufficient for many attached files.
Solution
In the complex projection, set the projectedValueType to “[B”, example as following
<quer:projection alias=”BLOB” projectedValueType=”[B” xmlns:quer=”http://www.taleo.com/ws/integration/query”>
See the attached sample for a complete example.
References
NOTE:1047850.1 – SD6210 – Exported Attached Files
NOTE:1047912.1 – SD6243 – Base64 String Decoding
BUG:18642011 – EXPORT FILECONTENT IN SUBQUERIES PROJECTIONS