我正在尝试使用NEST从Elasticsearch检索数据。一切都很好,但是NEST的所有字段都返回null。然而,在调试模式下,我看到它正确地计算了文档数量,但没有显示字段的值。
也许我的映射不正确?任何回答都会有所帮助。谢谢。
通过Postman获取ElasticSearch文档的编辑。
我已经完成的部分:
- 检查过映射,看起来没问题
- 尝试了字符串查询
- 尝试获取源代码并读取数据
- 尝试 NEST返回 null 而不是字段 ,但这些解决方案都没有帮助
- 将Product.cs字段名称更改为camelCase也没有帮助
这是我现在的代码:
public class ElasticSearch
{
private ElasticClient _client;
public ElasticSearch()
{
var node = new Uri("http://localhost:9200");
var settings = new ConnectionSettings(node);
settings.DefaultIndex("logsystem.logs");
_client = new ElasticClient(settings);
}
public void searchResults()
{
var searchResults = _client.Search<Product>(s => s.AllIndices());
}
}
Product.cs
[BsonIgnoreExtraElements]
public class Product
{
[BsonId]
[BsonIgnore]
public ObjectId Id { get; set; }
[Required]
public string Name { get; set; }
[Required]
public string ProductLicenseKey { get; set; }
[Required]
public string Action { get; set; }
[Required]
public string ActionName { get; set; }
[Required]
public string MachineId { get; set; }
}
ElasticSearch中的映射:
{
"logsystem.logs": {
"mappings": {
"properties": {
"Action": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"ActionName": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"MachineId": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"Name": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"ProductLicenseKey": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
}
}
}
也许我的映射不正确?任何回答都会有所帮助。谢谢。
通过Postman获取ElasticSearch文档的编辑。
{
"took": 11,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 6,
"relation": "eq"
},
"max_score": 1.0,
"hits": [
{
"_index": "logsystem.logs",
"_type": "_doc",
"_id": "5e5c1ca2aaa6f1245cc38895",
"_score": 1.0,
"_source": {
"Action": "Button",
"ActionName": "Fixed Single Generation",
"MachineId": "987-654-321",
"Name": "System",
"ProductLicenseKey": "123-456-789"
}
},
{
"_index": "logsystem.logs",
"_type": "_doc",
"_id": "5e5c1cb0aaa6f1245cc38896",
"_score": 1.0,
"_source": {
"Action": "Button",
"ActionName": "Fixed Multiple Generation",
"MachineId": "987-654-321",
"Name": "System",
"ProductLicenseKey": "123-456-789"
}
},
{
"_index": "logsystem.logs",
"_type": "_doc",
"_id": "5e5c1cbdaaa6f1245cc38897",
"_score": 1.0,
"_source": {
"Action": "Button",
"ActionName": "Trackers Single Generation",
"MachineId": "987-654-321",
"Name": "System",
"ProductLicenseKey": "123-456-789"
}
},
{
"_index": "logsystem.logs",
"_type": "_doc",
"_id": "5e5c1ccbaaa6f1245cc38898",
"_score": 1.0,
"_source": {
"Action": "Button",
"ActionName": "Trackers Multiple Generation",
"MachineId": "987-654-321",
"Name": "System",
"ProductLicenseKey": "123-456-789"
}
},
{
"_index": "logsystem.logs",
"_type": "_doc",
"_id": "5e5c1cd3aaa6f1245cc38899",
"_score": 1.0,
"_source": {
"Action": "Button",
"ActionName": "Fixed Multiple Generation",
"MachineId": "987-654-321",
"Name": "System",
"ProductLicenseKey": "123-456-789"
}
},
{
"_index": "logsystem.logs",
"_type": "_doc",
"_id": "5e5c1ce0aaa6f1245cc3889a",
"_score": 1.0,
"_source": {
"Action": "Button",
"ActionName": "Tree Generation",
"MachineId": "987-654-321",
"Name": "System",
"ProductLicenseKey": "123-456-789"
}
}
]
}
}