problem chained filter

[Luis P. Mendes]

Hi,

I want a user to select a multiple filter through check boxes.

The problem is that filtering in django doesn't return all the expected
results.  I tried both chained filtering and filters with anded
conditions and the result is no different.

I'm I missing something?  Where's the flaw?

--------- view----
def consultarFiltradasFiscalizacao(request):
    user = request.user
    r = Fiscalizacao()
    r.exercicio_2002 = request.GET.get('exercicio_2002', None)
    r.exercicio_2003 = request.GET.get('exercicio_2003', None)
    r.exercicio_2004 = request.GET.get('exercicio_2004', None)
    r.exercicio_2005 = request.GET.get('exercicio_2005', None)

    filtros =
['exercicio_2002','exercicio_2003','exercicio_2004','exercicio_2005']

    for f in filtros: setattr(r,f, \
                getattr(r,f) == 'on' and 'true' or 'false')

    print r.exercicio_2002
    print r.exercicio_2003
    print r.exercicio_2004
    print r.exercicio_2005

  #fichas =  Fiscalizacao.objects.filter(exercicio_2002=r.exercicio_2002)\
                            #.filter(exercicio_2003=r.exercicio_2003)\
                            #.filter(exercicio_2004=r.exercicio_2004)\
                            #.filter(exercicio_2005=r.exercicio_2005)
    fichas = Fiscalizacao.objects.filter(exercicio_2002=r.exercicio_2002).\
  filter(exercicio_2005=r.exercicio_2005).\
  filter(exercicio_2004=r.exercicio_2004).\
  filter(exercicio_2003=r.exercicio_2003)


 fichas = fichas.order_by('id')
 return render_to_response('fichas/fiscalizacao/todas.html', \
                    {"fichas": fichas,"user":user})

--------- output of the django server---------------------

7543
false
true
true
false
[06/Sep/2006 17:44:36] "GET
/fichas/fiscalizacao/consultar_filtradas/?exercicio_2003=on&exercicio_2004=on
HTTP/1.1" 200 5472

5 fichas returned   <---  this is INCORRECT

----------- postgreSQL--------------------
In postgresql, when I try to select the same query, I get eight results,
which is correct.

# select id from fichas_fiscalizacao where exercicio_2004 = true and
exercicio_2003 = true and exercicio_2002 = false;
 id
----
  6
  5
  4
  7
  9
 11
 10
  8
(8 rows)
---------- template ----------------------
The template has no filtering:

{% block content-main %}

    <div class="module">
    {% if fichas %}
<table>
    <tr>
      {% for ficha in fichas %}
      <td>{{ ficha.id }}</a></td>
      <td>{{ ficha.inspeccionar_nif }}</a></td>
      <td>{{ ficha.inspeccionar_nif_fk.nome|truncatewords:"2" }}</a></td>
      <td>{{ ficha.data|date:"Y-m-d" }}</a></td>
    {% if ficha.utilizador.first_name %}
      <td>{{ ficha.utilizador.first_name }} {{
ficha.utilizador.last_name }}</a></td>
    {% else %}
      <td>{{ ficha.utilizador }}</a></td>
    {% endif %}
      <td><a href="/fichas/fiscalizacao/rever/{{ ficha.id }}"
class="changelink">Rever</a></td>
      </tr>
      {% endfor %}
</table>
    {% else %}
    Não há fichas arquivadas.
    {% endif %}
    </div>


Thanks for any help,

Luis

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