Nest ElasticSearch adding conditional Terms

Question

I have the following Query that I am building up, notice that filtering on the companyGroupId I cant seem to find suitable way to add and conditional Term.

I would like to check the includeTerminationDate value and conditionally add the term

So in a nutshell, if false don't return records with an termination date.

private Func<QueryContainerDescriptor<EmployeeDocument>, QueryContainer> EmployeeSearchQuery(string query, long companyGroupId, bool includeTerminationDate)
        {
            return q => q
                            .MultiMatch(m => m
                                .Query(query)

                                .Type(TextQueryType.MostFields)
                                .MinimumShouldMatch("90%")
                                .Fields(f => f
                                    .Field(ff => ff.FullName, 3)
                                    .Field(ff => ff.Number, 3)
                                    .Field(ff => ff.Email)
                                    .Field(ff => ff.JobNumber)
                                    .Field(ff => ff.Description))) && q.Term(f => f.CompanyGroupId, companyGroupId);
        }

The one why would just be to duplicate the code and add the Term per the condition. But i would like to keep to the DRY Principle. The other way would be something like the below, which I cant seem to figure out.

return q => q
                            .MultiMatch(m => m
                                .Query(query)

                                .Type(TextQueryType.MostFields)
                                .MinimumShouldMatch("90%")
                                .Fields(f => f
                                    .Field(ff => ff.FullName, 3)
                                    .Field(ff => ff.Number, 3)
                                    .Field(ff => ff.Email)
                                    .Field(ff => ff.JobNumber)
                                    .Field(ff => ff.Description))) && q.Term(f => f.CompanyGroupId, companyGroupId)
                                                                     && !includeTerminationDate ? q.Term(f => f.TerminationDate, null) : 'Otherwise do not include term';

Russ Cam · Accepted Answer · 2018-05-16 23:21:49Z

One way to achieve this would be to convert the expression to a method group, and conditionally add the query

private Func<QueryContainerDescriptor<EmployeeDocument>, QueryContainer> EmployeeSearchQuery(string query, long companyGroupId, bool includeTerminationDate)
{
    return q =>
    {
        var qc = q.MultiMatch(m => m
                   .Query(query)
                   .Type(TextQueryType.MostFields)
                   .MinimumShouldMatch("90%")
                   .Fields(f => f
                       .Field(ff => ff.FullName, 3)
                       .Field(ff => ff.Number, 3)
                       .Field(ff => ff.Email)
                       .Field(ff => ff.JobNumber)
                       .Field(ff => ff.Description))) && 
                q.Term(f => f.CompanyGroupId, companyGroupId);

        // whatever your logic is for adding termination date
        if (includeTerminationDate)
            qc &= q.Term(f => f.TerminationDate, DateTime.UtcNow);

        return qc;
    };
}

Then to use

client.Search<EmployeeDocument>(s => s
    .Query(EmployeeSearchQuery("query", 2, false))
);

emits

{
  "query": {
    "bool": {
      "must": [
        {
          "multi_match": {
            "type": "most_fields",
            "query": "query",
            "minimum_should_match": "90%",
            "fields": [
              "fullName^3",
              "number^3",
              "email",
              "jobNumber",
              "description"
            ]
          }
        },
        {
          "term": {
            "companyGroupId": {
              "value": 2
            }
          }
        }
      ]
    }
  }
}

and

client.Search<EmployeeDocument>(s => s
    .Query(EmployeeSearchQuery("query", 2, true))
);

emits

{
  "query": {
    "bool": {
      "must": [
        {
          "multi_match": {
            "type": "most_fields",
            "query": "query",
            "minimum_should_match": "90%",
            "fields": [
              "fullName^3",
              "number^3",
              "email",
              "jobNumber",
              "description"
            ]
          }
        },
        {
          "term": {
            "companyGroupId": {
              "value": 2
            }
          }
        },
        {
          "term": {
            "terminationDate": {
              "value": "2018-05-16T23:21:16.8309753Z"
            }
          }
        }
      ]
    }
  }
}

Ah is that how you do it I was struggling to add the condition did not realize I could just change it to an Method group

Collectives™ on Stack Overflow

Nest ElasticSearch adding conditional Terms

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related