Query Operation: Using Notes to find Candidates

Forum for users and developers of Bullhorn's Webservices API suite

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
shetc
User
Posts: 17
Joined: Fri Jul 20, 2012 2:46 pm

Query Operation: Using Notes to find Candidates

Post by shetc » Mon Dec 01, 2014 11:47 am

Hi All,

I am trying to use the action property of the Note entity to filter out Candidate entities via the Query operation, like so:

Code: Select all

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:apis="http://apiservice.bullhorn.com/">
   <soapenv:Header/>
   <soapenv:Body>
      <apis:query>
          <session>
          </session>
         <query>
           <entityName>Candidate</entityName>
           <orderBys>userID</orderBys>
           <where>userID in (select distinct n.personReferenceID from Note n where n.action = 'Web Response')</where>
         </query>
      </apis:query>
   </soapenv:Body>
</soapenv:Envelope>
However, I am getting the following error response:

Code: Select all

<faultstring>-99999: org.hibernate.QueryException: could not resolve property: personReferenceID of: com.bullhorn.entity.note.Note [SELECT a.id FROM com.bullhorn.entity.candidate.Candidate a WHERE dateAdded > '11/23/2014 12:00:00 AM' and userID in (select distinct n.personReferenceID from com.bullhorn.entity.note.Note n where n.action = 'Web Response') ORDER BY userID]</faultstring>
Is it possible to do this sort of filtering via the Query operation?

Thanks,

Steve Hiller
Senior Analyst/Programmer
Randstad USA
t: 954.308.8230 | m: 954.438.845

s.emmons
User
Posts: 333
Joined: Wed Dec 31, 1969 8:00 pm

Re: Query Operation: Using Notes to find Candidates

Post by s.emmons » Fri Dec 12, 2014 3:15 pm

Hi Steve,

I'm not sure that where clause will be valid, but can you try running it as "personReference.id"?
Sam Emmons
Enterprise Team Lead
BULLHORN
US Support 617-478-9126

Post Reply