# Filter users by group in form calss

**URL:** <https://forum.djangoproject.com/t/filter-users-by-group-in-form-calss/10414>\
**Category:** Using Django\
**Created:** [November 5, 2021, 2:28pm UTC](https://forum.djangoproject.com/t/filter-users-by-group-in-form-calss/10414 "2021-11-05T14:28:07Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![smailt](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/smailt/32/8270_2.png) [@smailt](https://forum.djangoproject.com/u/smailt)\
**Post date:** [November 5, 2021, 2:28pm UTC](https://forum.djangoproject.com/t/filter-users-by-group-in-form-calss/10414/1 "2021-11-05T14:28:07Z")

</div>

Hi, I want to save data about users in tables as presented below:  
Models.py

```auto
class Operation_count(models.Model):
    EventID = models.PositiveIntegerField()
    ModelID = models.CharField(max_length=50)
    Workers = models.ForeignKey(settings.AUTH_USER_MODEL,related_name='Workers_event',on_delete=models.CASCADE)
    post_date = models.DateTimeField(auto_now_add=True)
    author = models.ForeignKey(settings.AUTH_USER_MODEL,related_name='create_posts',on_delete=models.CASCADE)
    def __str__ (self):
        return self.EventID
    def get_absolute_url(self):
        return reverse('WellNetwork')
    class Meta:
        ordering = ('-post_date',)

```

and the issue is in the `Workers` field so I have many users then I need to filter them according to the current user group and their group, this is the form I use:

```auto
class Operation_count_F(forms.ModelForm):
    EventID = forms.IntegerField(required=False)    
    ModelID = forms.CharField(required=False)
    Workers = forms.ModelChoiceField(label='Co-Worker', queryset=User.objects.all())
    class Meta:
        model= Operation_count
        fields=('EventID','ModelID','Workers')

```

So here I can’t call the current user and its group and then filter all users that belongs to the same user.  
How I do to solve this?  
I use a function by the way in views.py

```auto
def post_EvWorks(request, Evt_id): 
    form = Operation_count_F()
    if request.method == 'POST':
            pass
    elif request.POST.get("form_Glift") == "Save Parameters":
            print("Save Parameters")
            form =form(request.POST)
            if form.is_valid():
                form.instance.author = request.user
                form.save()
                return redirect('Events', Evt_id)
            else:
                form_errorGL = 'Check your file Name'

```

---

<div class="post-metadata">

**Author:** ![KenWhitesell](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/kenwhitesell/32/280_2.png) [@KenWhitesell](https://forum.djangoproject.com/u/KenWhitesell)\
**Post date:** [November 5, 2021, 5:24pm UTC](https://forum.djangoproject.com/t/filter-users-by-group-in-form-calss/10414/2 "2021-11-05T17:24:57Z")

</div>

You’ve got a couple different options:

- You can modify the form to accept parameters, pass the parameter in through the constructor call, and use that parameter in the form to modify the form field.

- Modify the form field directly after the form has been constructed, in the view.

---

<div class="post-metadata">

**Author:** ![smailt](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/smailt/32/8270_2.png) [@smailt](https://forum.djangoproject.com/u/smailt)\
**Post date:** [November 5, 2021, 5:33pm UTC](https://forum.djangoproject.com/t/filter-users-by-group-in-form-calss/10414/3 "2021-11-05T17:33:45Z")

</div>

> [@KenWhitesell](#):
>
> form

Many thanks, but your answers are getting hard to understand and need to post them as a question in other topics.

think this site is for experts only and I need to find another place to post questions.

All my best

---

<div class="post-metadata">

**Author:** ![KenWhitesell](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/kenwhitesell/32/280_2.png) [@KenWhitesell](https://forum.djangoproject.com/u/KenWhitesell)\
**Post date:** [November 5, 2021, 5:45pm UTC](https://forum.djangoproject.com/t/filter-users-by-group-in-form-calss/10414/4 "2021-11-05T17:45:24Z")

</div>

Or, you _could_ ask for further clarification if necessary. You’ve been an active member here for more than 4 months now - it’s tough to judge just how far you’ve come and what level of detail is necessary for any particular question you may ask.

---

<div class="post-metadata">

**Author:** ![smailt](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/smailt/32/8270_2.png) [@smailt](https://forum.djangoproject.com/u/smailt)\
**Post date:** [November 6, 2021, 1:42pm UTC](https://forum.djangoproject.com/t/filter-users-by-group-in-form-calss/10414/5 "2021-11-06T13:42:28Z")

</div>

Hi, many thanks,

this solution workes for me, I just filtered the users in the views.py before passed to form.py as:

```auto
def post_EvWorks(request, Evt_id):
    All_group = request.user.groups.all()
    theGroup= All_group.exclude(name='Service_head')
    theGroup= theGroup.exclude(name='Admin_stuff').first()
    print(request.user, 'post_EvWorks3', theGroup )
    form = Operation_count_F()
    form.fields['Workers'].queryset = User.objects.filter(groups__name=theGroup)
    if request.method == 'POST':
        if request.POST.get("form_uplod") == "Add file":
            pass
        elif request.POST.get("form_Glift") == "Save Parameters":
            print("Save Parameters")
            form =form(request.POST)
            if form.is_valid():
                form.instance.author = request.user
                form.save()
                return redirect('Events', Evt_id)
            else:
                form_errorGL = 'Check your Name'

```

so key is in this line

```auto
   form.fields['Workers'].queryset = User.objects.filter(groups__name=theGroup)

```

many thanks