Hi,
I want to let a user of one application to be able to filter results in
a complex way.
There are twelve variables, all boolean, that can be used to perform
these filters. In PostgreSQL, all data for these variables are thus
saved as either True of False.
There is no difficulty to apply individual filters. My problem regards
the combination of a variable number of filters.
The user is presented with twelve radio boxes. If he/she chooses to
filter by var3 and var4, code should be built as, for ex.,
Animals.objects.filter(var3=True).filter(var4=True)
or as Animals.objects.filter(var3=True, var4=True)
In these cases, I want to filter all records where var3 and var4 are
True, and all other variables are either True or False.
But if he chooses to apply five filters, there will have to be five
filter methods appended, or five key=values pairs as arguments.
I tried to build an expression with all filter methods sequentially
where only the value of the pair key=value would change, like:
Animals.objects.filter(var1=a).filter(var2=b).filter(var3=c).filter(var4=d)....
and so on. But if so, is there any value for a, b, c, etc that would
result in a non-filtering situation, like '*' in SQL?
On the other hand, I could hard code every combination of filters
possible, but there's for sure a simple way to achieve what I want.
I tried to play with getattr but my difficulty was that var3, and all
the others are included inside parenthesis not as strings, but as names
of model's attributes.
Since filter accepts a keyword argument, I also tried to use a
dictionary as {"var3":True,"var4":False} but with no success.
Please, I would very much appreciate your help on this. How can achieve
what I want.
Luis P. Mendes
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
