please, maybe anyone now how to perform distinct() filtering for certain attribute(column), not the whole objects(rows)? :)
In case not - please tell me what's the best practice when coming to a situation when django orm is not powerfull enough. Can writting custom sql queries become a serious problem later on? i could, of course, write a custom SQL query and get the result as tuples, but that's only for representation of data, manipulation gets realy tricky, as you can't refer to the given data as the objects of django. And there is that feeling that after the first custom sql query, 10 more new will be neccessary later on and you may end up writting all the webapp the good-old SQLObject way. and for the main question - if i mislooked something in the docs, just please write rtfm or something, just to let me understand it's a well documented feature, just i don't find it. Thanks everyone, enjoy the day, j On Dec 9, 2:15 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Here comes the question about the proper usage of queryset's distinct > () method. As i have a queryset model.objects.filter > (column='name').distinct() , the distinct method is applied to whole > objects, but i'd like it to be applied to column. Django makes SQL > query "SELECT DISTINCT column, column2, column3 from TABLE WHERE > 'column'='name'. How could i tell django to make querie SELECT > DISTINCT column from TABLE WHERE 'column'='name' so that the > comparison would be made for the single attribute , not for whole > objects. As i guess performing such filtering in SQL server is much > resource-savy than in view level, or template level of django. thanks > for any ideas! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
