C# NEST elasticsearch source filtering returning null for most of the fields

Question

I am new to Elasticsearch with .NET using NEST. I am trying to execute a simple search to match all and interested with only few properties. I am not able to get the values for almost all the fields in the source. all shows as null value

The index already exists in elasticsearch.

I have a class representing the type.

public class DocType
{
    public long CommunicationsDate { get; set; }
    public string ControlNumber { get; set; }
    public string Kind { get; set; }
    public string PrimaryCommuncationsName { get; set; }
    public float RiskScore { get; set; }
}

and my mapping is:

PUT relativity
{
  "mappings": {
    "doctype": {
      "properties": {
        "comms_date": {
          "type": "date"
        },
        "control_number": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "kind": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "primary_comms_name": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "risk_score": {
          "type": "float"
        }
      }
    }
  }
}

The following query returns Hits count correctly but the values are null except for the Kind property. Not sure what am i doing wrong here. Is this because the property names are different in c# class or something else?

    return await _connection.Get().SearchAsync(s =>
    {       
        var searchDescriptor = s.Index("relativity")
                                .Type("DocType")
                                .Size(100)
                                .Source(sf => sf
                                    .Includes(i => i
                                        .Fields(
                                            f => f.ControlNumber,
                                            f => f.PrimaryCommuncationsName,
                                            f => f.RiskScore,
                                            f => f.Kind,
                                            f => f.CommunicationsDate
                                        )
                                    )
                                );

    }

C# NEST elasticsearch source filtering returning null for most of the fields

Answers (1)

Related Questions