how to find if string is in a result of a query set in Django

Multi tool use
up vote
1
down vote
favorite
I have the following object result from query set on a model as follow:
ddd = Post_Sub_Category.objects.filter(
category_name__category_name__iexact=dd
).values_list('sub_category_name', flat=True)
the query set I obtained:
<QuerySet ['car', 'spare parts', 'truck', 'motor cycle']>
then tried:
print(ddd.values('sub_category_name'))
I obtained the following result:
<QuerySet [
<Post_Sub_Category: car>,
<Post_Sub_Category: spare parts>,
<Post_Sub_Category: truck>,
<Post_Sub_Category: motor cycle>
]
How to access the values only and make list of them as string:
['car','spare parts','truck','motor cycle'].
the first query set seems that it gave me what I want. However, When I use following if statement. it does not executed:
if 'car' in ddd:
# do some thing
as you can see car
should be in the list. so, I could not understand why the if statement has not been executed.
any help or suggestion?
django
add a comment |
up vote
1
down vote
favorite
I have the following object result from query set on a model as follow:
ddd = Post_Sub_Category.objects.filter(
category_name__category_name__iexact=dd
).values_list('sub_category_name', flat=True)
the query set I obtained:
<QuerySet ['car', 'spare parts', 'truck', 'motor cycle']>
then tried:
print(ddd.values('sub_category_name'))
I obtained the following result:
<QuerySet [
<Post_Sub_Category: car>,
<Post_Sub_Category: spare parts>,
<Post_Sub_Category: truck>,
<Post_Sub_Category: motor cycle>
]
How to access the values only and make list of them as string:
['car','spare parts','truck','motor cycle'].
the first query set seems that it gave me what I want. However, When I use following if statement. it does not executed:
if 'car' in ddd:
# do some thing
as you can see car
should be in the list. so, I could not understand why the if statement has not been executed.
any help or suggestion?
django
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I have the following object result from query set on a model as follow:
ddd = Post_Sub_Category.objects.filter(
category_name__category_name__iexact=dd
).values_list('sub_category_name', flat=True)
the query set I obtained:
<QuerySet ['car', 'spare parts', 'truck', 'motor cycle']>
then tried:
print(ddd.values('sub_category_name'))
I obtained the following result:
<QuerySet [
<Post_Sub_Category: car>,
<Post_Sub_Category: spare parts>,
<Post_Sub_Category: truck>,
<Post_Sub_Category: motor cycle>
]
How to access the values only and make list of them as string:
['car','spare parts','truck','motor cycle'].
the first query set seems that it gave me what I want. However, When I use following if statement. it does not executed:
if 'car' in ddd:
# do some thing
as you can see car
should be in the list. so, I could not understand why the if statement has not been executed.
any help or suggestion?
django
I have the following object result from query set on a model as follow:
ddd = Post_Sub_Category.objects.filter(
category_name__category_name__iexact=dd
).values_list('sub_category_name', flat=True)
the query set I obtained:
<QuerySet ['car', 'spare parts', 'truck', 'motor cycle']>
then tried:
print(ddd.values('sub_category_name'))
I obtained the following result:
<QuerySet [
<Post_Sub_Category: car>,
<Post_Sub_Category: spare parts>,
<Post_Sub_Category: truck>,
<Post_Sub_Category: motor cycle>
]
How to access the values only and make list of them as string:
['car','spare parts','truck','motor cycle'].
the first query set seems that it gave me what I want. However, When I use following if statement. it does not executed:
if 'car' in ddd:
# do some thing
as you can see car
should be in the list. so, I could not understand why the if statement has not been executed.
any help or suggestion?
django
django
edited Nov 10 at 1:58


