On Tue, May 13, 2014 at 1:00 AM, Anthony Hawkes <lifesillus...@gmail.com> wrote: > Hi Guys, > > I need to replace results in a queryset and then perform counts and further > queries on the set and have been trying to find a way of doing it.
What do you mean by "replace results"? > > Basically in some but not all cases I get a set of results eg select * from > table and then I want to do a: case when column = 'some value' then 'some > other value'. > > Is there any way using django's queries or at least preserving the ability > to continue using the queries using raw sql? (I've had a look at extra() but > can't see a way to make it work) > I'm not really sure what any of this means.. Let me throw some sample code at you qs = Model.objects.all() if foo: qs = qs.filter(column='some value') else: qs = qs.filter(column_b='some other value') num_results = qs.count() Is that what you are after? Cheers Tom -- 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 post to this group, send email to django-users@googlegroups.com. 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/CAFHbX1J-NT2R5WxHeS6Qaw_ZjZCn6N4g%3DcP6Ta8gVE3MqsBP7Q%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
