We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

TCC complex export projection

Received Response
69
Views
1
Comments
edited Sep 13, 2017 3:21PM in Taleo Enterprise Integrations 1 comment

Summary

Complex projection to output system date as a date stamp on output file

Content

Hello - I'm trying to write a complex projection to output the system date as a date stamp on the output file but receive the following error in TCC: ORA-00936: missing expression.  The complex projection i'm using is below.  Any suggestions as to how to export todays system date as a formatted date field?

 

<quer:projection alias="Date" projectedValueType="string" xmlns:quer="http://www.taleo.com/ws/integration/query">
  <quer:customFunction name="TO_CHAR">
      <quer:date type="now"/>
    <quer:string>yyyy-MM-dd</quer:string>
  </quer:customFunction>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!