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

Offer Close Date - concatenate OfferAccepted and OfferRefused

Accepted answer
10
Views
1
Comments
edited Jan 20, 2020 5:57PM in Taleo Enterprise Integrations 1 comment

Summary

Offer Close Date - concatenate OfferAccepted and OfferRefused

Content

I'm trying to one result of Offer Close Date by concatenating OfferAccepted and OfferRefused.  My projection isn't valid, so what I'm I missing?  I can concatenate them via the GUI, but I can't format the date correctly.

 

<quer:projection id="idOfferCloseDate" alias="OfferCloseDate" xmlns:quer="http://www.taleo.com/ws/integration/query"&gt;
  <quer:concatenate>
    <quer:query projectedClass="Candidate" alias="DateRefusedDate">
      <quer:projections>
        <quer:projection alias="DateRefusedDate" projectedValueType="string">
          <quer:customFunction name="TO_CHAR">
            <quer:maximum>
              <quer:field path="Applications,CurrentOffer,RefusedDate"/>
            </quer:maximum>
            <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!