Help building a search URL

Forum for users and developers of Bullhorn's API service.

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
maggsweb
User
Posts: 4
Joined: Sun Jul 29, 2018 6:39 pm

Help building a search URL

Post by maggsweb »

Hi

I have a current search URL for JobOrders that works fine and looks like:

'fields' => '*',
'query' => 'isOpen:true',

But what I really want is:

'fields' => 'id, sendouts(total), owner(id,emailaddress)',
'query' => 'isOpen:true AND isDeleted:false AND sendouts.total > 1',

The computed sendouts(total) field doesn't seem to return any different?

The owner(emailaddress) doesn't exist in this results set. Can I get this without a second call?

Can you chain isOpen and isDeleted in the same query? and use > or < to apply logic to eg:sendouts(total) number?

Ideas, examples, or links would be great.

Thanks
ColinC
User
Posts: 67
Joined: Fri Apr 08, 2016 4:54 pm

Re: Help building a search URL

Post by ColinC »

Hello maggsweb,

Most of your answers are found in our documentation here:
http://bullhorn.github.io/rest-api-docs ... tml#search
Specifically the Lucene query piece.

As for adding pieces together you can just use AND, OR, etc.
example: isDeleted:0 AND id:[100 TO 200] AND NOT status:Archive
Colin Coffman
Enterprise Support Analyst
B U L L H O R N
Staffing and Recruiting Software, On Target, On Demand
617-478-9126 (US Support)
+44 800 032 2848 ext. 9131 (UK Support)
dreameral
User
Posts: 6
Joined: Mon Nov 25, 2019 1:04 pm

Re: Help building a search URL

Post by dreameral »

Hi Colin,

Are you sure the id:[100 TO 200] syntax will work as expected? I am trying similar queries on Candidate entity and it looks like Lucene ranges works only for string comparison, not numeric.

Which means, id:[100 TO 200] will also return records with id=1500 because 1500 is between 100 and 200 when compared as string. Even though when getting the /Candidate/meta , I can see that the id field is of type Integer.

With that saying, is there any way to perform range searches on numeric fields?
Post Reply