Cheers everybody, I have two tables (video, videokeyword) involved in a many2many relationship which results in a 3rd table (video_keywords_list). A video element can have many keyword elements, and otherwise, a keyword element can have (be present) in many video elements.
Structure is: app_video: id, ...(some more info not relevant here) app_videokeyword: id, ...(same as above) app_video_keywords_list: id, video_id, videokeyword_id So I need to get the videos that match ALL the keywords that I provide in the query, like "give me all the videos that contain the keywords 'horse', 'country' and 'green'". These videos may contain another keywords or not, but I need them to contain at least ALL the keywords provided. Either solution (plain SQL soution or Django ORM solution) will be fine for me. I know the filter_interface widget is doing some sort of similar lookup whenever it is displayed in the admin, but my case has little differences... Thanks a lot, hector --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
