Need to query for blank customTextBlock field

[jimh88]

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.