I am trying to create a Query Module using Object Initialization method, which will build ES query dynamically based on the search criteria, using ElasticSearch.Net and Nest for .Net (version x6.4).
So what I am doing now is creating the building blocks using the following functions:
public TermQuery AddTermQuery(string fieldName, string fieldValue)
{
return new TermQuery { Field = fieldName, Value = fieldValue };
}
public MultiMatchQuery AddMultiMatchQuery(string searchKeyword)
{
return new MultiMatchQuery
{
Query = searchKeyword,
Type = TextQueryType.MostFields,
Analyzer = "standard"
};
}
public BoolQuery AddBoolQuery(\)
{
return new BoolQuery
{
Must = new QueryContainer[] { },
MustNot = new QueryContainer[] { },
Should = new QueryContainer[] { }
};
}
public QueryContainer[] AddMustQuery()
{
return new QueryContainer[] { };
}
public NumericRangeQuery AddNumericRangeQuery(string fieldName, int greaterThanEqualTo, int lessThanEqualTo, int greaterThan = 0, int lessThan = 0)
{
if (greaterThan == 0 || lessThan == 0)
return new NumericRangeQuery { Field = fieldName, GreaterThanOrEqualTo = greaterThanEqualTo, LessThanOrEqualTo = lessThanEqualTo };
else
return new NumericRangeQuery { Field = fieldName, GreaterThan = greaterThan, LessThan = lessThan };
}
If I want to assemble the below-mentioned query using the above functions:
var query = new SearchRequest
{
Query = new BoolQuery
{
Must = new QueryContainer[]
{
new MultiMatchQuery
{
Query = "Political Relations: Soviet Union",
Analyzer = "standard",
Type = TextQueryType.MostFields
}
},
Filter = new QueryContainer[]
{
new BoolQuery
{
Must = new QueryContainer[] { new TermQuery { Field = "documentLevel", Value = 1 } },
MustNot = new QueryContainer[] { new TermQuery { Field = "moduleNumber", Value = 4 } },
Should = new QueryContainer[]
{
new BoolQuery
{
Must =new QueryContainer[]
{
new TermQuery { Field = "coverDateStartSpecified", Value = true},
new TermQuery { Field = "coverDateEndSpecified", Value = true },
new BoolQuery
{
Should = new QueryContainer[]
{
new NumericRangeQuery { Field = "coverDateStartYear", GreaterThanOrEqualTo = 1946, LessThanOrEqualTo = 1975},
new NumericRangeQuery { Field = "coverDateEndYear", GreaterThanOrEqualTo = 1946, LessThanOrEqualTo = 1975}
}
}
},
},
new BoolQuery
{
Must =new QueryContainer[]
{ new NumericRangeQuery { Field = "coverDateYear", GreaterThanOrEqualTo = 1946, LessThanOrEqualTo = 1975},
new BoolQuery
{
Should = new QueryContainer[]
{
new TermQuery { Field = "coverDateStartSpecified", Value = false},
new TermQuery { Field = "coverDateEndSpecified", Value = false }
}
}
},
}
}
}
}
}
};
But I am stuck at the assembling query part with the above-mentioned functions.
public void DocumentQueryEs(DocumentLevel documentLevel, string doi)
{
var searchQuery = new SearchRequest
{
};
}
How can I go about this for the assembling part? Please help, if I am going in the right direction or not or if I am doing anything wrong in this.
Thanks in Advance!!!