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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
