Searching for candidates with empty fields

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

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
SLabbe
User
Posts: 1
Joined: Wed Oct 09, 2019 5:32 am

Searching for candidates with empty fields

Post by SLabbe »

Hello!

I am trying to search for candidates that have NO e-mail address or NO phone number.
But in the Search tool, I can't seem to select the option of searching only "empty field".

I could not find the answer on this forum nor anywhere on Bullhorn.

Hw do I do that ?

Thanks a lot
mfinleybh
User
Posts: 44
Joined: Thu Feb 21, 2019 9:48 am

Re: Searching for candidates with empty fields

Post by mfinleybh »

Greetings SLabbe,

In app, if you click on the columns for email or phone number and sort by ascending/descending you should see results pulled back with blanks in order.

Please let me know if you have any questions or concerns.

Best,

Mathew Finley | Analyst, Enterprise Support | Boston

Bullhorn Support US: 617-478-9126
Bullhorn Support UK: 44 800 032 2848
Bullhorn Support Australia: 61 28 073 5089
Bullhorn Support International: 617-478-9131
Kaetlynne
User
Posts: 1
Joined: Thu Jul 30, 2020 5:04 am

Re: Searching for candidates with empty fields

Post by Kaetlynne »

Hi,

Related to this, I want to filter out those candidates who have a field populated, so exclude everyone who has that field empty. I need to see how many candidates have that field filled in. Is there a way to exclude those with empty fields?
lauraingalls
User
Posts: 16
Joined: Wed Feb 26, 2020 12:19 pm

Re: Searching for candidates with empty fields

Post by lauraingalls »

Hi Kaetlynne,

The best way to do this would be to use the Advanced Criteria Search to include any letter of the alphabet using wildcards (a* b* c*, etc). This should remove any candidates that do not have values in those fields.

-Laura
Laura Ingalls
Bullhorn Enterprise Support Analyst
mmehrbod
User
Posts: 1
Joined: Fri Nov 06, 2020 5:17 pm

Re: Searching for candidates with empty fields

Post by mmehrbod »

using a* allowed me to see all that start with letter: a.
can you please assist with the advanced search criteria commands?
how can we exclude all entries which are blank. or start or end with a value?
can we filter based of number higher/lower than a value? etc..
please give some examples of advanced search commands like the one you mentioned as a*

appreciate.
bbagwell
User
Posts: 32
Joined: Wed Feb 26, 2020 12:17 pm

Re: Searching for candidates with empty fields

Post by bbagwell »

mmehrbod wrote: Tue Nov 10, 2020 6:02 pm using a* allowed me to see all that start with letter: a.
can you please assist with the advanced search criteria commands?
how can we exclude all entries which are blank. or start or end with a value?
can we filter based of number higher/lower than a value? etc..
please give some examples of advanced search commands like the one you mentioned as a*

appreciate.
If you are working with email addresses, you can place an additional criteria on the search for a* then exclude this from the search, so no @ symbols are returned.

If you are working with a free text field, you can type in a*, b*, c* --> z* as separate entries to exclude these letters from being returned, thus only returning blank fields.

Some columns can be sorted - if you are working with one of these fields then you can sort ascending, which will place all the empty records at the top.

Lastly, you can export the data to a .CSV file, which you can then pull through to a spreadsheet program in order to perform further analysis if necessary.

Should you require additional support within the app, we ask that you log a support ticket so we can assist you further.
Post Reply