Search OrderJob by dateEnd empty 02244358

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

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
TienNguyen
User
Posts: 2
Joined: Sat May 14, 2016 12:48 pm

Search OrderJob by dateEnd empty 02244358

Post by TienNguyen » Sat May 14, 2016 12:51 pm

i try search dateEnd is empty, but don't working, please help me.


https://xxx.bullhornstaffing.com/rest-s ... y=isOpen:1 AND isDeleted:0 AND status:Active AND isPublic:1&fields=dateEnd,type,salary,id,isOpen,isPublic,status,address,title,description,startDate,categories(name),skills(name),clientCorporation(name),publicDescription&count=20&start=0&BhRestToken=xxxx&sort=type,-startDate,

$query = [
"isOpen:1",
"isDeleted:0",
"status:Active",
"isPublic:1",
//"dateEnd:[* TO ".date("YmdTH:i:s")."]" //. strtotime('now') * 1000,
//'dateEnd:""'
];

SO-BHSupport
User
Posts: 24
Joined: Thu Feb 27, 2014 12:49 pm

Re: Search OrderJob by dateEnd empty

Post by SO-BHSupport » Mon May 16, 2016 9:44 am

Hi Tien,

This is Simon from Bullhorn Support. When searching on Date Fields you can search for empty values by doing the following:

https://xxxx.bullhornstaffing.com/xxxx/ ... sDeleted:0 AND -customDate1:[* TO *] AND NOT status:Archive&BhRestToken=fcf594c3-4fad-4c42-ac82-4ab1caca1fe2

The important part here is "-customDate1:[* TO *]", where you need the - for it to be ignoring these values.

Hope this helps!

Kind regards,

Simon O'Keeffe
Simon O'Keeffe
Enterprise Support Team Lead
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 option 1 (UK Support)

Post Reply