Using Sitecore 9 update 1.
followed Sitecore documentation to implement the site search in Azure PaaS https://doc.sitecore.net/sitecore_experience_platform/setting_up_and_maintaining/search_and_indexing/configure_azure_search
As Azure Search can contain up to 1000 fields I have created custom search index for the large data in Sitecore which is imported from third party and I added the items into custom index.
using simple queries to return the content from the new index, the search is not stable and break multiple times during the day, sometimes it return data and other times not.
var queryable = context.GetQueryable<SearchResultItem>(); queryable = queryable.Filter(i => i.Paths.Contains([MyItem].ID)); queryable = queryable.Filter(i => i.TemplateId == Templates.[MyItem].TemplateID); queryable = queryable.Filter(i => i.Language == Sitecore.Context.Language.Name); var indexresults = queryable.OrderBy(x => x.Name); List<Item> resultList = new List<Item>(); resultList = queryable.Select(n => n.GetItem()).ToList();