Need to query for blank customTextBlock field

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

Moderators: StaffingSupport, s.emmons, BullhornSupport

Posts: 39
Joined: Mon Apr 11, 2016 12:34 pm

Need to query for blank customTextBlock field

Postby jimh88 » Mon Apr 10, 2017 12:05 pm

I'm trying to find query jobs that have a blank customTextBlock5, but the API returns an error 'could not execute query'.

Code: Select all

{"errorCode"=>400, "errorMessage"=>"javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query", "message"=>"javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query"}

It seems like the query

Code: Select all

customText1 <> ' '
works, but if I switch customText1 to customTextBlock1, it returns an error. I need to be able to look up by the customTextBlock. I simply need to find records that have certain blank fields. The 'IS NOT NULL' option does not work.

Return to “REST API”

Who is online

Users browsing this forum: No registered users and 3 guests