I was using Sharepoint Rest api and the query looked like the one below
http://sitename/HR/_api/web/lists/GetByTitle('Employee')/Items?$top=4000&$filter=( substringof('100',Title) and substringof('ARISPL',Company) and substringof('HIBIS',House_x0020_Name))
Now I want to migrate to Search Api as querying against Note fields is not possible in Rest API
I was able to get items from the list with below query
but I am not sure how to add filters against fields with Contains and a and condition
I tried the below query but it didnt work
Can someone help?
I want to convert the above rest api query to search api query