That's great the way you found the workaround :D We can also try writing raw sql queries to use sql functions https://docs.djangoproject.com/en/2.2/topics/db/sql/#executing-custom-sql-directly But that has some security issues since we have to pass a search parameter into it.
On Mon, 21 Jun 2021 at 22:46, Wai Yeung <w...@sapienml.com> wrote: > Thanks for the quick response Lalit, > > Django "Round" rounds to the nearest integer whereas SQLite "round" allows > you to pass in a second parameter to to round "rounded to Y digits to the > right of the decimal point" (https://sqlite.org/lang_corefunc.html#round). > > That said, since Django "Round" doesn't support this second parameter, I > still used it by multiplying the value by 1000, then rounded the value and > then divided the value by 1000. This still didn't result in a value with 2 > decimal places as some values have a '0' in the second decimal place (i.e. > "2.10" would be "2.1" > > To address the search portion, the search values for any search value that > had trailing zeroes were modified. So if the search was for "2.10", the > modified search would be for "2.1". > > Cheers, > Wai > > On Sat, Jun 19, 2021 at 5:53 AM Lalit Suthar <sutharlalit...@gmail.com> > wrote: > >> this can help >> https://docs.djangoproject.com/en/2.2/ref/models/database-functions/#round >> >> On Fri, 18 Jun 2021 at 22:43, Wai Yeung <w...@sapienml.com> wrote: >> >>> Hello, >>> >>> To be able to get a REAL value from a SQLite database rounded to 2 >>> decimal places, I had to use the following RAW SQL query: >>> >>> SELECT >>> printf("%.2f", round(orig_total,2)), >>> FROM final_billing_tbl >>> >>> I would like to be able to duplicate the functionality of the in ORM to >>> create a queryset. I need the result in the queryset because later in the >>> procedure, I search the queryset as follows: >>> >>> queryset = queryset.filter( Q( orig_total __icontains=search_value) ) >>> >>> The search_value would be a value that would rounded to 2 decimal places. >>> >>> Thanks in Advance, >>> Wai >>> >>> >>> >>> -- >>> 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+unsubscr...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/django-users/b89b27f3-a11c-4b2c-8473-59420c7c3f26n%40googlegroups.com >>> <https://groups.google.com/d/msgid/django-users/b89b27f3-a11c-4b2c-8473-59420c7c3f26n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "Django users" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/django-users/D72IUtA1uqQ/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> django-users+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/CAGp2JVHr3hQ03XGnOGO0i13gWhw1%3D%2Bv51BcbHAOfAb0u5V4_tg%40mail.gmail.com >> <https://groups.google.com/d/msgid/django-users/CAGp2JVHr3hQ03XGnOGO0i13gWhw1%3D%2Bv51BcbHAOfAb0u5V4_tg%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 django-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CAKDLG%3DRq-YhQeGKfFk5vy24Kqdyyk-FG6OzQRnE0DMEwPtzbMg%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAKDLG%3DRq-YhQeGKfFk5vy24Kqdyyk-FG6OzQRnE0DMEwPtzbMg%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 django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAGp2JVG_VRKS8z6Ws%3D93NP-wov01%3DT%2BKqeC_nkyfjOSP7GJ0ag%40mail.gmail.com.
