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.
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
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)
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?