How to filter nested documents with mongodb c# driver?
I have the next query that filters a nested array document in a collection and isn't working (always is returning false):
var collection = MongoClientSingleton.GetInstance().GetCollection<Access>
("access");
var filters = Builders<Access>.Filter.Eq("modules", new BsonDocument { {
"value", val }, { "enabled", true }, { "type", type } });
return collection.Find(filters).Any();
I'm having success when I use linq to build the filter:
var filters = Builders<Access>.Filter.Where(a => a.modules.Any(m => m.value == val && m.enabled == true && m.type == type));
But I want do the filter more like the first code shown (with the BsonDocument class).
The class struct of Access and Module are like this:
public class Access
{
...
public List<Module> modules {get; set; }
...
}
public class Module
{
...
public string value { get; set; }
public bool enabled { get; set; }
public string type { get; set; }
...
}
Thanks!
c# mongodb linq
asked Dec 29 '18 at 21:18
José Andrés Cabrera BenettoJosé Andrés Cabrera Benetto
11
add a comment |
I have the next query that filters a nested array document in a collection and isn't working (always is returning false):
var collection = MongoClientSingleton.GetInstance().GetCollection<Access>
("access");
var filters = Builders<Access>.Filter.Eq("modules", new BsonDocument { {
"value", val }, { "enabled", true }, { "type", type } });
return collection.Find(filters).Any();
I'm having success when I use linq to build the filter:
var filters = Builders<Access>.Filter.Where(a => a.modules.Any(m => m.value == val && m.enabled == true && m.type == type));
But I want do the filter more like the first code shown (with the BsonDocument class).
The class struct of Access and Module are like this:
public class Access
{
...
public List<Module> modules {get; set; }
...
}
public class Module
{
...
public string value { get; set; }
public bool enabled { get; set; }
public string type { get; set; }
...
}
Thanks!
c# mongodb linq
asked Dec 29 '18 at 21:18
José Andrés Cabrera BenettoJosé Andrés Cabrera Benetto
11
add a comment |
I have the next query that filters a nested array document in a collection and isn't working (always is returning false):
var collection = MongoClientSingleton.GetInstance().GetCollection<Access>
("access");
var filters = Builders<Access>.Filter.Eq("modules", new BsonDocument { {
"value", val }, { "enabled", true }, { "type", type } });
return collection.Find(filters).Any();
I'm having success when I use linq to build the filter:
var filters = Builders<Access>.Filter.Where(a => a.modules.Any(m => m.value == val && m.enabled == true && m.type == type));
But I want do the filter more like the first code shown (with the BsonDocument class).
The class struct of Access and Module are like this:
public class Access
{
...
public List<Module> modules {get; set; }
...
}
public class Module
{
...
public string value { get; set; }
public bool enabled { get; set; }
public string type { get; set; }
...
}
Thanks!
c# mongodb linq
asked Dec 29 '18 at 21:18
José Andrés Cabrera BenettoJosé Andrés Cabrera Benetto
11
I have the next query that filters a nested array document in a collection and isn't working (always is returning false):
var collection = MongoClientSingleton.GetInstance().GetCollection<Access>
("access");
var filters = Builders<Access>.Filter.Eq("modules", new BsonDocument { {
"value", val }, { "enabled", true }, { "type", type } });
return collection.Find(filters).Any();
I'm having success when I use linq to build the filter:
var filters = Builders<Access>.Filter.Where(a => a.modules.Any(m => m.value == val && m.enabled == true && m.type == type));
But I want do the filter more like the first code shown (with the BsonDocument class).
The class struct of Access and Module are like this:
public class Access
{
...
public List<Module> modules {get; set; }
...
}
public class Module
{
...
public string value { get; set; }
public bool enabled { get; set; }
public string type { get; set; }
...
}
Thanks!
c# mongodb linq
c# mongodb linq
asked Dec 29 '18 at 21:18
José Andrés Cabrera BenettoJosé Andrés Cabrera Benetto
11
asked Dec 29 '18 at 21:18
José Andrés Cabrera BenettoJosé Andrés Cabrera Benetto
11
edited Dec 30 '18 at 19:20
José Andrés Cabrera Benetto
asked Dec 29 '18 at 21:18
José Andrés Cabrera BenettoJosé Andrés Cabrera Benetto
11
asked Dec 29 '18 at 21:18
José Andrés Cabrera BenettoJosé Andrés Cabrera Benetto
11
asked Dec 29 '18 at 21:18
José Andrés Cabrera BenettoJosé Andrés Cabrera Benetto
11
11
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
for complex or nested query, you can try aggregate function. here's a good read about it
https://mikaelkoskinen.net/post/mongodb-aggregation-framework-examples-in-c
answered Dec 31 '18 at 5:03
P. Lai SengP. Lai Seng
1
Helpful link, but in this examples didn't work with nested array type documents..
– José Andrés Cabrera Benetto
Dec 31 '18 at 12:44
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53973408%2fhow-to-filter-nested-documents-with-mongodb-c-sharp-driver%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
for complex or nested query, you can try aggregate function. here's a good read about it
https://mikaelkoskinen.net/post/mongodb-aggregation-framework-examples-in-c
answered Dec 31 '18 at 5:03
P. Lai SengP. Lai Seng
1
Helpful link, but in this examples didn't work with nested array type documents..
– José Andrés Cabrera Benetto
Dec 31 '18 at 12:44
add a comment |
for complex or nested query, you can try aggregate function. here's a good read about it
https://mikaelkoskinen.net/post/mongodb-aggregation-framework-examples-in-c
answered Dec 31 '18 at 5:03
P. Lai SengP. Lai Seng
1
Helpful link, but in this examples didn't work with nested array type documents..
– José Andrés Cabrera Benetto
Dec 31 '18 at 12:44
add a comment |
for complex or nested query, you can try aggregate function. here's a good read about it
https://mikaelkoskinen.net/post/mongodb-aggregation-framework-examples-in-c
answered Dec 31 '18 at 5:03
P. Lai SengP. Lai Seng
1
for complex or nested query, you can try aggregate function. here's a good read about it
https://mikaelkoskinen.net/post/mongodb-aggregation-framework-examples-in-c
answered Dec 31 '18 at 5:03
P. Lai SengP. Lai Seng
1
answered Dec 31 '18 at 5:03
P. Lai SengP. Lai Seng
1
answered Dec 31 '18 at 5:03
P. Lai SengP. Lai Seng
1
answered Dec 31 '18 at 5:03
P. Lai SengP. Lai Seng
1
1
Helpful link, but in this examples didn't work with nested array type documents..
– José Andrés Cabrera Benetto
Dec 31 '18 at 12:44
add a comment |
Helpful link, but in this examples didn't work with nested array type documents..
– José Andrés Cabrera Benetto
Dec 31 '18 at 12:44
Helpful link, but in this examples didn't work with nested array type documents..
– José Andrés Cabrera Benetto
Dec 31 '18 at 12:44
Helpful link, but in this examples didn't work with nested array type documents..
– José Andrés Cabrera Benetto
Dec 31 '18 at 12:44
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53973408%2fhow-to-filter-nested-documents-with-mongodb-c-sharp-driver%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
