Incorrect Reference "department" in request model

[MoD01]

There is something odd with the "department" field in the Requests model.

information about test parameter:

• role= django superadmin
• database = MSSQL (I know it is not compatible with MSSQL officially but I am working on it)

How to reproduce the bug:

• visit http://localhost:8000/de/456-admin/crm/request/5/change/
• click on the green +

- this leads me to /en/456-admin/auth/group/add/?_to_field=id&_popup=1

? is it correct that the "department" i a "group"?

• fill the fields with examplary data like that and save:

This results in this:

• click save at the request web form. This results in an error message and an empty value of the department field.

FYI:
the department field is not part of the requests model but the inherited model Base1. There department is defined like this:

department = models.ForeignKey(
    'auth.Group',
    blank=True,
    null=True,
    on_delete=models.CASCADE,
    verbose_name=_("Department"),
    related_name="%(app_label)s_%(class)s_department_related",
)

is it even required to have department as an mandatory field in request model (in Base1 it is marked as null=True)?

PS: maybe it is an MSSQL problem? MSSQL is not capable of doing database-side regular expressions. I already transferred one on python side to make it compatible. Maybe department also uses regular expressions to filter?

PPS: I think it is a permission problem. I had a superuser with blank groups and permissions. Now I added every permission to my user and now I see something in the departments dropdown.

[DjangoCRM]

No. Group is a parent model for the Department. Department should be added as Department, not a Group.
Please read here how to add Departments.
And one more thing. You are trying to add Request using admin site and being in superuser role. To do this, you must first select the department for which you want to add a Request.
It is better to use CRM site for this being in sales manager or operator role. Then everything will be easier.

[Calsiferian]

I have avery similar error, even when creating the request with a user with the role of operator or manager. When I try to create a request, the department select does not show the departments associated with the user, whether they have multiple or just one. Also, no options appear in the owner dropdown.

[DjangoCRM]

That's because you used the Admin site.
Please use the CRM website.
In this case, your username should be specified in the Owner field automatically.
And in the Department drop-down menu there will be departments in which users with the manager role are defined.