Thanks Farai! Regards
Chuck G. Madamombe NAM: +264 81 842 1284 RSA: +27 78 208 7034 Twitter: @chuckygari Skype: chuckygari Facebook: Chucky Mada Madamombe LinkedIn: Chucknorris Garikayi Madamombe On Sun, 9 Feb 2020, 18:14 Farai M <[email protected]> wrote: > The status is a foreign ID u can use choices if the status is not > dynamically changed by the users . Otherwise you will need to pass the > selected status from fronted or hardcode it. > > On Sun, Feb 9, 2020, 2:58 PM Chuck G. Madamombe <[email protected]> > wrote: > >> Hello, >> >> I want to filter data in the database to retrieve only those tasks with >> status='In progress'. I have used the filter queryset, but am getting an >> error. Please help. >> >> *Here is my view (Filter tasks by their status):* >> >> def tasks_in_progress(request): >> tasks = Task.objects.filter(Status='In progress') >> context = {'tasks': tasks} >> #return render(request,"todoapp/show_task.html",{'tasks':tasks}) >> return render(request,"todoapp/tasks_in_progress.html", context) >> >> >> >> *The model.py* >> >> class Task(models.Model): >> #Task_Title = models.ForeignKey(ToDoList, on_delete=models.CASCADE) >> Task_Title = models.CharField(max_length=500) >> Task_Description = models.CharField(max_length=500) >> Priority = models.ForeignKey(Task_Priority, on_delete=models.CASCADE) >> Date_Created = models.DateTimeField(auto_now_add=True) >> Completion_Date = models.DateTimeField() >> Assigned_To = models.ForeignKey(User, blank=True, null=True, >> on_delete=models.SET_NULL) >> Status = models.ForeignKey(Task_Status, on_delete=models.CASCADE) >> >> def __str__(self): >> return self.Task_Description >> >> *The error am getting is:* >> >> ValueError at /todoapp/tasks_in_progress >> >> Field 'id' expected a number but got 'In progress'. >> >> Request Method: GET >> Request URL: http://127.0.0.1:8000/todoapp/tasks_in_progress >> Django Version: 3.0.2 >> Exception Type: ValueError >> Exception Value: >> >> Field 'id' expected a number but got 'In progress'. >> >> Exception Location: C:\Users\Chuck >> Madamombe\Desktop\djangoPROJECTS\lib\site-packages\django\db\models\fields\__init__.py >> in get_prep_value, line 1772 >> Python Executable: C:\Users\Chuck >> Madamombe\Desktop\djangoPROJECTS\Scripts\python.exe >> Python Version: 3.7.1 >> Python Path: >> >> ['C:\\Users\\Chuck Madamombe\\Desktop\\djangoPROJECTS', >> 'C:\\Users\\Chuck >> Madamombe\\Desktop\\djangoPROJECTS\\Scripts\\python37.zip', >> 'C:\\Users\\Chuck ' >> 'Madamombe\\AppData\\Local\\Programs\\Python\\Python37-32\\DLLs', >> 'C:\\Users\\Chuck ' >> 'Madamombe\\AppData\\Local\\Programs\\Python\\Python37-32\\lib', >> 'C:\\Users\\Chuck Madamombe\\AppData\\Local\\Programs\\Python\\Python37-32', >> 'C:\\Users\\Chuck Madamombe\\Desktop\\djangoPROJECTS', >> 'C:\\Users\\Chuck Madamombe\\Desktop\\djangoPROJECTS\\lib\\site-packages', >> 'C:\\Users\\Chuck ' >> >> 'Madamombe\\Desktop\\djangoPROJECTS\\lib\\site-packages\\setuptools-39.1.0-py3.7.egg'] >> >> Server time: Sun, 9 Feb 2020 10:22:05 +0200 >> >> >> But if I just retrieve all the records in the database, without >> filtering, its working without an error >> >> >> >> *My View to retrieve all the records in the database, without filtering.* >> >> def show_task(request): >> tasks = Task.objects.all() >> context = {'tasks': tasks} >> #return render(request,"todoapp/show_task.html",{'tasks':tasks}) >> return render(request,"todoapp/show_task.html", context) >> >> >> -- >> 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 view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/a13041e8-1c37-4722-bf64-4faa75dd56ff%40googlegroups.com >> <https://groups.google.com/d/msgid/django-users/a13041e8-1c37-4722-bf64-4faa75dd56ff%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- > 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 view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CAMeub5MQYn2EmMESTzbYqvkzO%3D6Qa1Rd7%3Ds2Kg%3DS9eibjX7fTw%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAMeub5MQYn2EmMESTzbYqvkzO%3D6Qa1Rd7%3Ds2Kg%3DS9eibjX7fTw%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAJaKOscZQJvDi_%2BPYO4NC%2BmewXD7E_YPhLxnATE9dh%2B018JoSg%40mail.gmail.com.
