On Sun, Apr 19, 2009 at 8:48 PM, bweiss <weissmanbia...@gmail.com> wrote:
> > I'm working on a database project which controls details related to > the employees of a company. > > It includes a table called "Qualifications", which has details of all > the industry certifications and training courses obtained by > employees. This table is connected via ForeignKey fields to two other > tables - "Employees", which has the names and other basic details of > the employees, and "Qualification Types", which has the names and > other information about the training courses (eg. name, certifying > body, etc etc). > > So to enter a Qualification obtained, users choose a name from the > data in the Employee table, and a Qualification Type from the data in > that table, and then enter the remaining details (eg. date obtained, > expiry date). > > Until now I've only written fairly basic views - requests that will > find a list of qualifications of type X, or belonging to employee Y, > or expiring in month Z. > > Now I'm trying to write a request view that will find the employees > that DON'T have an associated qualification of a particular type. > > I'm really struggling with how to perform this sort of "negative" > filtering on related objects. > > Can anyone tell me if this is even possible, and if so, how I might go > about it? > > Many thanks in advance for any help, > > BWeiss > > > > If I follow correctly you're just looking to do the opposite of what you're already doing, so far you using the filter() method, so what you need is the opposite of that. Luckily we have just the thing! The exclude() method, http://docs.djangoproject.com/en/dev/ref/models/querysets/#exclude-kwargs Alex -- "I disapprove of what you say, but I will defend to the death your right to say it." --Voltaire "The people's good is the highest law."--Cicero --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
