Filter Django queryset with multiple variables
I would like to pass one or many GET variables to filter a queryset. I have tried the following code to create a dictionary of the variables and apply the filter, but testing with two variables it appears to only be filtering on the final dictionary variables.
for k,v in mydict.items():
qs = mymodel.objects.filter(**{"%s__contains" % k: v})
Can anyone point me in the right direction as to where I am going wrong?
django django-models django-queryset
edited Nov 22 '18 at 0:54
Selcuk
26.5k75369
asked Nov 22 '18 at 0:13
cr1cr1
928
add a comment |
I would like to pass one or many GET variables to filter a queryset. I have tried the following code to create a dictionary of the variables and apply the filter, but testing with two variables it appears to only be filtering on the final dictionary variables.
for k,v in mydict.items():
qs = mymodel.objects.filter(**{"%s__contains" % k: v})
Can anyone point me in the right direction as to where I am going wrong?
django django-models django-queryset
edited Nov 22 '18 at 0:54
Selcuk
26.5k75369
asked Nov 22 '18 at 0:13
cr1cr1
928
add a comment |
I would like to pass one or many GET variables to filter a queryset. I have tried the following code to create a dictionary of the variables and apply the filter, but testing with two variables it appears to only be filtering on the final dictionary variables.
for k,v in mydict.items():
qs = mymodel.objects.filter(**{"%s__contains" % k: v})
Can anyone point me in the right direction as to where I am going wrong?
django django-models django-queryset
edited Nov 22 '18 at 0:54
Selcuk
26.5k75369
asked Nov 22 '18 at 0:13
cr1cr1
928
I would like to pass one or many GET variables to filter a queryset. I have tried the following code to create a dictionary of the variables and apply the filter, but testing with two variables it appears to only be filtering on the final dictionary variables.
for k,v in mydict.items():
qs = mymodel.objects.filter(**{"%s__contains" % k: v})
Can anyone point me in the right direction as to where I am going wrong?
django django-models django-queryset
django django-models django-queryset
edited Nov 22 '18 at 0:54
Selcuk
26.5k75369
asked Nov 22 '18 at 0:13
cr1cr1
928
edited Nov 22 '18 at 0:54
Selcuk
26.5k75369
asked Nov 22 '18 at 0:13
cr1cr1
928
edited Nov 22 '18 at 0:54
Selcuk
26.5k75369
edited Nov 22 '18 at 0:54
Selcuk
26.5k75369
edited Nov 22 '18 at 0:54
Selcuk
26.5k75369
26.5k75369
asked Nov 22 '18 at 0:13
cr1cr1
928
asked Nov 22 '18 at 0:13
cr1cr1
928
asked Nov 22 '18 at 0:13
cr1cr1
928
928
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You are creating a new queryset in each iteration from scratch instead of chaining them. Try changing your code to:
qs = mymodel.objects.all()
for k, v in mydict.items():
qs = qs.filter(**{"%s__contains" % k: v})
answered Nov 22 '18 at 0:26
SelcukSelcuk
26.5k75369
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%2f53422201%2ffilter-django-queryset-with-multiple-variables%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
You are creating a new queryset in each iteration from scratch instead of chaining them. Try changing your code to:
qs = mymodel.objects.all()
for k, v in mydict.items():
qs = qs.filter(**{"%s__contains" % k: v})
answered Nov 22 '18 at 0:26
SelcukSelcuk
26.5k75369
add a comment |
You are creating a new queryset in each iteration from scratch instead of chaining them. Try changing your code to:
qs = mymodel.objects.all()
for k, v in mydict.items():
qs = qs.filter(**{"%s__contains" % k: v})
answered Nov 22 '18 at 0:26
SelcukSelcuk
26.5k75369
add a comment |
You are creating a new queryset in each iteration from scratch instead of chaining them. Try changing your code to:
qs = mymodel.objects.all()
for k, v in mydict.items():
qs = qs.filter(**{"%s__contains" % k: v})
answered Nov 22 '18 at 0:26
SelcukSelcuk
26.5k75369
You are creating a new queryset in each iteration from scratch instead of chaining them. Try changing your code to:
qs = mymodel.objects.all()
for k, v in mydict.items():
qs = qs.filter(**{"%s__contains" % k: v})
answered Nov 22 '18 at 0:26
SelcukSelcuk
26.5k75369
answered Nov 22 '18 at 0:26
SelcukSelcuk
26.5k75369
answered Nov 22 '18 at 0:26
SelcukSelcuk
26.5k75369
answered Nov 22 '18 at 0:26
SelcukSelcuk
26.5k75369
26.5k75369
add a comment |
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%2f53422201%2ffilter-django-queryset-with-multiple-variables%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
