Help building a search URL

[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]

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

[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?