Thats good, but now I need to turn those id's back into content types.
>From there I need to get the model's verbose plural name also.
The idea is a view where the types of assets are listed, Rooms,
Projectors, etc.
BTW, if you couldn't tell from the sql statement before, this is a
booking application.
On Jun 5, 2:19 pm, Daniel Roseman <roseman.dan...@googlemail.com>
wrote:
> On Jun 5, 6:56 pm, "eric.frederich" <eric.freder...@gmail.com> wrote:
>
>
>
> > How can I get distinct content_types from a model like this?...
>
> > In sqlite I did the following and it worked...
> > sqlite> select distinct content_type_id from booking_managedasset;
>
> > class ManagedAsset(models.Model):
> > content_type = models.ForeignKey(ContentType)
> > object_id = models.PositiveIntegerField()
> > content_object = generic.GenericForeignKey('content_type',
> > 'object_id')
> > name = models.CharField(max_length=100, unique=True,
> > help_text='Asset Name')
> > slug = models.SlugField(max_length=100, unique=True,
> > help_text='Slug')
>
> > This works in Django but it is getting all objects from the database
> > and then using Python to make them distinct.
> > set([ma.content_type for ma in ManagedAsset.objects.all()])
>
> > Is there a way to accomplish this using Django queries?
>
> ManagedAsset.objects.values_list('content_type', flat=True).distinct()
> --
> DR.
--~--~---------~--~----~------------~-------~--~----~
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
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
