Job Submissions Filtered by Status

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

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
kelleymedica
User
Posts: 4
Joined: Fri Oct 30, 2020 3:30 pm

Job Submissions Filtered by Status

Post by kelleymedica »

Hi,

I'm trying to get job submissions for a specific job order with a specific status. Below is my request URL (without sensitive information). This returns an empty array for me, which should not be the case. When I request this without any status requirement I get all the submissions successfully, including those with the status I want to filter for.

Code: Select all

const requestUrl = `${CONFIG.BH_REST_URL}/search/JobSubmission?query=jobOrder.id:${ID}%20AND%20status:Client%20Submission&BhRestToken=${CONFIG.BH_REST_TOKEN}&fields=id,candidate,comments,status,jobOrder,sendingUser,source&count=75&sort=status`
Thank you!
Kelley
davidchalfin
User
Posts: 7
Joined: Mon Oct 05, 2020 11:10 am

Re: Job Submissions Filtered by Status

Post by davidchalfin »

Hello,

When it comes to filtering things like this, the specific status of the job order needs to be referenced. I would recommend to start with to check the field mappings to confirm the value of the status you are wanting to filter for and be sure that you are using the actual value rather than just the display value. Additionally, I would test to see if this also occurs when filtering for a different status or if the issue is only with this status.

Please let me know what you see!
kelleymedica
User
Posts: 4
Joined: Fri Oct 30, 2020 3:30 pm

Re: Job Submissions Filtered by Status

Post by kelleymedica »

Thanks for the reply, David! Turns out I was missing encoded quotations around the status actually. For anyone that ends up seeing this looking for a solution, this is a working version of that request url for NodeJS to filter job submissions by a status.

Code: Select all

${CONFIG.BH_REST_URL}/search/JobSubmission?query=(jobOrder.id:${id}%20AND%20status:%22Client%20Submission%22%20AND%20isDeleted:0)&BhRestToken=${CONFIG.BH_REST_TOKEN}&fields=id,candidate,comments,dateAdded,status,owners,sendingUser
And if you're trying to capture a few different statuses:

Code: Select all

${CONFIG.BH_REST_URL}/search/JobSubmission?query=(jobOrder.id:${id}%20AND%20status:(%22Client%20Submission%22%20OR%20%22Second%20Status%22)%20AND%20isDeleted:0)&BhRestToken=${CONFIG.BH_REST_TOKEN}&fields=id,candidate,comments,dateAdded,status,owners,sendingUser
Post Reply