英文:
C# MongoDB - Filtering nested array data
问题
我是MongoDB的新手，正在尝试在C#上使用它。假设我有这样的文档：
[{"Number": "2140007529","Name": "ABC","IsInactive": true,"EntryList": [{"Timestamp": "2022-06-01T14:00:00.000+00:00","Value": 21564.0},{"Timestamp": "2022-07-01T21:31:00.000+00:00","Value": 21568.0},{"Timestamp": "2022-08-02T21:21:00.000+00:00","Value": 21581.642},{"Timestamp": "2022-09-02T15:42:00.000+00:00","Value": 21593.551},{"Timestamp": "2022-09-26T13:00:00.000+00:00","Value": 21603}]},{"Number": "2220000784","Name": "XYZ","IsInactive": false,"EntryList": [{"Timestamp": "2022-09-26T13:00:00.000+00:00","Value": 0.0},{"Timestamp": "2022-10-01T08:49:00.000+00:00","Value": 5.274},{"Timestamp": "2022-11-01T09:56:00.000+00:00","Value": 76.753},{"Timestamp": "2022-12-01T19:43:00.000+00:00","Value": 244.877},{"Timestamp": "2023-01-01T11:54:00.000+00:00","Value": 528.56},{"Timestamp": "2023-02-01T17:21:00.000+00:00","Value": 802.264}]}]
我想要获取IsInactive标志为false的文档，但对于EntryList，只返回大于2022-12-31的时间戳。结果应该如下所示：
{"Number": "2220000784","Name": "XYZ","IsInactive": false,"EntryList": [{"Timestamp": "2023-01-01T11:54:00.000+00:00","Value": 528.56},{"Timestamp": "2023-02-01T17:21:00.000+00:00","Value": 802.264}}}
所以，这是我的问题：如何在C#中筛选返回值中的嵌套数组。感谢您的帮助！
我尝试使用MongoDB Compass的聚合功能来获取结果，它在MongoDB Compass中可以工作，但在C#中不行。
英文:
i am new on MongoDB and i am trying to use it in C# context. Let´s say, i have documents like this:
[{"Number": "2140007529","Name": "ABC","IsInactive": true,"EntryList": [{"Timestamp": "2022-06-01T14:00:00.000+00:00","Value": 21564.0},{"Timestamp": "2022-07-01T21:31:00.000+00:00","Value": 21568.0},{"Timestamp": "2022-08-02T21:21:00.000+00:00","Value": 21581.642},{"Timestamp": "2022-09-02T15:42:00.000+00:00","Value": 21593.551},{"Timestamp": "2022-09-26T13:00:00.000+00:00","Value": 21603}]},{"Number": "2220000784","Name": "XYZ","IsInactive": false,"EntryList": [{"Timestamp": "2022-09-26T13:00:00.000+00:00","Value": 0.0},{"Timestamp": "2022-10-01T08:49:00.000+00:00","Value": 5.274},{"Timestamp": "2022-11-01T09:56:00.000+00:00","Value": 76.753},{"Timestamp": "2022-12-01T19:43:00.000+00:00","Value": 244.877},{"Timestamp": "2023-01-01T11:54:00.000+00:00","Value": 528.56},{"Timestamp": "2023-02-01T17:21:00.000+00:00","Value": 802.264}]}]
I want to get the document where the IsInactive flag is false. But for the EntryList there should be returned entries greater than Timestamp 2022-12-31 only.I should look like this:
{"Number": "2220000784","Name": "XYZ","IsInactive": false,"EntryList": [{"Timestamp": "2023-01-01T11:54:00.000+00:00","Value": 528.56},{"Timestamp": "2023-02-01T17:21:00.000+00:00","Value": 802.264}]}
So, here is my question. How can i filter nested arrays in return value with C#. Thanks for help!
I tried to get the result with aggregate function of MongoDB in MongoDB Compass. I got it work with but not in C#.
答案1
得分: 0
我认为您正在寻找类似于此查询的查询。因此，您可以尝试类似于以下代码的内容：
var desiredTimestamp = new DateTime(2022, 12, 31);var results = collection.AsQueryable().Where(x => x.IsInactive == false && x.EntryList.Any(e => e.Timestamp >= desiredTimestamp)).Select(obj => new{Number = obj.Number,Name = obj.Name,IsInactive = obj.IsInactive,EntryList = obj.EntryList.Where(e => e.Timestamp >= desiredTimestamp).ToList()}).ToList()
请注意，我假设您的 Timestamp 是日期类型，否则您无法比较日期和字符串。
英文:
I think you are looking for a query similar to this one.
So you can try something like this code:
var desiredTimestamp = new DateTime(2022, 12, 31);var results = collection.AsQueryable().Where(x => x.IsInactive == false && x.EntryList.Any(e => e.Timestamp >= desiredTimestamp)).Select(obj => new{Number = obj.Number,Name = obj.Name,IsInactive = obj.IsInactive,EntryList = obj.EntryList.Where(e => e.Timestamp >= desiredTimestamp).ToList()}).ToList()
Note that I'm assuming your Timestamp is a date type, otherwise you can't compare date and string.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论