markwalker_
4,34853572
4,34853572
asked Nov 10 at 1:41
Saleh
728
728
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
2
down vote
accepted
I think you might need to index that. The values list actually looks like it returns a list. Can you try:
try:
ddd = ddd[0]
except IndexError:
# Catch index error
pass
if 'car' in ddd:
# do some thing
If that doesn't work, try explicitly converting your QuerySetList to a regular ole list, as in this question, like this:
ddd = list(ddd)
Also, this looks a little strange to me: category_name__category_name__iexact=dd
. Posting your corresponding models would be helpful.
The suggested answer in the link you provided me with does the work. (stackoverflow.com/questions/37140426/…)
– Saleh
Nov 10 at 2:01
The link is broken? Or usinglist
on your QuerySet didn't work?
– Scott Skiles
Nov 10 at 12:07
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
accepted
I think you might need to index that. The values list actually looks like it returns a list. Can you try:
try:
ddd = ddd[0]
except IndexError:
# Catch index error
pass
if 'car' in ddd:
# do some thing
If that doesn't work, try explicitly converting your QuerySetList to a regular ole list, as in this question, like this:
ddd = list(ddd)
Also, this looks a little strange to me: category_name__category_name__iexact=dd
. Posting your corresponding models would be helpful.
The suggested answer in the link you provided me with does the work. (stackoverflow.com/questions/37140426/…)
– Saleh
Nov 10 at 2:01
The link is broken? Or usinglist
on your QuerySet didn't work?
– Scott Skiles
Nov 10 at 12:07
add a comment |
up vote
2
down vote
accepted
I think you might need to index that. The values list actually looks like it returns a list. Can you try:
try:
ddd = ddd[0]
except IndexError:
# Catch index error
pass
if 'car' in ddd:
# do some thing
If that doesn't work, try explicitly converting your QuerySetList to a regular ole list, as in this question, like this:
ddd = list(ddd)
Also, this looks a little strange to me: category_name__category_name__iexact=dd
. Posting your corresponding models would be helpful.
The suggested answer in the link you provided me with does the work. (stackoverflow.com/questions/37140426/…)
– Saleh
Nov 10 at 2:01
The link is broken? Or usinglist
on your QuerySet didn't work?
– Scott Skiles
Nov 10 at 12:07
add a comment |
up vote
2
down vote
accepted
up vote
2
down vote
accepted
I think you might need to index that. The values list actually looks like it returns a list. Can you try:
try:
ddd = ddd[0]
except IndexError:
# Catch index error
pass
if 'car' in ddd:
# do some thing
If that doesn't work, try explicitly converting your QuerySetList to a regular ole list, as in this question, like this:
ddd = list(ddd)
Also, this looks a little strange to me: category_name__category_name__iexact=dd
. Posting your corresponding models would be helpful.
I think you might need to index that. The values list actually looks like it returns a list. Can you try:
try:
ddd = ddd[0]
except IndexError:
# Catch index error
pass
if 'car' in ddd:
# do some thing
If that doesn't work, try explicitly converting your QuerySetList to a regular ole list, as in this question, like this:
ddd = list(ddd)
Also, this looks a little strange to me: category_name__category_name__iexact=dd
. Posting your corresponding models would be helpful.
edited Nov 10 at 14:43
answered Nov 10 at 1:48


Scott Skiles
5381723
5381723
The suggested answer in the link you provided me with does the work. (stackoverflow.com/questions/37140426/…)
– Saleh
Nov 10 at 2:01
The link is broken? Or usinglist
on your QuerySet didn't work?
– Scott Skiles
Nov 10 at 12:07
add a comment |
The suggested answer in the link you provided me with does the work. (stackoverflow.com/questions/37140426/…)
– Saleh
Nov 10 at 2:01
The link is broken? Or usinglist
on your QuerySet didn't work?
– Scott Skiles
Nov 10 at 12:07
The suggested answer in the link you provided me with does the work. (stackoverflow.com/questions/37140426/…)
– Saleh
Nov 10 at 2:01
The suggested answer in the link you provided me with does the work. (stackoverflow.com/questions/37140426/…)
– Saleh
Nov 10 at 2:01
The link is broken? Or using
list
on your QuerySet didn't work?– Scott Skiles
Nov 10 at 12:07
The link is broken? Or using
list
on your QuerySet didn't work?– Scott Skiles
Nov 10 at 12:07
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53235314%2fhow-to-find-if-string-is-in-a-result-of-a-query-set-in-django%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
i j8jswHmu0UEGpT3ev qSAw KC,qdG,10BlzN79AaV XmIiHUV3UW wy iSM,R0tlNkAGYk8s6Ki7pm,YEeLuSZMTHKERWCK