MongoDB search case insensitive for Field not Value
I am using MongoDB with C# using MongoDB.Driver. Now I want to search data from mongodb collection with case insensitive(For both - Key and Value). For this I have tried below code in C#.
var filter = new List<BsonElement>
{
new BsonElement("IsDeleted", false) // it could be "isdeleted" in database
};
var obj = await collection.FindAsync(new BsonDocument(filterList));
Now, as you can see above code, I want to apply search and fetch data where IsDeleted/isdeleted flag is false. But the issue is, In database for some records the Key is IsDeleted and for some it is isdeleted so the above code is only working where IsDeleted=false But not working where isdeleted=false. So I need a way to make the searching case-insensitive for Key.
c# mongodb asp.net-core mongodb-driver
edited Nov 22 '18 at 11:06
Kirk Larkin
22.3k64364
asked Nov 22 '18 at 10:55
prog1011prog1011
2,09321230
add a comment |
I am using MongoDB with C# using MongoDB.Driver. Now I want to search data from mongodb collection with case insensitive(For both - Key and Value). For this I have tried below code in C#.
var filter = new List<BsonElement>
{
new BsonElement("IsDeleted", false) // it could be "isdeleted" in database
};
var obj = await collection.FindAsync(new BsonDocument(filterList));
Now, as you can see above code, I want to apply search and fetch data where IsDeleted/isdeleted flag is false. But the issue is, In database for some records the Key is IsDeleted and for some it is isdeleted so the above code is only working where IsDeleted=false But not working where isdeleted=false. So I need a way to make the searching case-insensitive for Key.
c# mongodb asp.net-core mongodb-driver
edited Nov 22 '18 at 11:06
Kirk Larkin
22.3k64364
asked Nov 22 '18 at 10:55
prog1011prog1011
2,09321230
You need to fix your code. This cannot be done.
– Neil Lunn
Nov 22 '18 at 10:57
@NeilLunn Could you please explain me where I went wrong So I can modified accordingly.
– prog1011
Nov 22 '18 at 11:02
1
Property names ARE case sensitive. It's part of the BSON specification so there is no way to change that. If you wrote documents with varying case on those properties, then there is no coding to "work around that" and instead you go back and fix the documents where you incorrectly wrote the properties in the incorrect case. You can useOrconditions everywhere, but that's not practical. Just fix the problem instead.
– Neil Lunn
Nov 22 '18 at 11:07
@NeilLunn But like in SQL we know that the column name are case insensitive while we execute the query. So Is there any way in MongoDB ?
– prog1011
Nov 22 '18 at 11:12
This is not SQL. Nor is that a true generalization as I can clearly think of several SQL RDBMS which consider field names case sensitive as well. Only "some" don't. I've been pretty clear and there is nothing more to say on the subject.
– Neil Lunn
Nov 22 '18 at 11:16
add a comment |
I am using MongoDB with C# using MongoDB.Driver. Now I want to search data from mongodb collection with case insensitive(For both - Key and Value). For this I have tried below code in C#.
var filter = new List<BsonElement>
{
new BsonElement("IsDeleted", false) // it could be "isdeleted" in database
};
var obj = await collection.FindAsync(new BsonDocument(filterList));
Now, as you can see above code, I want to apply search and fetch data where IsDeleted/isdeleted flag is false. But the issue is, In database for some records the Key is IsDeleted and for some it is isdeleted so the above code is only working where IsDeleted=false But not working where isdeleted=false. So I need a way to make the searching case-insensitive for Key.
c# mongodb asp.net-core mongodb-driver
edited Nov 22 '18 at 11:06
Kirk Larkin
22.3k64364
asked Nov 22 '18 at 10:55
prog1011prog1011
2,09321230
I am using MongoDB with C# using MongoDB.Driver. Now I want to search data from mongodb collection with case insensitive(For both - Key and Value). For this I have tried below code in C#.
var filter = new List<BsonElement>
{
new BsonElement("IsDeleted", false) // it could be "isdeleted" in database
};
var obj = await collection.FindAsync(new BsonDocument(filterList));
Now, as you can see above code, I want to apply search and fetch data where IsDeleted/isdeleted flag is false. But the issue is, In database for some records the Key is IsDeleted and for some it is isdeleted so the above code is only working where IsDeleted=false But not working where isdeleted=false. So I need a way to make the searching case-insensitive for Key.
c# mongodb asp.net-core mongodb-driver
c# mongodb asp.net-core mongodb-driver
edited Nov 22 '18 at 11:06
Kirk Larkin
22.3k64364
asked Nov 22 '18 at 10:55
prog1011prog1011
2,09321230
edited Nov 22 '18 at 11:06
Kirk Larkin
22.3k64364
asked Nov 22 '18 at 10:55
prog1011prog1011
2,09321230
edited Nov 22 '18 at 11:06
Kirk Larkin
22.3k64364
edited Nov 22 '18 at 11:06
Kirk Larkin
22.3k64364
edited Nov 22 '18 at 11:06
Kirk Larkin
22.3k64364
22.3k64364
asked Nov 22 '18 at 10:55
prog1011prog1011
2,09321230
asked Nov 22 '18 at 10:55
prog1011prog1011
2,09321230
asked Nov 22 '18 at 10:55
prog1011prog1011
2,09321230
2,09321230
You need to fix your code. This cannot be done.
– Neil Lunn
Nov 22 '18 at 10:57
@NeilLunn Could you please explain me where I went wrong So I can modified accordingly.
– prog1011
Nov 22 '18 at 11:02
1
Property names ARE case sensitive. It's part of the BSON specification so there is no way to change that. If you wrote documents with varying case on those properties, then there is no coding to "work around that" and instead you go back and fix the documents where you incorrectly wrote the properties in the incorrect case. You can useOrconditions everywhere, but that's not practical. Just fix the problem instead.
– Neil Lunn
Nov 22 '18 at 11:07
@NeilLunn But like in SQL we know that the column name are case insensitive while we execute the query. So Is there any way in MongoDB ?
– prog1011
Nov 22 '18 at 11:12
This is not SQL. Nor is that a true generalization as I can clearly think of several SQL RDBMS which consider field names case sensitive as well. Only "some" don't. I've been pretty clear and there is nothing more to say on the subject.
– Neil Lunn
Nov 22 '18 at 11:16
add a comment |
You need to fix your code. This cannot be done.
– Neil Lunn
Nov 22 '18 at 10:57
@NeilLunn Could you please explain me where I went wrong So I can modified accordingly.
– prog1011
Nov 22 '18 at 11:02
1
Property names ARE case sensitive. It's part of the BSON specification so there is no way to change that. If you wrote documents with varying case on those properties, then there is no coding to "work around that" and instead you go back and fix the documents where you incorrectly wrote the properties in the incorrect case. You can useOrconditions everywhere, but that's not practical. Just fix the problem instead.
– Neil Lunn
Nov 22 '18 at 11:07
@NeilLunn But like in SQL we know that the column name are case insensitive while we execute the query. So Is there any way in MongoDB ?
– prog1011
Nov 22 '18 at 11:12
This is not SQL. Nor is that a true generalization as I can clearly think of several SQL RDBMS which consider field names case sensitive as well. Only "some" don't. I've been pretty clear and there is nothing more to say on the subject.
– Neil Lunn
Nov 22 '18 at 11:16
You need to fix your code. This cannot be done.
– Neil Lunn
Nov 22 '18 at 10:57
You need to fix your code. This cannot be done.
– Neil Lunn
Nov 22 '18 at 10:57
@NeilLunn Could you please explain me where I went wrong So I can modified accordingly.
– prog1011
Nov 22 '18 at 11:02
@NeilLunn Could you please explain me where I went wrong So I can modified accordingly.
– prog1011
Nov 22 '18 at 11:02
1
1
Property names ARE case sensitive. It's part of the BSON specification so there is no way to change that. If you wrote documents with varying case on those properties, then there is no coding to "work around that" and instead you go back and fix the documents where you incorrectly wrote the properties in the incorrect case. You can use
Or conditions everywhere, but that's not practical. Just fix the problem instead.– Neil Lunn
Nov 22 '18 at 11:07
Property names ARE case sensitive. It's part of the BSON specification so there is no way to change that. If you wrote documents with varying case on those properties, then there is no coding to "work around that" and instead you go back and fix the documents where you incorrectly wrote the properties in the incorrect case. You can use
Or conditions everywhere, but that's not practical. Just fix the problem instead.– Neil Lunn
Nov 22 '18 at 11:07
@NeilLunn But like in SQL we know that the column name are case insensitive while we execute the query. So Is there any way in MongoDB ?
– prog1011
Nov 22 '18 at 11:12
@NeilLunn But like in SQL we know that the column name are case insensitive while we execute the query. So Is there any way in MongoDB ?
– prog1011
Nov 22 '18 at 11:12
This is not SQL. Nor is that a true generalization as I can clearly think of several SQL RDBMS which consider field names case sensitive as well. Only "some" don't. I've been pretty clear and there is nothing more to say on the subject.
– Neil Lunn
Nov 22 '18 at 11:16
This is not SQL. Nor is that a true generalization as I can clearly think of several SQL RDBMS which consider field names case sensitive as well. Only "some" don't. I've been pretty clear and there is nothing more to say on the subject.
– Neil Lunn
Nov 22 '18 at 11:16
add a comment |
0
active
oldest
votes
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%2f53429384%2fmongodb-search-case-insensitive-for-field-not-value%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53429384%2fmongodb-search-case-insensitive-for-field-not-value%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
You need to fix your code. This cannot be done.
– Neil Lunn
Nov 22 '18 at 10:57
@NeilLunn Could you please explain me where I went wrong So I can modified accordingly.
– prog1011
Nov 22 '18 at 11:02
1
Property names ARE case sensitive. It's part of the BSON specification so there is no way to change that. If you wrote documents with varying case on those properties, then there is no coding to "work around that" and instead you go back and fix the documents where you incorrectly wrote the properties in the incorrect case. You can use
Orconditions everywhere, but that's not practical. Just fix the problem instead.– Neil Lunn
Nov 22 '18 at 11:07
@NeilLunn But like in SQL we know that the column name are case insensitive while we execute the query. So Is there any way in MongoDB ?
– prog1011
Nov 22 '18 at 11:12
This is not SQL. Nor is that a true generalization as I can clearly think of several SQL RDBMS which consider field names case sensitive as well. Only "some" don't. I've been pretty clear and there is nothing more to say on the subject.
– Neil Lunn
Nov 22 '18 at 11:16