Candidate /search by tearsheet ID always return empty result - 02258057

[nsaputro]

Hi,

I have a problem with /search operation on Candidate entity. Bullhorn always returns empty result if queried by tearsheets.id search field.

Query:
tearsheets.id:2

Response:
{
"total" : 0,
"start" : 0,
"count" : 0,
"data" : [ ]
}

Is this a bug?

Thank you.
Nugroho

[nsaputro]

I checked that search by tearsheet id works for ClientContact using the same query so it seems the problem only occurs on Candidate entity.

Could you please check.

Thank you.
Nugroho

[tkobel]

you will get better results if you use shortListIDs:

Code: Select all

search/Candidate?query=shortListIDs:72&fields=

however they may not be the most up to date, depending on when the candidate was lastModified and if the tearsheet was created after that. I am not certain on this but for some tearsheets it will not return all of the candidates. I suspect that the candidates are not associated with the tearsheets through candidate search until another field that also updates the lastModified field is updated.

I ended up getting all the candidates doing an associated entity search of the tearsheets.

Code: Select all

entity/Tearsheet/72/candidates?fields=id&count=500&start=

then you would have to search for the candidates using the ids you get back.

[nsaputro]

I have tried to update candidate after assigning tearsheet but still no records returned. It works on Client Contact entity so I think it is a bug.

I think for now as workaround I will use association entity retrieval although I could not add query expression using this method so I will need to manually filter the result after records retrieved.

Thank you.

[tkobel]

I agree, it's a bug and thank you for looking into my lastModified theory, as I was never able to fully test it. I should mention that the bug also exists when you get the clientContacts by tearsheets.id.

When I also got the clientContacts for a specific tearsheet through query/ClientContact, it also did not return the full list of client contacts for that tearsheet. Some tearsheets had about 1-5 client contacts missing, sometimes more. I calculated about 95% of the client contacts or candidates were returned when doing candidate search by shortListIDs or querying Client Contact by tearsheets.id.

It may be best to get the clientContacts in the same way as the candidates.
If you compare the total candidates and clientContacts from the tearsheet query

Code: Select all

query/Tearsheet?fields=id,candidates,clientContacts,name&where=id>0&count=200&BhRestToken=

You will always get back the same totals when doing to-many associated entity retrieval.

[TedWalters]

Hi Nugroho,

This is Ted from Bullhorn Support. I was able to run a successful /search by tearsheet ID by structuring my query in the following format:

query=tearsheet.id=(2)

Please let me know if you have any questions or if this does not work for you, and I will be happy to help!

Thanks,
Ted Walters
Technical Support Analyst

[nsaputro]

I tested query=tearsheet.id=(2) does not work. Empty record is returned:

{
"total" : 0,
"start" : 0,
"count" : 0,
"data" : [ ]
}

[jimh88]

I tested query=tearsheet.id=(2) does not work. Empty record is returned:

{
"total" : 0,
"start" : 0,
"count" : 0,
"data" : [ ]
}

I used query=tearsheets.id:2 and was able to get a result. However it only returned a single candidate back. There should be more results!

Support, please help!

[maryjohn]

I checked that search by tearsheet id works for ClientContact using the same query so it seems the problem only occurs on Candidate entity.

Could you please check.