How to delete user salary record , but want to keep history till deleted date

[Feroz Ahmed]

Hi,

How to delete user salary record , but want to keep history till deleted date.

ex:

1. Month June
2. Month July
3. Month Aug
4. delete user record from Sep.

[pankaj palmate]

Then simply make that records inactive by adding one flag in table and instead of deleting make It inactive 

--
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 view this discussion on the web visit https://groups.google.com/d/msgid/django-users/f2ba2f5f-ed12-45e5-8d2a-d2b1b2590154n%40googlegroups.com.

[Feroz Ahmed]

Hi, Pankaj

thanks for the tips!

i try all the way, 

it not success , any syntax please.

mean time i success to delete the record code as below: (but i just want to inactive the record of particular employee) history might need for audit purpose.

def delete(request,id):
        employee=Employee.objects.get(id=id)
        employee.delete()
        return redirect('/home1')

Regards

[Julio Cojom]

As Pankaj mentioned, add a field in your model called status or something like that. On the makemigrations set all status as 'Active'

Then, your function will not delete, will update the object.

def delete(request,id):
        employee=Employee.objects.get(id=id)
        employee.status = 'Inactive'
        return redirect('/home1')

in your listview, you should only show active records, for that add an exclude to the queryset.

queryset = Model.objects.exclude(status='Inactive') 

or with a filter

queryset = Model.objects.filter(status='Active') 

If you want to use delete, I've used before django-simple-history. the package records all history for models and objects and let you query that information.

Regards,

Julio Cojom.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/7ebc8721-d3c1-4f2b-8c18-384820a8483fn%40googlegroups.com.

[Feroz Ahmed]

No errors: but no any actions, 

all records shows in home1.html

not excluding the Inactive records.

def delete(request,id):
        employee=Employee.objects.get(id=id)
        employee.status='Inactive'
        return redirect('/home1')

--------------------------------------------
#listview

def home1(request):
        employees=Employee.objects.exclude(status='Inactive')
        return render(request,'asgapp/home1.html',{'e':employees})

[Feroz Ahmed]

Hi , it works,

it was my confusion,, 

i update record status as Inactive so , it hide the record.

thanks for your support