Need to query for blank customTextBlock field

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

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
jimh88
User
Posts: 39
Joined: Mon Apr 11, 2016 12:34 pm

Need to query for blank customTextBlock field

Post by 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.

Post Reply