Hello, what you want to achieve is called "natural order sorting" which is not built into any common SQL implementation I know. You have to do it manually from code, or, if you have to do pagination, add a sorting column that is numeric (and indexed).
Best, Gergely On 28 Sep 2015 08:42, "gintare" <[email protected]> wrote: > Is it possible to order the query result strings in such a way that th128 > string would be first comparing to th99. > The query results contains 128 items in format: "th"+number. For instance, > th1, th2, ...th80, ..th99, th100, th128. > Than i order results, they go in the following order, th1, th10,th100, > th101,th102,... th11,th110, ... th2, th20, th21,th22,.. th9,..th99. > Thus i am not able to get the largest result, which is th128. I am getting > th99 instead. > > def temp(request): > query = request.GET.get( 'q','') > #a=Aref5.objects.filter(Rname__contains='book').count() #finds128 > > a=Aref5.objects.filter(Rname__contains='book').order_by('-Rname')[0:1].get() > #gets aref5 object > print(a.Rname) #prints th99 instead of th128, which logically is larger > return render_to_response('Ath.html', {"query": query}) > > -- > 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 post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/django-users. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/69e26bab-210e-4137-adf3-498855d0eae6%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/69e26bab-210e-4137-adf3-498855d0eae6%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CACczBU%2Bi0tVFhMypH7VuPKe9c%2B_-tk8ofdwyMgyAA1h3V4vtAw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
