Django How to write Customized Query ( Display Information Departmentwise)

[Balaji Shetty]

HI

My models.py

class T1(models.Model):
    CaseNumber = models.TextField(blank=True,null=True)
    UserCurrent = models.TextField(blank=True,null=True,default='user1')
    UserCurrentDepartment = models.TextField(blank=True,null=True)

    def __str__(self):
        return '%s %s' % (self.CaseNumber , self.UserCurrentDepartment )

--------------------------------------------------------------------

 Assume Record in MODELS T1  to be entered by respectuve user are

(  I will create System User U1, U2 and U3 for IT,CS and MECH Department only.

)

CaseNumber  -- UserCurrent  --UserCurrentDepartment

 11 - U1 - iT

 12 - U1 - IT

13 - U1 - IT

 21 - U2 - CS

 22 - U2 - CS

23 - U2- CS

 31 - U3 - MECH

 32 - U3 - MECH

33 - U3 - MECH

----------------------------------

when I run the Project by creating One Superuser

http://127.0.0.1:8000/admin/appname/t1/

 

i get all records of all Users and all Departments.

I will create three user of Name U1,U2 and U3 of IT,CS and MECH Department and ask them to do CRUD Operation. I want the output in following way use rwise.

When User U1 do the login in Admin Panel, He should get only his Department Records -IT, not other department

CaseNumber    --   UserCurrent  --  UserCurrentDepartment

 11 - U1 - iT

 12 - U1 - IT

13 - U1 - IT

----------------------------------

When User U2 do the login in Admin Panel, He should get only his Department Records - CS,, not other department

CaseNumber    --   UserCurrent  --  UserCurrentDepartment

 21 - U2 - CS

 22 - U2 - CS

23 - U2- CS

----------------------------------

When User U3 do the login in Admin Panel, He should get only his Department Records - MECH, , not other department

CaseNumber    --   UserCurrent  --  UserCurrentDepartment

 31 - U3 - MECH

 32 - U3 - MECH

33 - U3 - MECH

----------------------------------

When I create superuser, he has access to all user data.

But other users U1, U2 and U3 have also access of other users Data.

So My query is how can i accomplish this Constraint.

----------------------.

How can i write a customized query so that Admin panel should display only particular Department as per respective user Deparement.-

Mr. Shetty Balaji S.
Asst. Professor
Department of Information Technology,

SGGS Institute of Engineering & Technology, Vishnupuri, Nanded.MH.India

Official: bssh...@sggs.ac.in

  Mobile: +91-9270696267

[Gourav Chawla]

First of all, use appropriate model fields for linking objects. For example users should be a foreign key to your(or Django's) user table.

Then whenever you want to show data on any interface to any user, just filter content/rows by user department.

Something like:

T1.objects.filter(user=current_user, department=current_user.department)

[Sithembewena L. Dube]

Your model fields are not cased correctly.

https://stackoverflow.com/questions/8908760/should-i-use-camel-case-or-underscores-in-python

Kind regards,
Sithu

Sent with Shift

--
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 django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAECSbOtiHTPCprTj9w168rHksoUf2TKsju-yQHZvJLw14eZ9Ag%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[Balaji Shetty]

Dear Gaurav Sir

I am very much thankful to you for your reply to my query.

My questions is How can i make  the customization in Django Admin Panel itself to implement necessary logic after user of particular department do the login.( How and where to embed proposed Logic T1.objects.filter(user=current_user, department=current_user.department)

If i design separate pages for login using templates and showing necessary content user-wise (Login wise),

Your suggested logic will definitely work  (after making necessary changes in schema)

--
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 django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/a4484706-2f3a-488c-a28c-41f78e2f42ca%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

[Gourav Chawla]

No sir please! Gourav is just fine.

Also, you would need to go edit/add code in the admin.py file for this to work.

Try this part of the docs:

https://docs.djangoproject.com/en/2.2/ref/contrib/admin/#django.contrib.admin.ModelAdmin.list_filter

Hope, it helps.