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
79
Views
1
Comments
edited Dec 13, 2022 6:42AM in Taleo Enterprise 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!