Hi All,
I am new to this elastic search and Nest. My query is simple, if i wrote in SQL it is something like below.
select * from table1 where column1 = '123' and column2='text' and column3 in (12,11,13) and
--datetime range
How to write the same query in .net to get the data from elastic search specific to one index.
elasticsearchclient.SearchAsync (s => s
.SearchType(SearchType.QueryThenFetch)
.Index(indexname)
.Query(q => q
.Bool (y => y
.Must(mu => mu.Match(a => a.Field("column1").query("column1_SearchValue")))
mu => mu.Match(a => a.Field("Column2").Query(column2_SearchValue))
,c =>c.Term("column3", column3_searchvalue)
).Filter
(z => z.DateRange(r=> r
.Field(x => x.datetime)
.greaterthanequal(fromdate)
.lessthan(nowdate)
)
)
)
I am able to search column1 and column2. But when i am include column3 i am not able to retrieve the values though i have the values. Filter is also working properly. I observed the third column value is passing as "1,2,3,4" instead of "1","2","3","4"