Thank you. I got it.. Issue with timezone By default django considering TIME_ZONE = 'UTC' USE_TZ = True
Thats the reason it was showing less records than actual.. I changed it local to local time zone name and USE_TZ = False Its working perfectly.. I also understood that its not only to database views, its also applicable to tables also. Kindly make sure to change above two lines in setting according to ur local time zone to render correct records. Thank you. On Tue, Aug 27, 2019, 10:02 PM Doddahulugappa.B <[email protected]> wrote: > Thanks for your response. > > In Django models.. For example > > class TempUser(models.Model): > first_name = models.CharField(max_length=100) > > class Meta: > managed = False > db_table = "temp_user" > > > > temp_user is database view. > > Now assume select * from temp_user > > Gives 5 records > > > Same model if i register in admin panel. > > It will show less records than 5. > > Even if i do TempUser.Objects.Count() > > It will show less records than 5. > > > Very rare case it show exactly what view is having otherwise most of the time > it fails to show exact records. > > I observed this since many days in 3 to 4 projects of my django > > > > > On Tue, Aug 27, 2019, 9:01 PM Jani Tiainen <[email protected]> wrote: > >> Hi. >> >> You really need to provide more context. Without knowing your data, >> tables involved in a view. Your model and query you used and query you used >> to verify wrong (or correct) results it is virtually impossible to help you >> further. >> >> >> ti 27. elok. 2019 klo 17.47 HULUGESH B <[email protected]> >> kirjoitti: >> >>> Hi All, >>> >>> >>> I am facing issues in Django Models: >>> >>> If connect databse views in models. >>> >>> It shows less records than actual number of records. Kindly assist me. >>> How to solve. This is not all the time.. sometimes it is correct sometimes >>> not correct. >>> >>> -- >>> 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/29c228cc-295a-487e-a5df-afb1471b8730%40googlegroups.com >>> <https://groups.google.com/d/msgid/django-users/29c228cc-295a-487e-a5df-afb1471b8730%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/CAHn91ocVY%2B-Z-9_GYKa0gbT5MCg%2Bh%2BvBzfLEgVf5QmnArV%2BaZw%40mail.gmail.com >> <https://groups.google.com/d/msgid/django-users/CAHn91ocVY%2B-Z-9_GYKa0gbT5MCg%2Bh%2BvBzfLEgVf5QmnArV%2BaZw%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/CAKfjjGoar7k6qQqb%2BoOBv5S3SY-z6a4aeKdjdh_7MsR7BdZ%2BPA%40mail.gmail.com.
