I'm using Oracle Database and table consist of Title,Description,Language columns. Using BCS and creating BDCM file, I'm able to get all the data from Oracle Database. I could make managed properties (owsCusTitle,owsCusDESCR,owsLanguage) and link this to the crawled property and everything is OK. Now in my application, I'm showing data using search rest API like this:
http://mk3.spha.com/sites/search/_api/search/query?rowlimit=5&selectproperties='owsCusTitle,owsCusDESCR'&sourceid='a3dcf0d0-a1fe-409e-bb84-f407fc4b6be2'&querytext='title:"man*"'
But there are many records with owsCusTitle column as blank. I don't want to show those records. Is there any way to filter custom managed property in the query itself ?