Thanks Lucas, but it is the same error: int() argument must be a string or a number, not 'list'
The id__in is an int argument, but the user_list is a list, I don't see it matchs. I tried to use *user_list, did not work either. On Friday, April 11, 2014 8:50:55 PM UTC+10, Lucas Klassmann wrote: > > Hi, > > Sorry, you must specify the field *ID*, try this: > > for user in user_object_list: > if user.is_locked(): > user_exclude_list.append(user.id) > > user_list = user_list.exclude(*id__in*=user_exclude_list) # [1, 3, 4, > 5,] IDs, is more fast > > > Cheers. > > > On Fri, Apr 11, 2014 at 7:47 AM, nobody <[email protected] > <javascript:>>wrote: > >> Hi Lucas, >> >> >> On Friday, April 11, 2014 12:07:02 PM UTC+10, Lucas Klassmann wrote: >> >>> Hi, >>> >>> You can use *ID* of object for compare with a list and *IN* : >>> >>> for user in user_object_list: >>> if user.is_locked(): >>> user_exclude_list.append(user.*id*) >>> >>> user_list = user_list.exclude(*user__in*=*user_exclude_list*) # [1, 3, >>> 4, 5,] IDs, is more fast >>> >> >> Hmm, I actually got an exception: >> >> Exception Type: TypeError Exception Value: >> >> int() argument must be a string or a number, not 'list' >> >> >> Thanks. >> >> >> >> >>> >>> Cheers. >>> >>> >>> On Thu, Apr 10, 2014 at 9:23 PM, nobody <[email protected]> wrote: >>> >>>> >>>> Thanks Lucas, sorry for not being clear, I like not to include the >>>> object when the name is matching, I figured out that can be done to use >>>> user_list.exclude, not user_list.filter. It is working currently in an >>>> inefficient way: >>>> >>>> for user in user_object_list: >>>> if user.is_locked(): >>>> user_list = user_list.exclude(user__name=user.name) >>>> >>>> Is there anyway to filter out all users to match the user exclude list >>>> in one statement such as following example (wrong syntax I guess): >>>> >>>> >>>> for user in user_object_list: >>>> if user.is_locked(): >>>> user_exclude_list.append(user.name) >>>> >>>> user_list = user_list.exclude(user__name.icontain=user_exclude_list) >>>> >>>> >>>> Thank you. >>>> >>>> >>>> >>>> >>>> On Friday, April 11, 2014 4:26:23 AM UTC+10, Lucas Klassmann wrote: >>>> >>>>> Hi, >>>>> >>>>> If you want exact match: >>>>> >>>>> user_list.filter(user__name__iexact=user.name) >>>>> >>>>> >>>>> Or containment test: >>>>> user_list.filter(user__name__icontains=user.name) >>>>> >>>>> >>>>> Note that "i" on start is for case-insensitive filtering. >>>>> >>>>> Look here for more information: >>>>> https://docs.djangoproject.com/en/dev/topics/db/queries/ >>>>> >>>>> >>>>> Cheers >>>>> >>>>> >>>>> On Thu, Apr 10, 2014 at 2:38 PM, carlos <[email protected]> wrote: >>>>> >>>>>> hi, maybe you filter you queryset >>>>>> user_list = Model.objects.filter(user__name=user.name).filter(other__ >>>>>> field=user.email) >>>>>> >>>>>> Cheers >>>>>> >>>>>> >>>>>> On Thu, Apr 10, 2014 at 9:44 AM, nobody <[email protected]> wrote: >>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> How can I filter an item from the queryset object list if the name >>>>>>> is matching? The following won't work. >>>>>>> >>>>>>> user_list.filter(user__name=user.name) >>>>>>> >>>>>>> Thank you. >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "Django users" group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to [email protected]. >>>>>>> To post to this group, send email to [email protected]. >>>>>>> >>>>>>> Visit this group at http://groups.google.com/group/django-users. >>>>>>> To view this discussion on the web visit >>>>>>> https://groups.google.com/d/msgid/django-users/dd1f2a56-1ee7 >>>>>>> -4dd5-a513-12ef1ef5e83b%40googlegroups.com<https://groups.google.com/d/msgid/django-users/dd1f2a56-1ee7-4dd5-a513-12ef1ef5e83b%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>> . >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "Django users" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to [email protected]. >>>>>> To post to this group, send email to [email protected]. >>>>>> >>>>>> Visit this group at http://groups.google.com/group/django-users. >>>>>> To view this discussion on the web visit https://groups.google.com/d/ >>>>>> msgid/django-users/CAM-7rO2SDDC%2ByLgdx_Jb%3D021gsonaE9MYn8Zcp >>>>>> TgVEqYv_PoiQ%40mail.gmail.com<https://groups.google.com/d/msgid/django-users/CAM-7rO2SDDC%2ByLgdx_Jb%3D021gsonaE9MYn8ZcpTgVEqYv_PoiQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Lucas Klassmann >>>>> Desenvolvedor de Software >>>>> >>>>> Email: [email protected] >>>>> Web site: http://www.lucasklassmann.com >>>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Django users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> To post to this group, send email to [email protected]. >>>> Visit this group at http://groups.google.com/group/django-users. >>>> To view this discussion on the web visit https://groups.google.com/d/ >>>> msgid/django-users/15365d41-a783-4108-88fc-c9b6705257f3% >>>> 40googlegroups.com<https://groups.google.com/d/msgid/django-users/15365d41-a783-4108-88fc-c9b6705257f3%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> Lucas Klassmann >>> Desenvolvedor de Software >>> >>> Email: [email protected] >>> Web site: http://www.lucasklassmann.com >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> Visit this group at http://groups.google.com/group/django-users. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/30d11ad7-51a0-4014-8c70-576122c5cf9b%40googlegroups.com<https://groups.google.com/d/msgid/django-users/30d11ad7-51a0-4014-8c70-576122c5cf9b%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Lucas Klassmann > Desenvolvedor de Software > > Email: [email protected] <javascript:> > Web site: http://www.lucasklassmann.com > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/f1e904c9-2993-423c-a202-e88349360977%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
